INTENSIVE  EXCEL FUNCTIONS & FORMULAS

Happening on 27 Oct 2021
Selling Price: RM350/pax
Duration: 1 day

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(