Formulas and Functions Master Class
This Formulas and Functions master class targets individuals who want to immerse themselves into Excel Formulas and Functions for Data Analysis, Summarizing Data, Automating Reports, Date functions for calculating time and sales reports, financial functions for building financial models and many more.
Duration: 5 Hours (Live Online and In-person Training) – flexible timings
Cost: Kes. 6000.00/Person.
Among other functions we will cover:
- Formulas for Summarizing Data e.g SUM, SUMIFS, COUNTIF ..
- Logical Functions: IF, AND, OR, …
- DATE and TIME functions
- Look up functions: VLOOKUP, INDEX, MATCH, INDIRECT, HLOOKUP, LOOKUP
- INFORMATION FUNCTIONS
- FINANCE FUNCTIONS: PMT, FVSCHEDULE (Creating Amortization schedules and Time Value for Money
And many more….