ACE-DA-02BeginnerTier 3 · Specialist
AI in Excel and Google Sheets
Use AI in Excel and Google Sheets to work with formulas, organise information, and answer practical data questions.
What you’ll explore
- Use AI to write, explain, and debug spreadsheet formulas
- Prompt AI to clean, reformat, and transform messy data
- Build AI-assisted pivot table summaries and simple dashboards
- Apply AI-assisted spreadsheet techniques to real work tasks
- Build a repeatable, verified AI spreadsheet workflow — and recognise when not to rely on AI
- Choose the right AI tool for their spreadsheet environment
Course outline
01AI for Spreadsheets: The Big Picture60 min
02AI Formula Writing: From Plain English to Spreadsheet Power60 min
03Data Cleaning and Transformation with AI60 min
04AI-Powered Analysis: Pivot Tables, Summaries and Dashboards60 min
05Automating and Scaling Your AI Spreadsheet Workflow60 min
Who it’s for
Professionals who use Excel or Google Sheets regularly but are not power users Administrative, finance, marketing, and operations staff who spend real hours in spreadsheets each week Anyone who wants to do more with their spreadsheet data in less time, without formal spreadsheet training