Course Overview

The Advanced Excel for Professionals course is designed to equip working professionals with advanced skills for data analysis, financial modelling, reporting, automation, and evidence-based decision-making. The course provides practical training in advanced Excel formulas, data management, PivotTables, dashboards, Power Query, forecasting, and automation. Participants will work with realistic business datasets to develop efficient and professional Excel-based solutions for workplace applications.

Target Participants

  • Finance and accounting professionals
  • Business and data analysts
  • Managers and supervisors
  • Project and programme professionals
  • Monitoring and evaluation professionals
  • Human resource professionals
  • Procurement and supply chain professionals
  • Banking and financial services professionals
  • Administrative and operations professionals
  • Consultants and business professionals
  • Professionals responsible for reporting and data analysis
  • Entrepreneurs and business owners

Course Objectives

By the end of the course, participants will be able to:

  • Apply advanced Excel formulas and functions to complex professional tasks.
  • Analyse large and complex datasets efficiently.
  • Use advanced lookup, logical, statistical, and financial functions.
  • Develop professional financial and business models.
  • Create and analyse PivotTables and PivotCharts.
  • Design interactive dashboards and management reports.
  • Clean, transform, and organize data for analysis.
  • Use Power Query to automate data preparation and transformation.
  • Apply forecasting, scenario analysis, and what-if analysis.
  • Create effective charts and data visualizations.
  • Automate repetitive Excel tasks using macros and basic VBA.
  • Develop accurate and professional reports for management decision-making.
  • Improve workplace productivity through advanced Excel techniques.

Course Outline

Module 1: Advanced Excel for Professional Productivity

  • Advanced Excel interface and navigation
  • Workbook and worksheet optimization
  • Excel tables and structured references
  • Named ranges
  • Professional spreadsheet design
  • Excel shortcuts and productivity techniques

Module 2: Advanced Formulas and Functions

  • Advanced logical functions
  • XLOOKUP and advanced lookup techniques
  • INDEX and MATCH
  • SUMIFS, COUNTIFS and AVERAGEIFS
  • IF, IFS and nested functions
  • Text and date functions
  • Dynamic array functions
  • Error handling and formula auditing

Module 3: Professional Data Management

  • Data preparation and cleaning
  • Removing duplicates and inconsistencies
  • Data validation
  • Advanced sorting and filtering
  • Text-to-columns
  • Managing large datasets
  • Data integrity and quality control

Module 4: Advanced PivotTables and PivotCharts

  • Creating advanced PivotTables
  • Grouping and summarizing data
  • Calculated fields
  • PivotCharts
  • Slicers and timelines
  • Interactive reporting
  • Management information dashboards

Module 5: Advanced Data Analysis and Visualization

  • Selecting appropriate visualizations
  • Advanced charting techniques
  • Combination charts
  • Dynamic charts
  • Conditional formatting
  • KPI dashboards
  • Interactive professional dashboards
  • Data storytelling

Module 6: Financial and Business Modelling

  • Financial modelling principles
  • Budget preparation and analysis
  • Revenue and expenditure analysis
  • Profitability analysis
  • Variance analysis
  • Cash-flow modelling
  • Investment and project analysis
  • Sensitivity analysis

Module 7: What-If Analysis and Forecasting

  • Goal Seek
  • Scenario Manager
  • Data Tables
  • Forecasting techniques
  • Trend analysis
  • Scenario modelling
  • Business planning applications

Module 8: Power Query for Professionals

  • Introduction to Power Query
  • Importing data from multiple sources
  • Data transformation
  • Merging and appending datasets
  • Automated data cleaning
  • Creating repeatable workflows
  • Refreshing professional reports

Module 9: Excel Automation

  • Introduction to Excel macros
  • Recording and running macros
  • Automating repetitive tasks
  • Basic VBA concepts
  • Automated reporting
  • Introduction to VBA-based productivity solutions

Module 10: Professional Reporting and Decision Support

  • Designing management reports
  • Building executive dashboards
  • Linking multiple worksheets and workbooks
  • Report automation and refresh
  • Presenting analytical findings
  • Protecting and sharing professional workbooks

 

