Career · Everyday work with AI
Clean Sheets: Excel course for beginners: faster spreadsheets with AI
Six lessons on the spreadsheet skills most office jobs use, with AI assistants such as ChatGPT, Copilot and Gemini doing the heavy lifting and you doing the checking.
About this course
Excel course for beginners: faster spreadsheets with AI.
Starter · About 1 hour of learning · 6 lessons · 12 quick checks · 1 download
Who it's for
Office workers new to Excel or Google Sheets who want to use AI assistants to work faster and check results, in Australia, the UK, the US and elsewhere.
How it works
6 guided lessons in your browser, with worked examples, exercises and a quick check after each lesson. Progress is saved in this browser only, and you can restart at any time.
Sources we rely on
11 published sources, mostly regulators and official bodies, listed below so you can check the original guidance yourself.
By the end you can
- Arrange data as a clean table that formulas, PivotTables and AI assistants can read
- Ask for formulas, explain them in plain words and test them against known values
- Use XLOOKUP and SUMIFS and avoid their most common mistakes
- Summarise data with PivotTables and honest charts, and check AI insights
- Let AI edit a workbook safely and keep sensitive data in approved tools
Downloads
- Excel practice workbook .xlsxPractice bookings data, a messy sheet to clean, a staff lookup table, formula and change logs, and an answers sheet.
Rules by country
Learning time
About 1 hour of learning. May count towards your CPD or professional development; check your professional body's rules. Estimated from reading time, exercises, quick checks and downloads.
Sources
Check the originals.
Drafted with AI assistance and run through automated quality and source checks. How these courses are made. Spotted an error or out-of-date rule? Send a correction.
General information and training only. Courses may count towards your CPD or professional development; check your professional body's rules. We don't guarantee employment or career outcomes.
- Get started with Copilot in Excel · Microsoft Support
- Frequently asked questions about Copilot in Excel · Microsoft Support
- Copilot in Excel tips · Microsoft Support
- Overview of formulas in Excel · Microsoft Support
- IF function · Microsoft Support
- XLOOKUP function · Microsoft Support
- SUMIFS function · Microsoft Support
- Create a PivotTable to analyze worksheet data · Microsoft Support
- Data analysis with ChatGPT · OpenAI Help Center
- Collaborate with Gemini in Google Sheets · Google Docs Editors Help
- Staff guidance on public generative AI · Digital Transformation Agency (Australia)
Publisher
Who publishes this course.
Published by trainyourself.org, a trading name of Combine TRS Pty Ltd (ABN 42 112 983 678), Brisbane, Australia.
How it's made: drafted with AI assistance from published guidance by regulators, professional bodies and software vendors, then run through automated quality checks against our course depth standard and automated source checks that match each rule to its official source, listed above. The course guide is an AI presenter and is labelled as one. Read how these courses are made.
Last updated:
General information, not careers, legal, employment or professional advice. Spotted an error or an out-of-date rule? Send us a correction.
Keep going
More in Everyday work with AI.
-
Plain Start: AI course for beginners: how AI works and how to use it at work
AI course for beginners: how AI and chat assistants work, why they make things up, which work tasks suit them and how to keep data safe. No sign-up needed.
-
Plan Ahead: AI for project managers
AI for project managers: draft a project brief, break down tasks, build a risk register, write honest status reports and close well, with checks at each step.
-
First Line: Cyber security awareness training for staff
Cyber security awareness training for staff: spot workplace phishing, verify payment and bank-detail requests, report fast without blame, protect work data.
-
Daily Assist: everyday work with AI assistants
How to use Copilot and other AI assistants at work: draft emails, get summaries you can trust, turn meeting notes into actions and keep your work data safe.
-
Lead Well: Management course for new managers
How to be a good manager: a starter course for new managers on clear goals, one-to-ones, feedback, early performance talks, wellbeing, change and safe AI use.
-
Clear Asks: learn prompt engineering: better prompts for everyday work
Learn prompt engineering for everyday work: brief AI tools clearly, add examples, set limits so they don’t invent details, check output, keep data safe.
Opening soon
Waitlist opening soon.
We're not collecting sign-ups yet. When the waitlist opens you'll be able to leave your email here to hear about new courses and tracks. Until then, the open courses need no sign-up.