An Excel pivot table lets your team summarise thousands of rows into a clear, decision-ready report in seconds, without formulas. BOTI’s one-day Excel pivot table course trains your staff to build, format and analyse pivot tables and pivot charts on real workbooks, on-site or at your venue anywhere in South Africa. The course sits within BOTI’s accredited IT End User Computing offering (Services SETA / MICT SETA); these unit-standard qualifications are migrating to the new QCTO system, so please confirm current accreditation when you book.

Why Excel pivot table skills matter for your team

A critical component of Microsoft Excel are the chart and table graphics that can be applied to worksheets and workbooks to make the presentation of data easier to understand and more visually appealing and professional. Pivot tables sit at the centre of that capability. When a finance, sales or operations team can pivot a raw export from your accounting, CRM or ERP system, they stop waiting on a single “Excel person” and start answering their own questions: faster reporting, fewer errors, and cleaner board packs.

For South African businesses, this is also a measurable upskilling investment. Accredited training delivered through the Services SETA / MICT SETA (these unit-standard qualifications are migrating to the new QCTO system) supports your workplace skills plan and can count toward your B-BBEE skills-development spend, which is targeted at 6% of the leviable amount (note this is separate from the Skills Development Levy of 1% of payroll). Training is treated here as general guidance; speak to your skills-development facilitator for how it applies to your scorecard.

Course overview

This one-day workshop focuses on Excel’s pivot table functionality. By the end of the day, participants can take a flat data set and produce summarised, grouped, filtered and chart-ready reports that update as the underlying data changes.

Who should attend

This course is intended for anyone who already has a working knowledge of Excel and would like to broaden their knowledge regarding pivot tables. It suits finance and accounts teams, sales and operations analysts, HR and payroll administrators, and managers who need to turn data exports into summaries without writing complex formulas.

Course content and outline

The curriculum covers seven main sections, building from fundamentals to advanced reporting:

1. Data Efficiency — maximising pivot table options and defining the analytical questions your report must answer.
2. Pivot Table Fundamentals — layout, contents, results, and the importance of a clean data source.
3. Adjustments and Formatting — adding and removing fields, formatting numbers, sorting, and auto-show features.
4. Intermediate Operations — creating quarterly groups, subtotals, slicers, and formatting reports.
5. Advanced Calculations — custom calculations, multiple data fields, percentage displays, and formulas.
6. Calculated Fields and Items — using formulas, the GETPIVOTDATA function, and external data integration.
7. Advanced Topics — pivot charts, web publishing, and multiple range sources.

Excel pivot tables: summarise data fast

The core promise of a pivot table is speed. To summarise a data set, your team drags the field they want grouped (for example, Region or Month) into the Rows area, drags the number they want measured (for example, Sales or Hours) into the Values area, and Excel instantly aggregates every matching row. What might take a stack of SUMIFS formulas becomes a three-step, drag-and-drop summary that recalculates the moment you refresh.

On the day, participants practise the fast-summary workflow on realistic business data:

• Pick the right source. A clean, single-header table with no blank rows is the foundation of every reliable pivot table. We cover preparing data so it summarises correctly the first time.
• Drag to summarise. Build a summary by Rows, Columns, Values and Filters, then switch the value calculation from Sum to Count, Average, Max or % of total in a couple of clicks.
• Group and drill. Group dates into months or quarters, group numbers into bands, and double-click any figure to drill into the rows behind it.
• Filter with slicers. Add slicers so non-technical colleagues can filter a finished report by region, product or date without touching the pivot itself.
• Refresh, don’t rebuild. When new data arrives, a single Refresh updates the whole report, so monthly and weekly reporting becomes a repeatable routine, not a rebuild.

This is the section most teams adopt fastest, because it replaces hours of manual summarising with a layout they can reuse every reporting cycle. It is also the natural stepping stone toward Microsoft Power BI, where the same pivot thinking scales into interactive dashboards.

