This course gives advanced excel skills with participants being able to apply complex functions within Excel to manage, manipulate, analyze and visualize data. Microsoft Excel is the most commonly used analytics, reporting and strategy software. Becoming an expert data analyst requires you to have mastery of advanced Excel skills.

Course Objectives

At the end of this training you will be able to:

  • Master advanced formulas and functions
  • Consolidate data, link and export data
  • Create sophisticated outputs including tables, charts, and graph
  • Use What-If Analysis tools such as Goal Seek, Solver and Scenarios
  • Increase interactivity by automating spreadsheets with macros and VBA
  • Turn raw data into ‘must make’ decisions using PivotTables and PowerPivots.

target Participants

This course is aimed at professionals who have basic to intermediate Excel skills and want to advance those skills.

Course Duration

5 Days

Topics are:

Data Validation; Referencing in Excel; Working with Structured tables; Formulas and Functions; What If Analysis; Pivot Tables and Pivot Charts; Excel Macros; Charts and Visualizations; Working External Data

Detailed Course Description

For detailed course description and content write to


To register, please download the application form below and submit to

Training topics can be requested by writing to

Cost: USD 750 for individuals; 650 for groups above 10 participants.

Training fee includes conference package (training venue, tea/coffee, lunch, snacks, wifi etc)

× Talk to us!