Skip to content

4.8/5 from 790+ Google reviewsLevel 1 B-BBEESETA & QCTO accredited

Microsoft Excel Beginners to Intermediate (2 days)
Trusted by teams at
SasolGlencoreMSC CruisesUniversity of the Western CapeGivaudanSA Weather ServiceCity of JohannesburgUniversity of South AfricaSol Plaatje UniversityCIPC

Microsoft Excel Beginners to Intermediate (2 days)

In two days, staff go from a blank workbook to a clean, checked report with pivot tables, decision formulas and a Power Query refresh.

Teams rarely start at the same level in Excel: one person has never written a formula, the next re-types the month-end report because nobody showed them Power Query. This two-day Excel beginners to intermediate course takes a group through both stages in sequence. Each day is one of BOTI's licensed CTM workshop kits: day one is the Excel Essentials kit, day two the Excel 2024 kit pitched at intermediate level, so nothing is taught twice.

Day one lays the foundation. Delegates build and organise a workbook, enter and format data, turn a list into an Excel table, write SUM, AVERAGE, COUNT, IF, SUMIF and COUNTIF formulas, tidy text with functions, and finish with charts and printing that fits the page. Day two turns that into reporting: data validation and cleaning tools, IF with AND and OR, IFERROR, date formulas, the dynamic array functions FILTER, SORT and UNIQUE, Power Query from the ERP export, pivot tables with slicers and pivot charts, and sharing and protecting the finished workbook.

The exercises are the sheets South African offices actually keep – an attendance register, an expense claim, a debtors age analysis, a sales report by province and a VAT reconciliation. Delegates who want lookups, what-if analysis and macros can add the Advanced day later or book the three-day course.

Why this course

For your organisation

  • One group, one standard: everyone from the clerk to the supervisor on the same methods
  • Registers and reports that add up, print properly and refresh from the system export
  • Fewer hours lost to re-typing and fixing broken sheets
  • Pivot tables and slicers that managers can use without help

For your delegates

  • The foundations done properly before the harder material
  • Formulas, tables and charts on day one; Power Query and pivot tables on day two
  • A set of working files to take back to the office
  • A clear picture of what the Advanced day adds

What delegates will be able to do

  • Create, organise and format workbooks and worksheets, and open exports from other systems
  • Convert a list to an Excel table, then sort, filter, total and remove duplicates
  • Write formulas with SUM, AVERAGE, COUNT, MIN, MAX, IF, SUMIF, COUNTIF and the text functions
  • Build and format charts, insert images and print a sheet that fits the page
  • Clean a system export and control data entry with validation and drop-down lists
  • Combine IF with AND, OR and IFERROR and work with text and dates in formulas
  • Build self-updating lists with FILTER, SORT, UNIQUE and SEQUENCE
  • Import, reshape and refresh data with Power Query
  • Summarise data with pivot tables, slicers, timelines and pivot charts
  • Share, protect and check a workbook before it goes to management

Who should attend

Mixed-level teams, new intakes, administrators, bookkeepers, HR and payroll staff, sales and operations coordinators and supervisors who need to go from the basics to confident reporting in one booking. Delegates should be comfortable with a Windows computer, keyboard and mouse; no Excel experience is needed for day one.

Course outline

Day 1 – Beginners – the Excel Essentials kit: build, format, calculate, chart and print

Getting around Excel and setting up a workbook
  • The Excel screen: ribbon, Quick Access Toolbar, name box, formula bar and status bar
  • Creating, saving and opening workbooks, and what the different file formats are for
  • Adding, renaming, colouring, moving and copying worksheets – one sheet per branch or per month
  • Moving around a large sheet quickly and searching for a value anywhere in the workbook
  • Opening a CSV export from your payroll, point-of-sale or accounting system
  • Hiding and unhiding sheets, rows and columns; zoom and window views
  • Adding a hyperlink to a supporting document or another sheet
Entering and editing data cleanly
  • Typing, correcting and replacing data without breaking what is already there
  • AutoFill for dates, months, employee numbers and repeating patterns
  • Cut, copy and paste, and Paste Special to paste values only or transpose a list
  • Inserting and deleting cells, rows and columns in a live register
  • Adjusting row height and column width so everything shows
  • Find and Replace to fix a supplier name across a whole sheet