Building pivot reports and pivot charts

A pivot table answers “what are the numbers?” A pivot chart answers “what does the trend look like?” In the advanced portion of the course, participants turn summarised tables into pivot charts that move and filter alongside the underlying data, so a single refreshed report drives both the figures and the visuals in a management pack.

Pivot reporting skills covered include:

• Pivot charts linked live to the pivot table, with slicers controlling both at once.
• Calculated fields and items to add margin %, variance or per-unit metrics that do not exist in the raw data.
• GETPIVOTDATA to pull a specific pivot figure into a fixed dashboard cell.
• Multiple range sources and external data to consolidate several sheets or systems into one report.

The result is a reusable reporting template your team owns: the kind of standardised monthly pack that cuts review time across a department.

How this fits BOTI’s wider Excel and data curriculum

The pivot table course is one focused day. Many organisations pair it with broader Excel and data training so the whole team levels up together:

• Accredited Microsoft Office Excel Intermediate — build the formula and data-handling foundation that makes pivot tables sing.
• Advanced Microsoft Office Excel (Accredited) — logical and lookup functions, data analysis, and automation for power users.
• Creating Spectacular Graphs and Charts with Excel — turn pivot output into presentation-ready visuals.
• Microsoft Power BI Basics Training Course — take pivot thinking into interactive business-intelligence dashboards.

Not sure where your team sits? Book a free 15-minute training needs callback and we will map the right sequence.

Accreditation, certification and delivery

The Microsoft Excel Pivot Tables Course is accredited through the Services SETA / MICT SETA as part of BOTI’s IT End User Computing offering; these unit-standard qualifications are migrating to the new QCTO system, so accredited enrolment is available now — please confirm current accreditation when you book. Each participant receives a certificate of attendance on completion. Training is delivered off-site or in-house, so we bring the course to your team at your premises, at a venue, or live online, in all major South African city centres including Johannesburg, Cape Town, Durban and Pretoria, as well as remotely.

BOTI is an accredited training provider — Services SETA 12582, MICT SETA ACC/2016/07/0045, and a QCTO Quality Partner. Because BOTI delivers corporate training across 450 courses to clients including Sasol, Glencore and the City of Johannesburg, your team learns in a format built for working professionals, on your data, on your schedule.

Frequently asked questions

What is an Excel pivot table used for?
A pivot table summarises large data sets into a compact, interactive report, grouping, totalling and filtering thousands of rows without formulas. Teams use it for monthly sales, finance, HR and operations reporting that refreshes as new data arrives.

How long is the BOTI Excel pivot table course?
It is a one-day workshop. Participants finish able to build, format, group, filter and chart pivot tables on real business data, and receive a certificate of attendance.

Do participants need prior Excel experience?
Yes. The course is intended for anyone who already has a working knowledge of Excel and wants to broaden their knowledge of pivot tables. Teams needing fundamentals first can start with BOTI’s Intermediate Excel course.

Is the training accredited, and can it count toward B-BBEE?
Yes. The course is accredited through the Services SETA / MICT SETA as part of BOTI’s IT End User Computing offering; these unit-standard qualifications are migrating to the new QCTO system, so accredited enrolment is available now — please confirm current accreditation when you book. Accredited skills training can support your skills-development spend, which targets 6% of the leviable amount. This is general guidance; confirm specifics with your skills-development facilitator.

Can BOTI run this on-site for our whole team?
Yes. The course is delivered in-house or on-site at your premises, at a venue, or live online, anywhere in South Africa, and tailored to your own workbooks.

Ready to upskill your team?

Give your staff the single Excel skill that pays back every reporting cycle. Request a quote or a free 15-minute callback to scope an in-house Excel pivot table day for your team, and ask about our free Excel pivot table quick-reference guide and funded-training options to support your workplace skills plan.

Phone BOTI on 011-882-8853 or visit boti.co.za to book.