How to use VLOOKUP in Excel (2020)
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 IF function in Excel
This is a step-by-step guide on how to use IF function in Excel. It includes several IF formula examples, an introduction on how to use nested IF formulas, and the [...]
How to use INDEX and MATCH functions in Excel
If you want to take your Excel skills to a new level, you have to learn how to use INDEX And MATCH, combine multiple functions and write complex formulas.
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 EOMONTH function in Excel
Excel's EOMONTH function returns the last day of a month, N months in the future or the past.
How to use SUM, SUMSQ, SUMIF and SUMIFS functions in Excel
Understanding SUMIF and SUMIFS functions in Excel is easier than you think and provides great flexibility and increased speed when performing quick analysis.
Excel is a very complex application, and understanding it on your own may prove difficult and time-consuming. I have created ExcelExplained.com to help you better understand each function and provide useful examples for different tasks. If you can’t find the answer to your question in one of the published articles, please leave a comment or send me an email, and I will do my best to help you out.

Affiliate Disclosure: When you purchase a product through a link on our website, I may earn an affiliate commission. There are no additional costs to you.
Copyright © 2017-2021 ExcelExplained.com