Free Training & Career Tips... Subscribe to Get Weekly Career Tips
By Subscribing You are Agreeing to Terms and Conditions
Excel dashboard training teaches your managers and analysts to turn scattered spreadsheets into a single, clear, decision-ready view, using PivotTables, charts, slicers and formulas to track the numbers that actually run the business. BOTI runs this as a hands-on, facilitator-led 2-day course, part of its range of Microsoft Office and computer skills courses. It is delivered to whole teams in-house at your premises, at BOTI’s venue in Sunningdale, Johannesburg, or live online, so your reports stop being static data dumps and start driving decisions.
Courses on this topic at BOTI today
- Excel Pivot Tables, Dashboards and Power Pivot (2 days)
- Data Analytics Fundamentals with Excel and Power BI (3 days)
- Creating Spectacular Charts and Graphs in Excel (1 day)
At your offices anywhere in South Africa, live online or at a BOTI venue.
See all Microsoft Office and Computer Skills coursesGet a quote for your teamLearning on your own? Self-paced e-learning from R595 (excl. VAT) · Ask your employer to pay
Many managers spend hours each month copying figures between sheets and emailing different versions of the same report. They still cannot answer a simple “how are we tracking?” This course closes that gap with practical Excel dashboard skills, taught to your staff and built on your data. Ask BOTI for a quote for your team.
The business problem: data everywhere, insight nowhere
Most South African businesses are not short of data. They are short of a clear view of it. Sales sit in one workbook, finance in another and operations in a third, and every month somebody rebuilds the same report by hand. The result is predictable:
- Slow reporting. Managers spend days assembling figures instead of acting on them, so decisions lag a month behind reality.
- No single source of truth. Three people send three versions of “the numbers”, and meetings argue about whose spreadsheet is right.
- Insight buried in rows. A 5,000-line export tells you nothing at a glance. Without a dashboard, trends, outliers and risks stay invisible until they become problems.
- Key-person risk. One person “owns” the critical spreadsheet, and when they are on leave, reporting stops.
A well-built Excel dashboard deals with each of these problems:
- It pulls the right numbers into one place.
- It updates with a refresh instead of a rebuild.
- It shows performance at a glance, so your managers spend their time deciding rather than assembling.
This course gives your team the skills to build and maintain those dashboards themselves.
This is corporate training for organisations developing their own staff. It is written for the people who own the reporting, the deadlines and the training budget: HR and L&D leads, finance and operations managers, and business owners.
Who this course is for
This is a workplace upskilling course for teams who already use Excel and need to do more with it. It suits any organisation where managers report on numbers:
- Finance and management-accounting teams building monthly packs, budget-versus-actual reports and cash-flow views.
- Operations and production managers tracking output, downtime, stock and SLA performance.
- Sales and marketing managers monitoring pipeline, targets, conversion and regional performance.
- HR and L&D teams reporting on headcount, attrition, leave and training spend.
- Business owners and MDs of SMEs who want one clear dashboard instead of a folder of spreadsheets.
Delegates should be comfortable entering data and using basic formulas in Excel. No prior dashboard, macro or coding experience is assumed. The course builds from solid foundations up to polished, interactive dashboards.
What the course covers: outline and modules
The programme is hands-on from the start. Delegates build a real dashboard on realistic business data rather than watching slides. A typical outline:
| Module | Focus | What delegates can do afterwards |
|---|---|---|
| 1 | Dashboard thinking | Decide what to measure, choose the right KPIs and plan a clean layout |
| 2 | Preparing the data | Structure raw data into proper tables; clean, sort and standardise inputs |
| 3 | Formulas that power dashboards | Use SUMIFS, COUNTIFS, IF, INDEX/MATCH and XLOOKUP to pull the right numbers |
| 4 | PivotTables & PivotCharts | Summarise large data sets and group, filter and drill into results fast |
| 5 | Charts that communicate | Pick the right chart, avoid clutter and highlight the message, not the noise |
| 6 | Interactivity | Add slicers, timelines and drop-downs so managers can self-serve answers |
| 7 | Dynamic dashboards | Combine it all into a single live dashboard that refreshes with new data |
| 8 | Formatting, sharing & maintaining | Apply conditional formatting, protect the layout and hand over a maintainable file |
For in-house bookings, the modules are tailored to your sector, your KPIs and your actual reports. Delegates leave with a dashboard built on the data that is really on their desk.
Some teams need to go beyond Excel, connecting multiple sources and refreshing automatically. They can continue with Power BI training or the broader Data Analytics Fundamentals with Excel and Power BI course.
A core theme throughout: a dashboard is a decision tool, not a decoration. Delegates learn to design for the manager reading it, with fewer numbers, clearer signals and faster answers, so the report earns its place in the monthly meeting.
Want the module breakdown built around your own reports? Phone 011 882 8853 or use the BOTI booking page to request a quote. You can also ask BOTI to help you draw up a KPI list and layout plan for your team’s first dashboard.
Delivery formats
How you deliver the training affects how well it sticks. There are three options:
- In-house at your premises. This suits a group from one organisation, because the dashboard can be built around your own data and reports.
- At BOTI’s venue in Sunningdale, Johannesburg. This suits teams that prefer to train away from daily interruptions.
- Live online, facilitator-led. This suits teams spread across offices or provinces. Delegates practise hands-on in Excel during the session, with no travel.
Because the course can run online as well as in-house, head-office and branch teams can be trained to the same standard.
Accreditation
BOTI is a QCTO-accredited Skills Development Provider and a Level 1 B-BBEE contributor. The Excel dashboard course itself is a practical, non-accredited programme focused on workplace skills.
Earlier versions of this page linked Excel skills to the National Certificate: IT End User Computing (SAQA ID 61591). That qualification closed to new learners on 30 June 2026[1], so BOTI supports only learners who were already enrolled.
For a future accredited computer-skills route, BOTI has applied to the QCTO for accreditation of three End User Computing skills programmes: Basic (SP-240201), Intermediate (SP-240202) and Advanced (SP-240203). The QCTO has not yet made its decision, and enrolment opens only once accreditation is confirmed. Readers can register interest on the Basic End User Computing skills programme page.
Most clients run Excel dashboard training purely as a practical skills programme. Tell BOTI your accreditation goals and we will advise on the right structure.
Funding: Skills Development Levy and B-BBEE
Digital-skills training like this can often be planned into spend you already make. As general guidance only:
- The levy. Employers pay the Skills Development Levy (SDL) at 1% of the leviable amount (total remuneration) to SARS. Employers whose leviable amount over the next 12 months will not exceed R500,000 are exempt[2].
- The mandatory grant. When your Workplace Skills Plan and Annual Training Report are submitted to your SETA by 30 April and your levies are up to date, the SETA pays back a mandatory grant of 20% of the levies paid. Unclaimed mandatory grant money moves to discretionary funding by 15 August[3]. Excel and reporting upskilling can be planned into that WSP. Discretionary grants depend on each SETA’s own windows and priorities.
- B-BBEE skills development. The amended generic Codes set an overall skills development target of 6% of the leviable amount, not 6% of payroll. This is made up of 3.5% on learning programmes for black people and 2.5% on bursaries for black students at higher education institutions, plus 0.3% for black employees with disabilities[4]. Training spend on black employees may count towards the learning-programme target. Sector codes may differ, and BOTI cannot promise points.
- Tenders. Under the Preferential Procurement Regulations, 2022, organs of state score “specific goals” rather than a generic B-BBEE level alone. The Public Procurement Act 28 of 2024 never came into force: on 17 September 2026 the Constitutional Court declared the whole Act invalid[5]. Public procurement still runs under the PFMA, the MFMA, the PPPFA and the Preferential Procurement Regulations, 2022, and Parliament may pass a new procurement law.
This is general information, not financial or legal advice. Confirm the specifics with your SETA, your Skills Development Facilitator or your B-BBEE verification professional. BOTI’s Skills Development Facilitator (SDF) Training Course helps your own staff plan training like this inside the WSP and ATR.
Why BOTI
BOTI is a QCTO-accredited South African Skills Development Provider with 450 courses and a client base that includes Sasol, Glencore and the City of Johannesburg. We deliver practical training for whole teams, in-house, at our Sunningdale venue or live online. The training is built for South African workplaces and tailored to your real data, KPIs and reports.
Dashboard skills rarely sit alone. Many clients pair this course with related programmes:
- Microsoft Excel training: to build the core spreadsheet foundation that dashboards rely on.
- Advanced Excel training: for deeper formulas, data modelling and automation behind your dashboards.
- Power BI training: for teams moving from spreadsheets to connected, auto-refreshing reports.
- Microsoft Office All-in-One: Word, Excel, PowerPoint, Outlook and OneNote: to plan a department-wide digital-skills programme.
- Skills development training: to plan your WSP and ATR around this and other training.
Not sure where to start? Our team can map the right path for your finance, operations and management teams.
Frequently asked questions
What is Excel dashboard training?
Excel dashboard training is hands-on training that teaches your staff to turn raw spreadsheet data into a single, clear, interactive dashboard. It covers structuring data, key formulas such as SUMIFS, INDEX/MATCH and XLOOKUP, PivotTables and PivotCharts, choosing the right chart for the message, and interactivity through slicers and drop-downs. The result is a live, decision-ready view that refreshes with new data instead of being rebuilt by hand each month.
What level of Excel do delegates need before a dashboard course?
Delegates should be comfortable entering data and using basic formulas in Excel. No prior experience with dashboards, PivotTables or macros is needed, because the course builds from solid foundations up to polished, interactive dashboards. If your team needs to strengthen the basics first, BOTI can start with foundational Excel training and progress into dashboards.
Should we learn Excel dashboards or Power BI?
Both have their place. Excel dashboards suit teams whose data lives in spreadsheets and who need fast, flexible reporting without new software. Power BI is the next step when you need to connect multiple data sources, refresh automatically and share interactive reports widely. Many teams start with Excel dashboards and add Power BI later, and BOTI can advise on the right sequence.
Is the Excel dashboard training accredited?
No. The Excel dashboard course is a practical, non-accredited programme. BOTI itself is a QCTO-accredited Skills Development Provider. For an accredited computer-skills route, BOTI has applied to the QCTO for accreditation of the End User Computing skills programmes SP-240201, SP-240202 and SP-240203, and enrolment opens only once the QCTO confirms it. Training spend can be planned into your Workplace Skills Plan, but confirm grant and B-BBEE treatment with your SETA, SDF or verification agency.
Can the dashboard training be run in-house and customised for our company?
Yes. BOTI runs the course in-house at your premises, at its venue in Sunningdale, Johannesburg, or live online for remote and branch teams. For in-house bookings we build the dashboard around your own data, KPIs, reports and templates, so delegates practise on the work they do every day.
Request a quote
Stop rebuilding the same report every month. Request a quote and a BOTI consultant will scope an Excel dashboard programme for your team, group size, dates and delivery format.
The course this article describes is Excel Pivot Tables, Dashboards and Power Pivot, a 2-day programme that takes delegates from structured data to a working, interactive dashboard. Training runs in-house at your premises, at BOTI’s venue in Sunningdale, Johannesburg, or live online. Call BOTI on 011 882 8853 or email [email protected]. This course is not accredited. It is delivered as a professional skills programme, and delegates receive a BOTI certificate of attendance.
Sources
- SAQA qualification record 61591: National Certificate: Information Technology: End User Computing – South African Qualifications Authority (SAQA), 2026.
- Skills Development Levy – South African Revenue Service (SARS), 2026.
- Mandatory Grants – Health and Welfare SETA (HWSETA), 2026.
- Codes of Good Practice on B-BBEE: Code Series 300, Statement 300 – Skills Development (Government Gazette 42496) – Department of Trade and Industry, 31 May 2019.
- Godongwana notes Constitutional Court judgment on Public Procurement Act – SAnews (South African Government News Agency), 18 September 2026.