
Intensive Excel Functions & Formulas
What will you learn in this program?
-Cell & Sheet References, Name References, Tables References
- Number functions General Number Aggregation functions
- SUM(), COUNT(), AVERAGE(), MAX(), MIN()
- Text functions
-COUNTBLANK(), COUNTA(), LEFT(), RIGHT(), MID(), FIND()
- Date and Time calculation
- Logical Related Calculation IF()
- Logical Comparison
- Nested function/Formula, Array formula, - Database related functions
- VLOOKUP() & MATCH(