Course Overview:
Excel Pivot Tables is a practical training course designed to equip participants with the skills required to summarize, analyze, and present large datasets efficiently using Microsoft Excel PivotTables. The course covers data preparation, PivotTable creation, filtering, grouping, calculated fields, PivotCharts, slicers, and interactive reporting. Participants will work with practical datasets to generate meaningful insights and develop professional Excel reports.

Target Participants:

  • Finance and accounting professionals
  • Business and data analysts
  • Managers and supervisors
  • Sales and marketing professionals
  • HR and administration professionals
  • Project and programme officers
  • Monitoring and evaluation professionals
  • Operations and procurement professionals
  • Students and researchers
  • Professionals who use Excel for reporting and data analysis

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

  • Understand the principles and applications of PivotTables.
  • Prepare datasets for PivotTable analysis.
  • Create and customize PivotTables.
  • Summarize large volumes of data efficiently.
  • Sort, filter, group, and rearrange data.
  • Calculate totals, averages, percentages, and other statistics.
  • Create calculated fields and calculated items where appropriate.
  • Analyze trends and patterns using PivotTables.
  • Create PivotCharts for visual data analysis.
  • Use slicers and timelines for interactive reporting.
  • Refresh and update PivotTable reports.
  • Develop professional management reports using PivotTables.

Course Outline:

  1. Introduction to Excel PivotTables
    • What are PivotTables?
    • Uses and benefits
    • PivotTable components
    • Understanding rows, columns, values, and filters
  2. Preparing Data for PivotTables
    • Structuring datasets
    • Excel Tables
    • Data cleaning and validation
    • Handling missing and duplicate records
    • Preparing data for analysis
  3. Creating PivotTables
    • Creating a basic PivotTable
    • Selecting data sources
    • Adding and removing fields
    • Rearranging fields
    • Changing PivotTable layouts
  4. Summarizing and Analyzing Data
    • Sum and count
    • Average, minimum, and maximum
    • Percentage calculations
    • Subtotals and grand totals
    • Value display options
  5. Filtering and Grouping
    • Report filters
    • Sorting and filtering
    • Grouping dates
    • Grouping numerical data
    • Grouping categories
  6. Advanced PivotTable Analysis
    • Calculated fields
    • Calculated items
    • Running totals
    • Percentage of totals
    • Difference from previous periods
    • Ranking and comparative analysis
  7. PivotCharts
    • Creating PivotCharts
    • Selecting appropriate chart types
    • Formatting PivotCharts
    • Linking PivotCharts to PivotTables
    • Interactive visual analysis
  8. Slicers and Timelines
    • Creating slicers
    • Using multiple slicers
    • Connecting slicers to reports
    • Creating timelines
    • Interactive data filtering
  9. Refreshing and Managing PivotTables
    • Refreshing data
    • Changing data sources
    • Refreshing multiple PivotTables
    • Maintaining dynamic reports
    • Troubleshooting common PivotTable issues
  10. Practical PivotTable Applications
    • Financial analysis
    • Sales analysis
    • HR reporting
    • Inventory analysis
    • Project performance analysis
    • Management reporting

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