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.

Essential functions

Background image

How to use COUNTIF function in Excel

In this article, I will focus on how to use COUNTIF function in Excel. The purpose of COUNTIF is to count cells that meet a single criteria. If you need more criteria in your formula, then COUNTIFS function is a much...

Popular formulas