Formatting so a manager can read it at a glance
  • Number formats: currency, percentages, decimals and South African date formats
  • Alignment, indenting and wrapping text; when to merge cells and when not to
  • Format Painter and cell styles for a consistent look
  • Workbook themes and sensible colour choices for printed reports
  • Conditional formatting to flag overdue accounts, low stock or absences
  • Sparklines to show a month-by-month trend inside a single cell
Working with lists as Excel tables
  • Turning a range into a table and why it makes sorting and filtering safer
  • Table styles, banded rows and the total row
  • Sorting by more than one column, for example by department and then by surname
  • Filtering a staff list, stock sheet or sales register down to the records you need
  • Removing duplicate records such as repeated ID or invoice numbers
  • Subtotals and outlining to collapse detail under group totals
  • Converting a table back to an ordinary range
Formulas and functions for everyday calculations
  • How a formula is built: cell references, operators and the order of calculation
  • Relative and absolute references so a formula copies correctly down a column
  • SUM, AVERAGE, COUNT, MIN and MAX on an expense claim or a sales sheet
  • IF to show Pass or Fail, Paid or Outstanding
  • SUMIF, COUNTIF and AVERAGEIF to total sales per branch or count staff per shift
  • LEFT, RIGHT and MID to pull a code out of a longer reference
  • UPPER, LOWER, PROPER and CONCATENATE to tidy names and build e-mail addresses
  • Showing formulas on the sheet to check your work
Charts, pictures and printing
  • Choosing a column, line or pie chart for the numbers in front of you
  • Adding a second data series and switching rows and columns
  • Quick Analysis for an instant chart, total or formatting
  • Chart titles, labels, legends, layouts and styles, and moving a chart to its own sheet
  • Inserting shapes, text boxes and the company logo, with alt text for accessibility
  • Print area, print titles on every page, scaling to fit, headers and footers
  • Saving as PDF and checking a workbook for hidden personal information before it goes out

Day 2 – Intermediate – the Excel 2024 kit: clean data, smarter formulas, Power Query, pivot tables and shared workbooks

Cleaning and controlling the data you receive
  • Text to Columns and Flash Fill to split names, codes and dates from a system export
  • Removing duplicate records and finding blanks with Go To Special
  • Data validation: drop-down lists for cost centres, departments and leave types
  • Input messages and error alerts that stop wrong entries at the source
  • Freeze panes and split windows for long registers
  • Keyboard shortcuts that save time every day
Formulas that make decisions
  • Mixed references ($A1 and A$1) for a rates or commission table
  • IF combined with AND and OR for two or three conditions at once
  • IFERROR to clean up #N/A and #DIV/0! in a report
  • TEXT and CONCAT to build reference numbers and readable labels
  • TODAY and date arithmetic for days outstanding and the ageing of debtors
  • Named ranges so formulas read like plain English
Dynamic arrays and Power Query
  • FILTER to list only the outstanding invoices or the staff in one region
  • SORT and UNIQUE for a live, de-duplicated customer or supplier list
  • SEQUENCE for numbered schedules and date lists that build themselves
  • Spill ranges and the # reference, and what happens when the source grows
  • Power Query: importing a CSV or Excel export from the ERP or accounting system
  • Removing columns, fixing data types, splitting and unpivoting in the Query Editor
  • Appending twelve monthly files into one table and refreshing when the next month arrives
  • The IMAGE function to show product pictures in a price list
Pivot tables, slicers and charts for reporting
  • Building a pivot table from a table and arranging rows, columns and values
  • Grouping dates by month and quarter, and numbers into bands
  • Slicers and timelines so a manager can filter the report themselves
  • Pivot charts and ordinary charts: titles, data labels and legends that read well
  • Charts that update automatically from a spill range
  • Sparklines and a map chart of sales by province
  • Conditional formatting rules: data bars, colour scales, icon sets and top ten
Practical builds for the office
  • A budget-versus-actual tracker with variance and percentage columns
  • A staff roster or shift calendar driven by dates
  • A simple project schedule laid out as a Gantt chart
  • A stock and sales tracker with running totals and reorder flags
  • Starting from a built-in template and adapting it
