+254 114 413 862info@vantageafricaleaders.com Astrol Business Center Thika Road Nairobi, 6th Floor, Room C603

Advanced Microsoft Excel Training Course

“Learn practical advanced tools and techniques to assist in reducing the time spent in Microsoft Excel.”

How well can you use Microsoft Excel to analyse data for decision-making? Give yourself the gift of knowledge and master spreadsheets. Register today for a 5-day highly practical and vibrant Advanced Excel Training.
In this Live training, you will learn concepts such as Using Lookup Formulas and Formula Auditing, Sharing and Protecting Workbooks, Automating Workbook Functionality, Creating Spark lines and Mapping Data, Forecasting Data among many others

Who is this course for? (Target Audience)

The Advanced MS Excel training courses is for anyone who:
Wants to learn practical tools and techniques to assist in reducing the time spent in Excel. We can train from beginner to intermediate to advanced, and cover topics like Data Visualization, Financial Modelling, Pivot Tables and Excel fundamentals.

What can you achieve by taking this course?

  • Apply advanced formulas to lay data in readiness for analysis

  • Use advanced techniques for report visualizations

  • Leverage on various methodologies of summarizing data

  • Understand and apply basic principles of laying out Excel models for decision making

Objectives of the course

  • To teach participants the advanced formulas as well as how to use which formula for which occasion.

  • To equip participants with the knowledge on how to debug and audit the advanced formulas.

  • To explore the magic of analysing data using Advanced Excel.

Certification of the Advance Excel Course

Wants to learn practical tools and techniques to assist in reducing the time spent in Excel. We can train from beginner to intermediate to advanced, and cover topics like Data Visualization, Financial Modelling, Pivot Tables and Excel fundamentals.

Course Requirement

Interested organizations/institutions/individuals are expected to have laptop(s) while attending the classes and should at least have some background in using Excel.

Duration and Venue

2-3 Weeks, 3 days each week (Mon-Wed)
Live ZOOM/KENET/Google Meet classes from 8:00pm to 9.30pm EAT.

Course Outline

The course will cover:

  • Working with multiple Worksheets and Workbooks

  • Using Lookup Formulas and Formula Auditing

  • Sharing and Protecting Workbooks

  • Automating Workbook Functionality

  • Creating Spark lines and Mapping Data

  • Forecasting Data

Request a call Back


Zoom classes

Watch Videos

Advanced Excel Training
See M&E Training in your country