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(