Course Overview:
Excel Pivot Tables for Professionals is a practical, professional-level course designed to develop participants’ ability to analyze, summarize, and present complex datasets using Excel PivotTables. The course focuses on advanced data analysis, performance reporting, trend analysis, interactive reporting, PivotCharts, slicers, timelines, and Power Query. Participants will learn how to convert large datasets into clear, actionable reports for professional and organizational use.

Target Participants:

  • Finance and accounting professionals
  • Business and data analysts
  • Sales and marketing professionals
  • HR and administration professionals
  • Project and programme professionals
  • Monitoring and evaluation professionals
  • Operations and procurement professionals
  • Researchers and reporting officers
  • Professionals responsible for data analysis and reporting
  • Experienced Excel users

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

  • Create professional PivotTable reports from large datasets.
  • Prepare and structure data for efficient PivotTable analysis.
  • Summarize financial, operational, and organizational data.
  • Apply advanced filtering, sorting, and grouping techniques.
  • Perform percentage, variance, ranking, and trend analysis.
  • Use calculated fields and advanced value calculations.
  • Analyze data across different periods and categories.
  • Create professional PivotCharts for data visualization.
  • Use slicers and timelines for interactive analysis.
  • Integrate Power Query with PivotTable reporting.
  • Refresh and maintain dynamic analytical reports.
  • Interpret PivotTable results for professional reporting and decision-making.

Course Outline:

  1. Professional PivotTable Fundamentals
    • PivotTable concepts and applications
    • PivotTable structure
    • Working with large datasets
    • Professional reporting requirements
  2. Data Preparation
    • Preparing source data
    • Excel Tables
    • Data cleaning and validation
    • Handling missing and duplicate records
    • Data quality management
  3. Creating Professional PivotTables
    • Building PivotTables
    • Managing fields
    • Rows, columns, values, and filters
    • Layout and formatting options
    • Professional report design
  4. Advanced PivotTable Analysis
    • Calculated fields
    • Percentage of total
    • Difference from previous periods
    • Running totals
    • Ranking
    • Variance analysis
  5. Grouping and Time-Based Analysis
    • Grouping dates
    • Monthly and quarterly analysis
    • Annual analysis
    • Financial-period reporting
    • Trend analysis
    • Year-on-year comparisons
  6. Filtering and Interactive Analysis
    • Advanced filters
    • Top and Bottom analysis
    • Label and value filters
    • Slicers
    • Timelines
  7. PivotCharts and Visualization
    • Creating PivotCharts
    • Selecting appropriate charts
    • Trend and comparison charts
    • Dynamic visualization
    • Professional chart formatting
  8. Power Query and PivotTables
    • Importing external data
    • Cleaning and transforming data
    • Combining datasets
    • Loading data into PivotTables
    • Refreshing reports
  9. Professional Reporting Applications
    • Financial reporting
    • Sales and revenue analysis
    • Human resource reporting
    • Procurement and expenditure analysis
    • Inventory analysis
    • Project performance reporting
  10. Interactive Analytical Reports
    • Combining multiple PivotTables
    • Connecting slicers
    • Integrating PivotCharts
    • Designing interactive reports
    • Report protection and sharing

 

Course Schedules:

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