- Call: +254 184 263 663
- Email: training(@)plezafriqueinstitute.org
- Home
- Categories
- Research, Data Management & Data Analytics Courses
- Accounting, Finance & Taxation Courses
- Audit, Compliance and Governance Training
- Leadership, Supervision & Management
- Professional Communication & Interpersonal Skills
- Project Management & Agile Methodologies
- Financial Acumen for Non-Financial Managers
- Customer Service & Client Experience (CX)
- Sales, Negotiation & Revenue Growth
- Cybersecurity, Data Privacy & Information Security
- Data Analytics, Business Intelligence & AI Literacy
- Operations, Quality Control & Lean Six Sigma
- Workplace Wellness, Productivity & Compliance
- Data, Statistics & Analytics
- Engineering, Construction & Technical
- Real Estate, Insurance & Risk
- Administration, Governance & Records
- About Us
- Courses
- News
- Contact Us
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:
- Introduction to Excel PivotTables
- What are PivotTables?
- Uses and benefits
- PivotTable components
- Understanding rows, columns, values, and filters
- Preparing Data for PivotTables
- Structuring datasets
- Excel Tables
- Data cleaning and validation
- Handling missing and duplicate records
- Preparing data for analysis
- Creating PivotTables
- Creating a basic PivotTable
- Selecting data sources
- Adding and removing fields
- Rearranging fields
- Changing PivotTable layouts
- Summarizing and Analyzing Data
- Sum and count
- Average, minimum, and maximum
- Percentage calculations
- Subtotals and grand totals
- Value display options
- Filtering and Grouping
- Report filters
- Sorting and filtering
- Grouping dates
- Grouping numerical data
- Grouping categories
- Advanced PivotTable Analysis
- Calculated fields
- Calculated items
- Running totals
- Percentage of totals
- Difference from previous periods
- Ranking and comparative analysis
- PivotCharts
- Creating PivotCharts
- Selecting appropriate chart types
- Formatting PivotCharts
- Linking PivotCharts to PivotTables
- Interactive visual analysis
- Slicers and Timelines
- Creating slicers
- Using multiple slicers
- Connecting slicers to reports
- Creating timelines
- Interactive data filtering
- Refreshing and Managing PivotTables
- Refreshing data
- Changing data sources
- Refreshing multiple PivotTables
- Maintaining dynamic reports
- Troubleshooting common PivotTable issues
- 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 |
No upcoming dates for this location.


