fbpx
Madonna House, Westlands Road - Nairobi
+254790706395
info@opencastlabs.co.ke

Formulas and Functions Training

Formulas and Functions Master Class

Formulas and Functions with Excel Training
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….