ExcelExplained

How to use COUNTIF function in Excel

Step by step instructions on how to use COUNTIF function in Excel. Download the example workbook to better understand how to use COUNTIF.

How to use VLOOKUP function in Excel

VLOOKUP was created to lookup and retrieve data from a specific column in a table. It support approximate and exact matching and wildcards (* ?)

How to use EOMONTH function in Excel

Excel's EOMONTH function returns the last day of a month, N months in the future or the past.

Category - Functions

Beautiful Excel line chart

Improve your Excel skills

Learn how to work with functions, create complex formulas and design beautiful charts. All free.

You have Successfully Subscribed!