Module 2: Important Excel Functions and Formulas

Formulas and Functions in Excel

Click on links for further details

1. Understanding basic arithmetic formulas
2. Using SUM, AVERAGE, COUNT and other essential functions
3. Working with logical functions (IF, AND, OR)
4. Advanced lookup functions (VLOOKUP, HLOOKUP, INDEX/MATCH)