OpenCastLabs.co.ke

Advanced Excel Training

This course is for the professional using Excel to develop superior Excel reports using Advanced Functions and Formulas, Macros and VBA and all the data tools.

Sign up for wither individuals or corporate training delivered either in-house or online at your convenience.

Modules and Course Content

Module I – Named Ranges, Data Validation, Model Sensitivities

Module II – Pivot Tables and Pivot Charts

Module III – Formulas and Functions

Module IV – Macros and Introduction to VBA

Module V – Charts and Visualization (Excel Dashboards)

Module VI – Working with External Data & Introduction to Power Query for Excel

What You Get

  • Training Materials on DVD
  • Certificate of Attendance
  • Free Post-Training Support
  • Inclusion on our weekly Microsoft Excel pro-tips mailing list

Delivered by OpenCastLabs Consulting (OCL Learning) in Nairobi, Mombasa, Nakuru, Kisumu, Eldoret and Eastern African Countries.

Our Customers

Download Course Outline Below (PDF)

Advanced Excel & Modeling Master Class – Class Modules

Talk to us

Request for Proposal

 

Advanced Excel Training | OpenCastLabs Consulting | info@opencastlabs.co.ke | +254722831259