Key features
- Conditional Formatting - Use colour scales, icons, and rules to automatically highlight KPIs, targets, deadlines, and variances, turning raw data into instantly understandable visuals.
- Lookup Master - Learn the ins-and-outs of the popular VLOOKUP and XLOOKUP functions to match, consolidate, compare, and validate data with confidence.
- PivotTables in Action - Discover how to quickly summarise and analyse datasets using PivotTables — one of Excel’s most powerful yet accessible reporting tools.
By the end of this session, you'll have the techniques to apply immediately in your work for greater efficiency. It’s time to feel confident in Excel.