Sharing, protecting and checking a workbook
  • Sharing a workbook from OneDrive or SharePoint and setting who may edit
  • Co-authoring with colleagues, comments and notes, and version history
  • Unlocking the input cells, then protecting the worksheet, so the formulas survive
  • Passwords and encryption for sensitive files, with POPIA in mind
  • Trace precedents and dependents to see what feeds a total
  • Customising the ribbon, page setup for large sheets and exporting to PDF or CSV

How it is delivered

Two days, 08:30-16:00. In person at your offices anywhere in South Africa, at a BOTI venue, or live online. One delegate or a group of up to 20, each on a Windows computer with Microsoft 365 or Excel 2021/2024 (day two uses Power Query and the dynamic array functions); laptops with the software can be supplied on request. Course manuals for both kits, exercise files and sample data included. We deliver it at your offices in Johannesburg, Pretoria, Durban, Cape Town and anywhere else in South Africa, at a BOTI venue in Johannesburg, or live online for teams in different places.

Certificate: Delegates receive a BOTI certificate of attendance. This is a non-accredited short course; the training spend may count towards your B-BBEE skills development – check with your verification agency. If you need an accredited route, ask us about BOTI's End User Computing skills programmes (QCTO accreditation pending).

What our clients say

★★★★★ 4.8 on Google from 790+ reviews · word-for-word quotes from signed letters of reference, from clients on this and/or related BOTI courses

“The training was very informative and practical, leaving our employees feeling confident in their ability to leverage Excel more effectively.”

A non-profit housing companyHC Officer · Course: Microsoft Excel Training · 2024

“The facilitator effectively encouraged participation and used practical examples, discussions and interactive activities to ensure that the concepts were understood and could be applied in the workplace.”

A medical schemeOffice Assistant · Course: Microsoft Office Excel Beginners · 2026

“Business Optimization Training Institute facilitated Microsoft Excel Training for our company. The course was efficiently scheduled and planned around our timetable. We were impressed by the quality of training.”

A private companyOffice Manager · Course: Microsoft Excel Training · 2024

Read what our clients say

Frequently asked questions

Can you run this course at our offices?

Yes. Most groups are trained at the client's premises anywhere in South Africa, on your own computers or on laptops we bring. We can also host it at a BOTI venue or deliver it live online.

Can we book only one of the two days?

Yes. Day one is sold on its own as Microsoft Excel Beginners (1 day) and day two as Microsoft Excel Intermediate (1 day).

Is it accredited?

No – it is a non-accredited short course and delegates receive a BOTI certificate of attendance. If you need an accredited route, ask us about BOTI's End User Computing skills programmes (QCTO accreditation pending).

Is there a version that goes on to Advanced?

Yes. Microsoft Excel Beginners to Advanced (3 days) adds the Excel Expert day. A team that already has the basics should look at Microsoft Excel Intermediate to Advanced (2 days) instead.

How many people can attend?

From one delegate to groups of 20, each working on their own computer. The price per delegate drops as the group grows – see the price table, or ask us for a quote.

Can the exercises use our own spreadsheets?

Yes. Send us a sample register, export or report beforehand, with personal information removed, and the facilitator builds it into the exercises.

Ask a consultant for a written quote

A BOTI consultant emails you a written quote, usually within 15 minutes (Mon–Fri, 08:00–17:00). After hours, we reply on the next working day. To speak to someone now, call 011 882 8853.

Your quote request is for: Microsoft Excel Beginners to Intermediate (2 days)

    ★★★★★ 4.8 on Google from 790+ reviews

    Free and no obligation.

    4.8/5from 790+ Google reviews 750+organisations trained Level 1B-BBEE contributor SETA & QCTOaccredited programmes

    Training for your team, at your venue, ours or online

    Tell us the course and the number of delegates. A BOTI consultant emails you a written quote, usually within 15 minutes (Mon–Fri, 08:00–17:00). Or call us to speak to someone now.

    Ask a consultant Call 011 882 8853

    Business Optimization Training Institute (Pty) Ltd · 97 Greenlands Crescent, Sunningdale, 2192, Johannesburg · Reg 2017/286086/07 · VAT 4770208033 · Level 1 B-BBEE Contributor · 011 882 8853 · Facebook · LinkedIn
    © 2026 Business Optimization Training Institute. All rights reserved. · Privacy Policy
    Don’t Wait to Start Training — Contact us Today