## 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.

## 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...

## 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.

## 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.

## Identify VAT rate based on country using VLOOKUP

To identify a VAT rate based on a simple tax rate table, you can use the VLOOKUP function. For this example we have also used a Data Validation List.

## Count birthdays between dates using COUNTIFS

In Excel you can easily count the number of cells with values between two dates using the COUNTIFS function.

## Sum sales by year using SUMIFS

If you are looking to create a breakdown of yearly sales based on a list of transactions you can use the SUMIFS function.

## How to change case in Excel to UPPER, lower or Proper

Learn how to change text case to UPPER, lower or Proper format and combine text from different cells to obtain the desired result.

## Count cells equal to a specific value

Counting cells that equal to a specific value can be achieved using COUNTIF function. If you need to use multiple criteria you can also use COUNTIFS.

## Subtotal by item type using SUMIF

If you need to calculate subtotals based on item type (or whatever common criteria), you can easily do so using the SUMIF function.