Excel

Your data has a story to tell—are you letting Excel help you tell it? In this practical and creative session, you’ll learn how to transform rows and columns into clear, compelling visuals and reports that executives actually want to read. Discover how to use Excel’s built-in tools (like Charts, PivotTables, and Copilot) to highlight trends, reveal insights, and create presentation-ready visuals that work seamlessly in Word and PowerPoint. Whether you’re preparing board reports, meeting recaps, or performance summaries, you’ll leave with easy, repeatable techniques to turn raw data into professional storytelling that makes an impact.

Turn chaotic spreadsheets into clean, trustworthy data in one fast-paced session. You’ll learn how Excel’s Flash Fill spots patterns from a few examples and transforms names, dates, codes and text at scale—without formulas or macros. We’ll cover the rules that make Flash Fill behave, when to prefer Power Query, and how to combine both for bulletproof results. Expect practical demos: split and reorder fields, standardise formats, extract keywords, build clean lookup keys, and fix common data-entry mistakes. We’ll also tackle gotchas—locale issues, hidden spaces, inconsistent delimiters—and design a repeatable ‘data prep’ checklist. Leave with repeatable techniques that make datasets analysis-ready in minutes, not hours. Bring sample data to practise live.