This AI spreadsheet training online course from Australian Salesmasters Training Co (ASTC) is for office and small-business staff who want AI help with formulas, data cleaning, summaries and charts. It is self-paced and finishes with a worked mini-project.
Who this course is for
- Office staff who use spreadsheets every week
- Small-business owners and staff
- People who struggle to write or understand formulas
- Anyone who needs to clean data and build honest charts
What you'll learn
- Explain what an AI assistant can and can't do with numbers, and apply the rule that the spreadsheet calculates and you verify
- Have AI explain and write formulas (SUM, IF, XLOOKUP or VLOOKUP, COUNTIFS, SUMIFS and dates), and test each one on sample rows
- Clean data: remove true duplicates, tidy text, and make dates (DD/MM/YYYY) and currency consistent, checking row counts and totals
- Build summaries and pivot-style tables, choose the right chart, and keep charts honest with sensible axes and accurate captions
- Reconcile, spot-check and sense-check AI analysis, and explain why correlation does not show causation
- Apply privacy steps and approved-tool rules to business data, and complete a mini-project with fictional sales data
Course details
- Format: online and self-paced, 6 narrated video lessons with captions, activities and practice checks
- Time: about 1.5 hours, including the quiz
- Assessment: online quiz, marked automatically, 3 attempts, 80% to pass
- Certificate: Certificate of Completion when you pass
- Includes: participant guide PDF to keep
- Price: $99 AUD per person; group bookings available
Frequently asked questions
Is this course accredited? No. This AI spreadsheet training online course is a non-accredited short course and is not nationally recognised training. You receive an ASTC Certificate of Completion.
Which formulas does it cover? SUM, IF, XLOOKUP or VLOOKUP, COUNTIFS, SUMIFS and dates, tested on sample rows before you rely on them.
Is there a hands-on project? Yes. You finish with a mini-project using fictional sales data.
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.