Free Training & Career Tips... Subscribe to Get Weekly Career Tips
By Subscribing You are Agreeing to Terms and Conditions
An advanced Excel course for staff who already know the basics should cover lookups (VLOOKUP and XLOOKUP), pivot tables, conditional formatting, data validation, nested IF logic, charts and dashboards, an introduction to Power Query, and an awareness of macros and VBA. BOTI teaches these skills in its Microsoft Office and Excel computer skills courses, from intermediate through to advanced and VBA. Each level is built to cut hours of manual spreadsheet work each week.
For an L&D buyer, the question is rarely “should we train on Excel?” It is “which skills make a real difference, and who actually needs them?” This guide maps the high-value skills to the roles that use them and sets out the productivity case. You can then scope training that pays back rather than ticking a box.
Why “beyond basics” is where the return lives
Most staff are self-taught to a basic level: they can enter data, sum a column and format a sheet. The costly gap sits one level up. When an analyst rebuilds the same report by hand every month, or a finance clerk reconciles two spreadsheets line by line, you are paying salaried hours for work Excel can do in seconds.
Intermediate and advanced skills turn that lost time into capacity. A single well-built pivot table can replace an afternoon of manual sorting. One Power Query connection can remove a weekly copy-and-paste routine. The return is not abstract: it is hours given back to people you already employ.
That is the case for structured training over ad hoc video learning. It covers the right skills in the right order, uses realistic practice files, and gives your team a shared standard for how spreadsheets are built.
Request a quote to scope an advanced Excel programme for your team. It can run in-house at your premises, at BOTI’s venue in Sunningdale, Johannesburg, or live online.
The high-value skills, explained
These are the capabilities a Microsoft Excel Beginners to Advanced pathway should cover. Each one removes a specific, recurring cost.
Lookups: VLOOKUP and XLOOKUP
Lookups pull matching data from one table into another, for example attaching customer names to a list of order numbers. They end manual cross-referencing. XLOOKUP is the newer, more forgiving successor to VLOOKUP. It should be taught alongside VLOOKUP, because many company files still use the older function.
Pivot tables
Pivot tables summarise large datasets, such as thousands of rows of sales, transactions or headcount, into a clean, interactive report in seconds. For anyone who currently filters and totals by hand, this is usually the highest-return skill on the list.
Conditional formatting
Conditional formatting makes numbers easier to read: overdue invoices turn red, top performers turn green, and anomalies stand out at a glance. It turns a wall of figures into a sheet a manager can read quickly.
Data validation
Data validation controls what users can type into a cell, using drop-down lists, date ranges and number limits. For any team sharing a tracker or template, it is the difference between clean data you can analyse and a sheet full of typos and inconsistent entries.
IF and nested logic
IF statements let a spreadsheet make decisions: flag a result as “Pass” or “Fail”, calculate a commission tier or apply a discount band. Nested and combined logic (IF with AND and OR) automates the rules your team currently applies in their heads.
Charts and dashboards
Clear charts turn data into decisions. The advanced skill is building a dashboard: a single screen that pulls charts, lookups and pivot tables together, so leadership sees the numbers without anyone rebuilding a report each week.
Power Query (introduction)
Power Query automates the cleaning and combining of data from several files or sources. Once a query is built, refreshing next month’s report takes a single click. For teams spending days on monthly data preparation, this makes a large difference. It is also a natural step towards Microsoft Power BI Basics for richer reporting and analytics.
Macros and VBA awareness
Macros record and replay repetitive tasks, and VBA is the code behind them. Most staff do not need to become developers. Knowing what macros can do helps a team spot which repetitive jobs can be automated and brief a specialist properly. Power users can go further with Writing Excel Macros with VBA.
Who needs which skills, by role
Not every employee needs every skill. Scope training to the role to keep it relevant and cost-effective.
| Role | Priority skills | Why |
|---|---|---|
| Finance & accounts | Lookups, pivot tables, nested IF, Power Query | Reconciliations, reporting, month-end close |
| Sales & operations | Pivot tables, charts/dashboards, conditional formatting | Performance tracking, pipeline and KPI reporting |
| HR & L&D | Data validation, lookups, pivot tables | Headcount, leave and training records, clean data capture |
| Analysts & data roles | Power Query, advanced lookups, macros/VBA | Heavy data prep, automation, repeatable models |
| Admin & coordinators | Data validation, conditional formatting, charts | Trackers, templates, clear status reporting |
| Managers & team leads | Pivot tables, dashboards, charts | Reading and interrogating data, not building it |
A practical approach is to send the whole team through an intermediate course to lift the baseline. A smaller group of analysts and finance staff can then go on to an advanced or VBA course.
The productivity and return-on-investment case
The business case for an advanced Excel course is a simple time calculation. Use your own figures and estimate conservatively. The numbers below are an illustration, not a promised result.
- Identify the recurring task: for example, a weekly report that takes one staff member three hours.
- Estimate the time saved: if pivot tables and a Power Query connection cut that task to 90 minutes, the saving is 90 minutes a week.
- Multiply across the team and the year: 90 minutes a week is roughly 65 hours a year, per person, per task.
- Cost it against salary: compare those freed hours, across everyone who does similar work, with the cost of the training.
The softer returns matter too. There are fewer errors in the reports leadership relies on, and less key-person risk when only one person “knows the spreadsheet”. Decisions also become faster and more confident.
Training spend also links to two compliance areas South African employers already manage. The Skills Development Levy is 1% of the leviable amount[1], and SETA grants funded by the levy have their own rules, so check with your SETA before relying on them. Under the B-BBEE generic Codes, the overall skills development target is 6% of the leviable amount[2]. How a particular course is recognised depends on your sector code and how the spend is recorded, so treat it as a possible benefit, not a guaranteed score.
Before you commit budget, ask BOTI to help you map which staff need which Excel skills, so each person is booked on the right level.
How BOTI structures Excel training
BOTI runs Excel training for South African teams as a pathway, not a one-size-fits-all course:
- Intermediate: lookups, pivot tables, conditional formatting, data validation and IF logic. See Microsoft Excel Intermediate (1 day).
- Advanced: dashboards, advanced functions, an introduction to Power Query and more complex analysis. See Microsoft Excel Advanced (1 day).
- Intermediate to advanced in one programme: Microsoft Excel Intermediate to Advanced (2 days), for staff who need both levels.
- Macros and VBA: automation and writing Excel macros with VBA, for power users.
Delivery is flexible: in-house at your premises, at BOTI’s venue in Sunningdale, Johannesburg, or live online. The programme can be tailored to your team’s actual files and reporting needs.
If you searched for Excel courses in Cape Town or another city, live online classes let delegates join from anywhere, or you can ask about in-house delivery at your premises. Our guide to Excel training for Cape Town teams has more detail.
On accreditation: BOTI’s Excel short courses are not accredited. The former National Certificate: IT End User Computing (61591) closed to new learners on 30 June 2026 and is now open to already-enrolled learners only. BOTI is a QCTO-accredited Skills Development Provider and has applied to the QCTO for accreditation of the End User Computing skills programmes (SP-240201 Basic, SP-240202 Intermediate and SP-240203 Advanced). Enrolment opens only once the QCTO confirms its decision. You can register interest in the Advanced End User Computing skills programme now.
To see the full skills progression, read our companion guide on the essential Excel formulas every manager should know. Teams ready to move beyond spreadsheets can look at Power BI training.
Request a quote to design an advanced Excel programme around your team’s roles and reporting.
Frequently asked questions
What is the difference between an intermediate and an advanced Excel course?
An intermediate Excel course covers lookups, pivot tables, conditional formatting, data validation and IF logic, which are the skills most office staff use daily. An advanced Excel course adds dashboards, more complex functions, an introduction to Power Query and automation, and suits finance, analyst and reporting roles.
Do my staff need to know basic Excel before an advanced Excel course?
Yes. Advanced and VBA courses assume delegates are comfortable with formulas, formatting and basic functions. For mixed-ability teams, BOTI’s Microsoft Excel Beginners to Advanced course lets everyone start at the right level.
Is BOTI’s advanced Excel course accredited?
No. BOTI’s Excel short courses are professional skills programmes, and delegates receive a BOTI certificate of attendance. BOTI is a QCTO-accredited Skills Development Provider and has applied to the QCTO for accreditation of the End User Computing skills programmes SP-240201, SP-240202 and SP-240203. Enrolment opens only once that decision is confirmed, and you can register interest now.
Should everyone learn VBA and macros?
No. Most staff only need to know what macros can automate. A smaller group of analysts and power users benefits from full training in writing Excel macros with VBA to automate repetitive work.
Can the advanced Excel course be delivered in-house, in Cape Town or online?
Yes. BOTI runs Excel training in-house at your premises, at its venue in Sunningdale, Johannesburg, or live online, so teams in Cape Town and other cities can attend without travelling.
To build these skills across your team, book Microsoft Excel Intermediate to Advanced. 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
- 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.