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