Excel & AI for Analytics
Turn Excel into a serious analysis tool, then use AI assistants to work faster and smarter.
Who it's for: Beginners and anyone who uses Excel but wants to analyse data with confidence.
- Session 1Excel for analysis
Clean, structured data with Tables, sorting, filtering and validation; the formulas analysts use daily (XLOOKUP, IF, SUMIFS); PivotTables and Power Query in Excel to summarise and reshape messy data.
- Session 2Dashboards & AI for analytics
Build an interactive dashboard with charts and slicers, then use AI assistants to write formulas, explain data and draft insights, with prompting techniques, accuracy checks and responsible use.