What you’ll learn
- Cleanse, reformat, and standardise unstructured spreadsheet data using AI-assisted formulas and advanced tool interfaces.
- Request formula explanations, format alignment, and duplicate flagging without altering or risking source data integrity.
- Utilize AI to write, debug, and optimize complex Excel/Google Sheets formulas (XLOOKUP, INDEX/MATCH, Regex).
How the course runs
Before the session
Pre-session prep · about 30 minutes
Upload a non-confidential, intentionally corrupted spreadsheet dataset to the sandbox environment.
Live session
Instructor-led · 2 hours
2-hour technical clinic on spreadsheet error identification and formula generation.
After the session
Practice & reinforcement
Execute Tuesday Spreadsheet Cleanup practice—sanitise a 500-row operational table in 30 minutes.
Course modules
Data Sanitisation Techniques
Standardising date formats, text casing, address structures, and removing duplicates.
Formula Engineering
Prompting LLMs for nested formulas, array formulas, and custom functions.
Error Diagnostics
Pasting raw spreadsheet error codes into LLMs for instant troubleshooting.
Non-Destructive Workflows
Ensuring AI tools manipulate copy instances without modifying raw master datasets.
What you’ll take away
Deliverable: Sanitized operational dataset and an accompanying AI-generated spreadsheet formula dictionary.
How your learning is checked: Practical data sanitisation test evaluated on error reduction rates and speed.