Course Overview:
Advanced Excel Pivot Tables is an advanced practical course designed to equip participants with sophisticated skills for analyzing large and complex datasets using Microsoft Excel. The course goes beyond basic PivotTable functionality to cover advanced calculations, data grouping, calculated fields, multiple data sources, PivotCharts, slicers, timelines, Power Query integration, and dynamic reporting. Participants will learn how to transform complex datasets into insightful analytical and management reports.

Target Participants:

  • Finance and accounting professionals
  • Business and data analysts
  • Managers and supervisors
  • Financial analysts
  • Sales and marketing professionals
  • HR and operations professionals
  • Monitoring and evaluation professionals
  • Project and programme managers
  • Researchers and reporting professionals
  • Advanced Excel users

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

  • Create and manage advanced PivotTables.
  • Analyze large and complex datasets efficiently.
  • Use advanced PivotTable calculations and value display options.
  • Create calculated fields and calculated items where appropriate.
  • Perform percentage, variance, ranking, and trend analysis.
  • Group dates, numbers, and categories for deeper analysis.
  • Connect PivotTables to multiple data sources.
  • Create advanced PivotCharts and interactive reports.
  • Use slicers and timelines for dynamic data analysis.
  • Integrate PivotTables with Power Query workflows.
  • Refresh and maintain dynamic PivotTable reports.
  • Build sophisticated management and analytical reports.

Course Outline:

  1. Advanced PivotTable Fundamentals
    • Review of PivotTable architecture
    • Advanced field management
    • PivotTable layouts and customization
    • Working with large datasets
  2. Advanced Data Preparation
    • Structuring complex datasets
    • Excel Tables and named ranges
    • Data cleaning and validation
    • Preparing multiple data sources
    • Data consistency and quality
  3. Advanced PivotTable Calculations
    • Calculated fields
    • Calculated items
    • Custom calculations
    • Percentage of total
    • Percentage difference
    • Running totals
    • Index and ranking analysis
  4. Advanced Grouping and Filtering
    • Date grouping
    • Monthly, quarterly, and annual analysis
    • Numerical grouping
    • Custom grouping
    • Advanced filtering
    • Top/Bottom analysis
  5. Time-Series and Trend Analysis
    • Period comparisons
    • Year-on-year analysis
    • Month-on-month analysis
    • Cumulative totals
    • Growth analysis
    • Variance analysis
  6. Advanced PivotCharts
    • Creating PivotCharts
    • Selecting appropriate visualizations
    • Combination charts
    • Trend analysis
    • Dynamic chart filtering
    • Professional chart formatting
  7. Slicers and Timelines
    • Advanced slicer configuration
    • Multiple slicers
    • Connecting slicers to multiple PivotTables
    • Timeline controls
    • Interactive reporting
  8. PivotTables and Power Query
    • Importing external datasets
    • Cleaning data with Power Query
    • Combining datasets
    • Transforming data
    • Loading transformed data into PivotTables
    • Refreshing analytical reports
  9. Advanced Analytical Reporting
    • Financial analysis
    • Sales and revenue analysis
    • HR analytics
    • Inventory analysis
    • Project performance analysis
    • Operational performance reporting
  10. Interactive PivotTable Reporting
    • Designing analytical report layouts
    • Integrating multiple PivotTables
    • Linking PivotCharts and slicers
    • Creating interactive reporting tools
    • Protecting and sharing reports

 

Course Schedules:

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