Course Schedules:

Dates Fees Location Apply
23/11/2026 - 27/11/2026 $1500 Nairobi, Kenya Physical Class Online Class
23/11/2026 - 27/11/2026 $2500 Kigali, Rwanda Physical Class Online Class
23/11/2026 - 27/11/2026 $2000 Mombasa, Kenya Physical Class Online Class
30/11/2026 - 04/12/2026 $1500 Nairobi, Kenya Physical Class Online Class
30/11/2026 - 04/12/2026 $2500 Kigali, Rwanda Physical Class Online Class
30/11/2026 - 04/12/2026 $6000 Mauritius Physical Class Online Class
30/11/2026 - 04/12/2026 $2500 Dar es Salaam, Tanzania Physical Class Online Class
30/11/2026 - 04/12/2026 $2000 Mombasa, Kenya Physical Class Online Class
07/12/2026 - 11/12/2026 $5000 Singapore, Singapore Physical Class Online Class
07/12/2026 - 11/12/2026 $1500 Nairobi, Kenya Physical Class Online Class
07/12/2026 - 11/12/2026 $5000 Dubai, UAE Physical Class Online Class
07/12/2026 - 11/12/2026 $4500 Pretoria, South Africa Physical Class Online Class
07/12/2026 - 11/12/2026 $4000 Johannesburg, South Africa Physical Class Online Class
14/12/2026 - 18/12/2026 $1500 Nairobi, Kenya Physical Class Online Class
14/12/2026 - 18/12/2026 $5000 Dubai, UAE Physical Class Online Class
21/12/2026 - 25/12/2026 $5000 Singapore, Singapore Physical Class Online Class
21/12/2026 - 25/12/2026 $2500 Kigali, Rwanda Physical Class Online Class
21/12/2026 - 25/12/2026 $1500 Nairobi, Kenya Physical Class Online Class
28/12/2026 - 01/01/2027 $1500 Nairobi, Kenya Physical Class Online Class
28/12/2026 - 01/01/2027 $4500 Pretoria, South Africa Physical Class Online Class
28/12/2026 - 01/01/2027 $4000 Johannesburg, South Africa Physical Class Online Class
28/12/2026 - 01/01/2027 $2500 Dar es Salaam, Tanzania Physical Class Online Class
04/01/2027 - 08/01/2027 $2000 Mombasa, Kenya Physical Class Online Class
04/01/2027 - 08/01/2027 $1500 Nairobi, Kenya Physical Class Online Class
11/01/2027 - 15/01/2027 $1500 Nairobi, Kenya Physical Class Online Class
11/01/2027 - 15/01/2027 $6000 Mauritius Physical Class Online Class
11/01/2027 - 15/01/2027 $5000 Dubai, UAE Physical Class Online Class
18/01/2027 - 22/01/2027 $1500 Nairobi, Kenya Physical Class Online Class
18/01/2027 - 22/01/2027 $2500 Kigali, Rwanda Physical Class Online Class
25/01/2027 - 29/01/2027 $2000 Mombasa, Kenya Physical Class Online Class
25/01/2027 - 29/01/2027 $1500 Nairobi, Kenya Physical Class Online Class
25/01/2027 - 29/01/2027 $2500 Dar es Salaam, Tanzania Physical Class Online Class
01/02/2027 - 05/02/2027 $2500 Dar es Salaam, Tanzania Physical Class Online Class
01/02/2027 - 05/02/2027 $4500 Pretoria, South Africa Physical Class Online Class
01/02/2027 - 05/02/2027 $4000 Johannesburg, South Africa Physical Class Online Class
01/02/2027 - 05/02/2027 $5000 Singapore, Singapore Physical Class Online Class
01/02/2027 - 05/02/2027 $6000 Mauritius Physical Class Online Class
01/02/2027 - 05/02/2027 $1500 Nairobi, Kenya Physical Class Online Class
08/02/2027 - 12/02/2027 $6000 Mauritius Physical Class Online Class
08/02/2027 - 12/02/2027 $5000 Dubai, UAE Physical Class Online Class
08/02/2027 - 12/02/2027 $1500 Nairobi, Kenya Physical Class Online Class
08/02/2027 - 12/02/2027 $4500 Pretoria, South Africa Physical Class Online Class
08/02/2027 - 12/02/2027 $2000 Mombasa, Kenya Physical Class Online Class
15/02/2027 - 19/02/2027 $1500 Nairobi, Kenya Physical Class Online Class
15/02/2027 - 19/02/2027 $5000 Singapore, Singapore Physical Class Online Class
15/02/2027 - 19/02/2027 $2500 Kigali, Rwanda Physical Class Online Class
22/02/2027 - 26/02/2027 $2500 Dar es Salaam, Tanzania Physical Class Online Class
22/02/2027 - 26/02/2027 $4000 Johannesburg, South Africa Physical Class Online Class
22/02/2027 - 26/02/2027 $1500 Nairobi, Kenya Physical Class Online Class
01/03/2027 - 05/03/2027 $1500 Nairobi, Kenya Physical Class Online Class
08/03/2027 - 12/03/2027 $5000 Dubai, UAE Physical Class Online Class
08/03/2027 - 12/03/2027 $4500 Pretoria, South Africa Physical Class Online Class
08/03/2027 - 12/03/2027 $2000 Mombasa, Kenya Physical Class Online Class
08/03/2027 - 12/03/2027 $4000 Johannesburg, South Africa Physical Class Online Class
08/03/2027 - 12/03/2027 $1500 Nairobi, Kenya Physical Class Online Class
15/03/2027 - 19/03/2027 $1500 Nairobi, Kenya Physical Class Online Class
15/03/2027 - 19/03/2027 $2500 Kigali, Rwanda Physical Class Online Class
15/03/2027 - 19/03/2027 $6000 Mauritius Physical Class Online Class
15/03/2027 - 19/03/2027 $5000 Singapore, Singapore Physical Class Online Class
22/03/2027 - 26/03/2027 $1500 Nairobi, Kenya Physical Class Online Class
22/03/2027 - 26/03/2027 $2500 Dar es Salaam, Tanzania Physical Class Online Class
22/03/2027 - 26/03/2027 $4500 Pretoria, South Africa Physical Class Online Class
22/03/2027 - 26/03/2027 $4000 Johannesburg, South Africa Physical Class Online Class
29/03/2027 - 02/04/2027 $1500 Nairobi, Kenya Physical Class Online Class
29/03/2027 - 02/04/2027 $5000 Dubai, UAE Physical Class Online Class
05/04/2027 - 09/04/2027 $1500 Nairobi, Kenya Physical Class Online Class
12/04/2027 - 16/04/2027 $5000 Singapore, Singapore Physical Class Online Class
12/04/2027 - 16/04/2027 $2500 Kigali, Rwanda Physical Class Online Class
12/04/2027 - 16/04/2027 $6000 Mauritius Physical Class Online Class
12/04/2027 - 16/04/2027 $2000 Mombasa, Kenya Physical Class Online Class
12/04/2027 - 16/04/2027 $1500 Nairobi, Kenya Physical Class Online Class
19/04/2027 - 23/04/2027 $2000 Mombasa, Kenya Physical Class Online Class
19/04/2027 - 23/04/2027 $1500 Nairobi, Kenya Physical Class Online Class
19/04/2027 - 23/04/2027 $5000 Singapore, Singapore Physical Class Online Class
19/04/2027 - 23/04/2027 $5000 Dubai, UAE Physical Class Online Class
26/04/2027 - 30/04/2027 $4000 Johannesburg, South Africa Physical Class Online Class
26/04/2027 - 30/04/2027 $1500 Nairobi, Kenya Physical Class Online Class
26/04/2027 - 30/04/2027 $2500 Kigali, Rwanda Physical Class Online Class
26/04/2027 - 30/04/2027 $2500 Dar es Salaam, Tanzania Physical Class Online Class
03/05/2027 - 07/05/2027 $1500 Nairobi, Kenya Physical Class Online Class
03/05/2027 - 07/05/2027 $6000 Mauritius Physical Class Online Class
03/05/2027 - 07/05/2027 $4500 Pretoria, South Africa Physical Class Online Class
10/05/2027 - 14/05/2027 $4500 Pretoria, South Africa Physical Class Online Class
10/05/2027 - 14/05/2027 $4000 Johannesburg, South Africa Physical Class Online Class
10/05/2027 - 14/05/2027 $5000 Singapore, Singapore Physical Class Online Class
10/05/2027 - 14/05/2027 $1500 Nairobi, Kenya Physical Class Online Class
10/05/2027 - 14/05/2027 $2500 Kigali, Rwanda Physical Class Online Class
17/05/2027 - 21/05/2027 $2000 Mombasa, Kenya Physical Class Online Class
17/05/2027 - 21/05/2027 $6000 Mauritius Physical Class Online Class
17/05/2027 - 21/05/2027 $1500 Nairobi, Kenya Physical Class Online Class
17/05/2027 - 21/05/2027 $5000 Dubai, UAE Physical Class Online Class
17/05/2027 - 21/05/2027 $2500 Dar es Salaam, Tanzania Physical Class Online Class
24/05/2027 - 28/05/2027 $1500 Nairobi, Kenya Physical Class Online Class
31/05/2027 - 04/06/2027 $5000 Dubai, UAE Physical Class Online Class
31/05/2027 - 04/06/2027 $1500 Nairobi, Kenya Physical Class Online Class
31/05/2027 - 04/06/2027 $4000 Johannesburg, South Africa Physical Class Online Class
31/05/2027 - 04/06/2027 $5000 Singapore, Singapore Physical Class Online Class
07/06/2027 - 11/06/2027 $2500 Dar es Salaam, Tanzania Physical Class Online Class
07/06/2027 - 11/06/2027 $1500 Nairobi, Kenya Physical Class Online Class
07/06/2027 - 11/06/2027 $4500 Pretoria, South Africa Physical Class Online Class
07/06/2027 - 11/06/2027 $2500 Kigali, Rwanda Physical Class Online Class
14/06/2027 - 18/06/2027 $2000 Mombasa, Kenya Physical Class Online Class
14/06/2027 - 18/06/2027 $1500 Nairobi, Kenya Physical Class Online Class
14/06/2027 - 18/06/2027 $6000 Mauritius Physical Class Online Class
21/06/2027 - 25/06/2027 $6000 Mauritius Physical Class Online Class
21/06/2027 - 25/06/2027 $5000 Dubai, UAE Physical Class Online Class
21/06/2027 - 25/06/2027 $2000 Mombasa, Kenya Physical Class Online Class
21/06/2027 - 25/06/2027 $4000 Johannesburg, South Africa Physical Class Online Class
21/06/2027 - 25/06/2027 $1500 Nairobi, Kenya Physical Class Online Class
28/06/2027 - 02/07/2027 $2500 Dar es Salaam, Tanzania Physical Class Online Class
28/06/2027 - 02/07/2027 $1500 Nairobi, Kenya Physical Class Online Class
05/07/2027 - 09/07/2027 $2500 Kigali, Rwanda Physical Class Online Class
05/07/2027 - 09/07/2027 $1500 Nairobi, Kenya Physical Class Online Class
05/07/2027 - 09/07/2027 $4500 Pretoria, South Africa Physical Class Online Class
05/07/2027 - 09/07/2027 $5000 Singapore, Singapore Physical Class Online Class
12/07/2027 - 16/07/2027 $1500 Nairobi, Kenya Physical Class Online Class
12/07/2027 - 16/07/2027 $5000 Dubai, UAE Physical Class Online Class
19/07/2027 - 23/07/2027 $6000 Mauritius Physical Class Online Class
19/07/2027 - 23/07/2027 $1500 Nairobi, Kenya Physical Class Online Class
19/07/2027 - 23/07/2027 $4500 Pretoria, South Africa Physical Class Online Class
26/07/2027 - 30/07/2027 $2500 Dar es Salaam, Tanzania Physical Class Online Class
26/07/2027 - 30/07/2027 $1500 Nairobi, Kenya Physical Class Online Class
26/07/2027 - 30/07/2027 $2000 Mombasa, Kenya Physical Class Online Class
02/08/2027 - 06/08/2027 $5000 Singapore, Singapore Physical Class Online Class
02/08/2027 - 06/08/2027 $2500 Kigali, Rwanda Physical Class Online Class
02/08/2027 - 06/08/2027 $1500 Nairobi, Kenya Physical Class Online Class
02/08/2027 - 06/08/2027 $4000 Johannesburg, South Africa Physical Class Online Class
09/08/2027 - 13/08/2027 $1500 Nairobi, Kenya Physical Class Online Class
09/08/2027 - 13/08/2027 $5000 Dubai, UAE Physical Class Online Class
16/08/2027 - 20/08/2027 $1500 Nairobi, Kenya Physical Class Online Class
16/08/2027 - 20/08/2027 $5000 Singapore, Singapore Physical Class Online Class
16/08/2027 - 20/08/2027 $2500 Dar es Salaam, Tanzania Physical Class Online Class
23/08/2027 - 27/08/2027 $4000 Johannesburg, South Africa Physical Class Online Class
23/08/2027 - 27/08/2027 $1500 Nairobi, Kenya Physical Class Online Class
23/08/2027 - 27/08/2027 $2500 Kigali, Rwanda Physical Class Online Class
23/08/2027 - 27/08/2027 $6000 Mauritius Physical Class Online Class
23/08/2027 - 27/08/2027 $2500 Dar es Salaam, Tanzania Physical Class Online Class
23/08/2027 - 27/08/2027 $4500 Pretoria, South Africa Physical Class Online Class
23/08/2027 - 27/08/2027 $2000 Mombasa, Kenya Physical Class Online Class
30/08/2027 - 03/09/2027 $4500 Pretoria, South Africa Physical Class Online Class
30/08/2027 - 03/09/2027 $2000 Mombasa, Kenya Physical Class Online Class
30/08/2027 - 03/09/2027 $4000 Johannesburg, South Africa Physical Class Online Class
30/08/2027 - 03/09/2027 $5000 Singapore, Singapore Physical Class Online Class
30/08/2027 - 03/09/2027 $1500 Nairobi, Kenya Physical Class Online Class
30/08/2027 - 03/09/2027 $5000 Dubai, UAE Physical Class Online Class
06/09/2027 - 10/09/2027 $2500 Kigali, Rwanda Physical Class Online Class
06/09/2027 - 10/09/2027 $1500 Nairobi, Kenya Physical Class Online Class
13/09/2027 - 17/09/2027 $6000 Mauritius Physical Class Online Class
13/09/2027 - 17/09/2027 $1500 Nairobi, Kenya Physical Class Online Class
20/09/2027 - 24/09/2027 $1500 Nairobi, Kenya Physical Class Online Class
20/09/2027 - 24/09/2027 $4500 Pretoria, South Africa Physical Class Online Class
20/09/2027 - 24/09/2027 $2000 Mombasa, Kenya Physical Class Online Class
20/09/2027 - 24/09/2027 $4000 Johannesburg, South Africa Physical Class Online Class
27/09/2027 - 01/10/2027 $2500 Dar es Salaam, Tanzania Physical Class Online Class
27/09/2027 - 01/10/2027 $1500 Nairobi, Kenya Physical Class Online Class
27/09/2027 - 01/10/2027 $6000 Mauritius Physical Class Online Class
27/09/2027 - 01/10/2027 $5000 Dubai, UAE Physical Class Online Class
04/10/2027 - 08/10/2027 $1500 Nairobi, Kenya Physical Class Online Class
04/10/2027 - 08/10/2027 $5000 Singapore, Singapore Physical Class Online Class
04/10/2027 - 08/10/2027 $2500 Kigali, Rwanda Physical Class Online Class