Free Training & Career Tips... Subscribe to Get Weekly Career Tips
By Subscribing You are Agreeing to Terms and Conditions
Looking for Microsoft Excel training in Pretoria or in-person Excel classes near your office? BOTI runs practical, trainer-led Excel courses in-house at your premises across Pretoria and Tshwane, from beginner to advanced, so your people learn on the workbooks they already use. See the full range of Microsoft Office and Excel computer skills courses, or call 011 882 8853 for a quote.
Courses on this topic at BOTI today
- Microsoft Excel Beginners to Advanced (3 days)
- Microsoft Excel Intermediate (1 day)
- Microsoft Excel Advanced (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
We bring the trainer, the materials and the structure to you in Centurion, Hatfield, Menlyn or wherever your offices sit. If you would rather not host, your staff can attend at BOTI’s venue in Sunningdale, Johannesburg, or join a live online class.
Why Excel training matters in Pretoria
Pretoria is the administrative capital of South Africa, and that shapes the Excel skills its workforce needs. The city is the public-sector hub of Tshwane. National government departments, state-owned entities, regulators, research councils and the agencies that serve them all run on spreadsheets. Budgets, procurement registers, grant tracking, monitoring and evaluation reports, payroll reconciliations and audit schedules pass through Excel before they reach a board pack or a Treasury submission.
That creates a specific demand. Government and SOE teams in Pretoria do more than open spreadsheets. They report against the PFMA, defend their numbers to the Auditor-General and consolidate data across divisions. Errors are expensive, and audit findings are public. Strong, consistent Excel skills across a team reduce rework, tighten reporting and make month-end far less painful.
It is not only the public sector. Centurion’s office parks host IT, engineering, telecoms and consulting firms. Hatfield and the inner city are home to the university, embassies and professional services. Menlyn has grown into a financial and corporate node. Each of these sectors relies on Excel for analysis, forecasting and client reporting. Whatever the industry, a team that works the same way in Excel gets work done faster.
In-house and on-site delivery across Pretoria
Most Pretoria employers prefer to train in-house. We send a trainer to your premises and run the course in your boardroom or training room, on your schedule. This suits a city where so many teams work inside secured government or corporate campuses. Staff do not have to travel across town, there is no parking hassle around Menlyn or the CBD, and no productivity is lost to travel.
In-house delivery in Pretoria means:
- At your premises, anywhere in Tshwane: Centurion, Hatfield, Menlyn, Arcadia, Brooklyn, the CBD, Pretoria East or the office parks along the N1 and N4.
- Your own data, where appropriate. We build exercises around the registers, budgets and reports your team actually handles, within your data-security rules.
- A whole team trained together, so everyone leaves using the same formulas, shortcuts and reporting conventions.
- Flexible scheduling, including split sessions or quieter periods, so a department is never fully off the floor at once.
Prefer not to host? Delegates can attend in person at BOTI’s training venue in Sunningdale, Johannesburg. Live online delivery suits teams split across sites or working from home, and gives smaller groups a cost-effective route to the same content. Tell us your headcount and location, and we will recommend on-site, venue-based or online training.
What the Excel course teaches
Our Microsoft Excel training is delivered at the level your team needs, from foundational skills through to advanced analysis, and is tailored at booking. Typical content includes:
| Level | What your team will be able to do |
|---|---|
| Foundation | Build and format worksheets, enter and edit data cleanly, use basic formulas (SUM, AVERAGE, COUNT), print and share workbooks correctly |
| Intermediate | Use logical and lookup functions (IF, VLOOKUP/XLOOKUP), named ranges, conditional formatting, sorting and filtering, multi-sheet workbooks |
| Advanced | Build PivotTables and PivotCharts, use nested and dynamic functions, data validation, what-if analysis, and reporting dashboards |
| Data & reporting | Clean and consolidate data, link workbooks, automate repetitive tasks, and produce reliable management reports |
We confirm the exact outline with you before the course, so the content matches your team’s current level and the work they do day to day.
Choosing the right Excel course level
Most Pretoria teams book one of these courses, either as a single level or as a full programme:
- Microsoft Excel Beginners (1 day): for staff who are new to Excel or have only used it to capture data.
- Microsoft Excel Intermediate (1 day): lookups, logical functions, conditional formatting and multi-sheet workbooks.
- Microsoft Excel Advanced (1 day): advanced functions, data validation, what-if analysis and reporting.
- Microsoft Excel Beginners to Advanced (3 days): the full programme, from the basics through to PivotTables and management reports.
- Excel Pivot Tables, Dashboards and Power Pivot (2 days): for finance, M&E and reporting teams who summarise large data sets.
If your team has mixed levels, ask BOTI to help you gauge each person’s current skills before you book, so that nobody is bored or left behind.
Who the course is for
This training is built for employers training their staff in Pretoria, including:
- Government departments and municipal teams across Tshwane who report against the PFMA and to the Auditor-General.
- State-owned entities and agencies that consolidate budgets, procurement and project data.
- Finance, admin, HR, procurement and monitoring and evaluation teams who live in spreadsheets.
- Private firms in Centurion, Hatfield and Menlyn, from IT and engineering to financial and professional services.
It suits complete beginners, self-taught users who want to fill gaps and work faster, and experienced staff who need advanced analysis, PivotTables and dashboards.
Accreditation
BOTI’s Microsoft Excel courses are professional skills programmes and are not accredited. BOTI is a QCTO-accredited Skills Development Provider and a Level 1 B-BBEE contributor, but that accreditation covers its QCTO programmes, not these short courses. Delegates receive a BOTI certificate of attendance for their records and your skills-development file.
Note: the National Certificate: IT End User Computing (SAQA ID 61591) closed to new learners on 30 June 2026[1]. Only learners who were already enrolled can complete it. BOTI has applied to the QCTO for accreditation of the End User Computing skills programmes, such as the Basic End User Computing skills programme (SP-240201). Enrolment opens only once the QCTO confirms accreditation, and you can register interest with BOTI in the meantime.
Funding: Skills Development budget and B-BBEE
Excel training fits easily into a Pretoria employer’s skills plan, and it can be paid for from budget you are probably already setting aside.
- Skills Development Levy (SDL). The levy is 1% of the leviable amount (total remuneration), paid to SARS each month. Employers whose leviable amount over the next 12 months will not exceed R500,000 are exempt[2]. Training you plan and report through your Workplace Skills Plan and Annual Training Report helps you put that levy to work.
- B-BBEE skills development. Under the amended generic Codes, the overall skills development target is 6% of the leviable amount. 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 a further 0.3% for black employees with disabilities[3]. Sector codes may differ. This matters for Pretoria firms that bid for government and SOE work.
BOTI does not promise B-BBEE points or SETA grants. This is general guidance, not financial or legal advice. Confirm the specifics with your B-BBEE verification agency or skills development facilitator.
Book Excel training in Pretoria
Ready to upskill your team? Tell us your headcount, your preferred suburb (Centurion, Hatfield, Menlyn or elsewhere in Tshwane) and the level you need, and we will come back with options and a quote.
- Phone: 011 882 8853
- Email: [email protected]
- Not sure of your team’s level? Ask BOTI to help you gauge your staff’s current Excel skills before you book.
Explore more:
- National pillar: Microsoft Excel Training
- Same course in other cities: Excel Training in Johannesburg · Excel Training in Cape Town · Excel Training in Durban
- Request a quote / booking
Frequently asked questions
Do you deliver Excel training at our offices in Pretoria?
Yes. Our most popular option is in-house delivery: a trainer comes to your premises anywhere in Tshwane, including Centurion, Hatfield, Menlyn, the CBD, Pretoria East and the surrounding office parks, and runs the course for your team on site. We train small groups through to whole departments.
Are there in-person Excel classes near me if we do not want to host?
Yes. If you would rather not host the course, your staff can attend in person at BOTI’s training venue in Sunningdale, Johannesburg, or join a live online class led by a trainer. Online classes cover the same content and suit teams split across sites.
Can the course be tailored to government and SOE reporting?
Yes. Because we train in-house, we can build exercises around the budgets, registers and monitoring reports your department or entity works with, including the consolidation and reporting tasks common in Pretoria’s public sector, within your data-security rules.
Is the Excel training accredited?
No. BOTI’s Microsoft Excel courses are not accredited. They are delivered as professional skills programmes, and delegates receive a BOTI certificate of attendance. The National Certificate: IT End User Computing (SAQA ID 61591) is closed to new learners. BOTI has applied to the QCTO for accreditation of the End User Computing skills programmes, and you can register interest while that decision is pending.
How long does Excel training take?
Microsoft Excel Beginners, Microsoft Excel Intermediate and Microsoft Excel Advanced each run for one day. Microsoft Excel Beginners to Advanced runs over three days and takes a team from the basics through to PivotTables and reporting. Tell us your headcount and goals on 011 882 8853 and we will recommend a format.
For a team that needs Excel from first principles through to PivotTables and management reporting, book the Microsoft Excel Beginners to Advanced course. Training runs in-house at your premises anywhere in Pretoria and Tshwane, at BOTI’s venue in Sunningdale, Johannesburg, or live online. Call BOTI on 011 882 8853 or email [email protected], or request a quote. 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.
- 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.