Free Training & Career Tips... Subscribe to Get Weekly Career Tips
By Subscribing You are Agreeing to Terms and Conditions
Excel Copilot training teaches your staff to use Microsoft 365 Copilot inside Excel to build formulas in plain English, analyse data, spot trends and summarise spreadsheets in seconds — turning hours of manual work into minutes. BOTI delivers this practical, facilitator-led course in-house at your premises or off-site across South Africa, so your finance, operations and admin teams get more out of the spreadsheets they already use every day.
If your team lives in Excel but still loses time wrestling with VLOOKUP, pivot tables and nested IF statements, excel copilot is the skill gap worth closing now. Copilot is the AI assistant built into Microsoft 365, and once your people know how to prompt it well, routine analysis that used to take an afternoon takes a few minutes — with fewer formula errors and clearer reporting for managers.
Quick summary
– Course: Excel + Copilot — AI-Assisted Spreadsheets
– Primary skill: Using Microsoft 365 Copilot inside Excel
– Duration: 1 day (configurable to a half-day intro or 2-day deep dive)
– Delivery: In-house / on-site, off-site at major SA centres (JHB, Cape Town, Durban, Pretoria), or remote/virtual
– Audience: Finance, operations, HR, sales-ops and admin staff who use Excel regularly
– Accreditation: Not an accredited qualification; delegates receive a BOTI certificate of completion
The business problem this course solves
Most South African businesses are sitting on a productivity gap that has nothing to do with effort. Skilled staff spend hours each week on repetitive spreadsheet work — cleaning data, rebuilding the same monthly report, chasing a formula that broke when a column moved. The skill exists in the room; the speed does not.
Microsoft 365 Copilot changes the economics of that work. Instead of remembering exact function syntax, your team describes what they want in plain language — “highlight the regions that missed target” or “flag overdue invoices” — and Copilot writes the formula, builds the analysis, or drafts the summary. Used well, it:
- Cuts the time spent on routine reporting and data cleanup.
- Reduces formula errors that lead to bad numbers in management reports.
- Lowers the dependency on one or two “Excel experts” everyone else queues behind.
- Makes data analysis accessible to staff who were never confident with advanced Excel.
The catch is that Copilot only delivers when people know how to prompt it, check its output and fit it into a real workflow. That is exactly what this course builds.
Who should attend
This course is designed for South African corporate teams who use Excel regularly and have access to Microsoft 365 Copilot (or are about to roll it out). It is ideal for:
- Finance and accounts teams building monthly reports, reconciliations and budgets
- Operations and supply-chain staff tracking stock, throughput and KPIs
- HR and L&D teams managing headcount, leave, training and payroll data
- Sales and sales-ops staff working with pipelines, targets and commission sheets
- Administrators and PAs who maintain trackers, schedules and registers
- Managers who want faster, cleaner data to make decisions
It suits both confident Excel users who want to work faster and less-confident users who find advanced Excel intimidating — HR and L&D buyers often roll it out across a whole department to lift the baseline at once.
Course outline: what your team will learn
The programme is hands-on from the start — delegates work in Excel with Copilot on realistic business data, not theory.
| # | Module | Focus |
|---|---|---|
| 1 | Copilot in Microsoft 365 | What Copilot is, where it lives in Excel, licensing and data-privacy basics |
| 2 | Prompting Excel Copilot well | Writing clear prompts; refining and iterating to get the right result |
| 3 | Formulas in plain English | Generating, explaining and fixing formulas without memorising syntax |
| 4 | Cleaning and shaping data | Using Copilot to format, deduplicate, split and standardise messy data |
| 5 | Analysis and insights | Spotting trends, outliers and correlations; asking questions of your data |
| 6 | Pivot tables and charts | Building and adjusting pivots and visualisations through Copilot |
| 7 | Summarising and reporting | Turning a raw sheet into a clear, manager-ready summary in minutes |
| 8 | Checking Copilot’s work | Verifying outputs, catching errors and knowing when to trust the AI |
| 9 | Building it into the workflow | Repeatable patterns for monthly reporting and team handovers |
For in-house bookings, modules are tailored to your real spreadsheets, reports and sector — so delegates leave able to apply Copilot to the work that is actually on their desk.
Why responsible, accurate use matters
A core theme of the course is that Copilot is an assistant, not an oracle. Delegates learn to verify what Copilot produces — checking totals, sense-testing results and weighing the data-privacy implications of putting company information into an AI tool. This protects your business from the most common AI risk: confidently wrong numbers reaching a decision-maker. Your team leaves faster and more careful, not less.
Delivery formats and national reach
BOTI runs Excel + Copilot training throughout South Africa. Delivery options include:
- In-house / on-site at your premises, built around your own spreadsheets — the most cost-effective option for groups and the best for transfer back to the job.
- Off-site at major city centres: Johannesburg, Cape Town, Durban and Pretoria.
- Remote / virtual instructor-led sessions for distributed and hybrid teams.
Group rates make whole-team training affordable, with pricing quoted in rand (ZAR). Request a quote or a 15-minute callback to confirm dates, group size and the delivery format that suits your team.
Accreditation and funding your Skills Development budget
This is a practical, facilitator-led skills programme focused on immediately usable Copilot and Excel competencies; delegates receive a BOTI certificate of completion (this is not an accredited qualification). Need accredited training? Ask about BOTI’s QCTO- and SETA-accredited programmes in related areas such as Business Administration and IT End User Computing.
On funding, digital-skills training like this can also support your transformation strategy. Under the B-BBEE Codes, the skills-development target is 6% of the leviable amount, while your Skills Development Levy (SDL) is 1% of payroll. Investing your Skills Development budget in Copilot upskilling can therefore contribute to your skills-development scorecard, especially when delivered to staff who advance your organisation’s specific transformation goals.
Funding note: This is general guidance, not legal or financial advice. Your B-BBEE verification agency or Skills Development Facilitator (SDF) should confirm exactly how any spend is recognised on your scorecard.
Where this fits in your Microsoft and data skills path
Excel + Copilot is a natural step in a broader data-skills journey. A typical BOTI path looks like this:
- Build the Excel foundation with Microsoft Excel training for teams who need core spreadsheet skills first.
- Add AI leverage — this Excel + Copilot course to make existing Excel users dramatically faster.
- Scale to reporting and dashboards with Power BI training for teams moving from spreadsheets to interactive business intelligence.
Not sure where your team sits? Ask us for a recommendation and we will map the right course to each role, or browse the full Microsoft Office and data course range to plan a department-wide programme.
Why BOTI
BOTI (Business Optimization Training Institute) is an established South African corporate training provider with a catalogue of 450+ courses, and we have delivered training to leading organisations including Sasol, Glencore and the City of Johannesburg. Our Microsoft and data programmes are built for South African workplaces — practical, benefit-led, and tailored to your team’s real spreadsheets for in-house bookings, with group rates that make whole-team training affordable and delivery available nationwide.
Frequently asked questions
What is Excel Copilot training?
It is hands-on training that teaches your staff to use Microsoft 365 Copilot inside Excel — generating formulas in plain English, cleaning and analysing data, building pivots and charts, and summarising spreadsheets in seconds. The focus is on real business tasks and on checking Copilot’s output for accuracy.
Do we need Microsoft 365 Copilot licences to attend?
To get full hands-on value, delegates should have access to Microsoft 365 with Copilot enabled. If you are still planning your rollout, we can advise on what is needed and tailor the session accordingly — talk to us when you book.
Who should attend Excel + Copilot training?
Any team that works in Excel regularly: finance, operations, HR, sales-ops and admin staff, as well as managers who want faster, cleaner reporting. It suits both confident and less-confident Excel users.
Is the training accredited, and can it count towards B-BBEE?
This is a practical, facilitator-led skills programme and is not an accredited qualification; delegates receive a BOTI certificate of completion. If you need accredited training, ask about BOTI’s QCTO- and SETA-accredited programmes in related areas such as Business Administration and IT End User Computing. Digital-skills spend can still contribute to the skills-development element of your B-BBEE scorecard (target of 6% of the leviable amount) — confirm the specifics with your verification agency or SDF.
Can the course be run in-house and customised for our company?
Yes. In-house and on-site delivery is available throughout South Africa — Johannesburg, Cape Town, Durban, Pretoria and surrounds — plus virtual sessions for remote teams. For in-house bookings we tailor the modules to your own spreadsheets, sector and reporting.
Ready to make your team faster in Excel?
Give your staff the AI skills to turn hours of spreadsheet work into minutes. Request a quote or book a free 15-minute callback and we will help you choose the right group size, dates and delivery format.
Request a quote / 15-minute callback • Call 011-882-8853 • Email [email protected]
Free resource: ask our team for the BOTI Excel Copilot Prompt Cheat-Sheet when you enquire — a one-page set of ready-to-use prompts your team can apply from day one.