Advance Excel

Count

To count the number of cells that contain numbers, use the COUNT function.

Link: https://www.excel-easy.com/functions/count-sum-functions.html#count

Sheet: https://www.excel-easy.com/functions/excel-files/count-sum-functions.xlsx

Countif for Numeric Value

You can use the COUNTIF function in Excel to count cells that contain a specific value, count cells that are greater than or equal to a value, etc.

Link: :https://www.excel-easy.com/examples/countif.html

sheet: https://www.excel-easy.com/examples/excel-files/countif.xlsx

If | And | Or | Not

sheet: https://www.excel-easy.com/functions/excel-files/logical-functions.xlsx

Switch

This example teaches you how to use the SWITCH function in Excel 2016 instead of the IFS function.

1a. For example, the IFS function below finds the correct states.

Link : https://www.excel-easy.com/examples/switch.html

Sheet: https://www.excel-easy.com/examples/excel-files/switch.xlsx


sum

sumif

sumifs

vlookup

hlookup

if

nestedif

text function

date and time function

and

or

index


Exercise Sheets:-


pivot Table

https://www.excel-easy.com/data-analysis/pivot-tables.html