Spreadsheet training online that gets you from the basics to everyday formulas, charts and PivotTables in Microsoft Excel or Google Sheets. It is for office and small business staff, and it is self-paced and run entirely online.
Who this course is for
- Office workers who are new to spreadsheets or a bit rusty
- Small business staff who keep lists, budgets and records
- Admin and finance support staff who want to use formulas with confidence
- Anyone who uses Excel or Google Sheets at work and wants good habits
What you'll learn
- Identify the parts of a spreadsheet, and enter and format text, numbers and Australian dd/mm/yyyy dates correctly
- Write formulas with operators and the SUM, AVERAGE, MIN, MAX, COUNT and COUNTA functions, and use relative and absolute ($) references
- Apply IF, COUNTIF, SUMIF, XLOOKUP (or VLOOKUP), ROUND and basic date and TEXT functions to everyday business tasks
- Organise a list with tables, sort, filter, freeze panes, data validation and conditional formatting
- Choose and build a clear chart for your message, and summarise a list with a simple PivotTable
- Lay out and check a spreadsheet, protect and share it with version control, and handle personal information carefully
Course details
- Format: online, self-paced, 6 narrated video lessons with captions, activities and practice checks
- Time: about 1.5 hours, including activities and the quiz
- Assessment: online quiz, marked automatically, 3 attempts, 80% to pass
- Certificate: Certificate of Completion when you pass (download as a PDF straight away)
- Includes: participant guide PDF to keep
- Price: $99 AUD per person; group bookings available through the site
Frequently asked questions
Is this course accredited? This spreadsheet training online is a non-accredited short course from Australian Salesmasters Training Co (ASTC), RTO 6854. It is not nationally recognised training. You receive an ASTC Certificate of Completion when you pass.
Does it cover formulas and PivotTables? Yes. You write formulas and everyday functions such as SUM, IF, COUNTIF, SUMIF and XLOOKUP (or VLOOKUP), and you summarise a list with a simple PivotTable.
Is it for Excel or Google Sheets? The lessons use Excel names and formulas, with Google Sheets notes.
This is a non-accredited short course and is not nationally recognised training. Any legal content is general information current as at November 2026, not legal advice.