ExcelExplained

How to use INDEX and MATCH functions in Excel for complex lookup

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 find duplicates in Excel using Conditional Formatting

Learn how to find duplicates in Excel. Perform the check in the same column or compare two different sheets, using conditional formatting or formulas.

Get first day of the month

To get the first day of the month for a given date, you can use two simple approaches: using EOMONTH function or using DAY function.

Category - Formulas

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!