From Chaos to Clarity: Turning Messy Data into Client-Ready Visuals
4 June 2026 | 2:00 PM - 3:00 PM (BST)
Overview
This 60-minute session is designed to help everyday Excel users take messy, unstructured data and turn it into clean, professional visuals that are ready to share with clients or stakeholders.
We begin by exploring common data problems and why they can undermine the clarity and impact of your reports.
Next, we introduce Power Query, a powerful tool built into Excel that makes cleaning and organising data fast and easy. Participants will see how to remove errors, reshape columns, and combine data from multiple sources, all without needing to write formulas or code.
We then move into Power Pivot, which helps users link different tables and perform simple calculations to prepare data for analysis. This step is key for building a solid foundation before creating visuals.
The session continues with a hands-on look at PivotTables and PivotCharts, showing how to turn cleaned data into clear, interactive visuals
What you’ll learn
- Recognise common issues in messy data
- Use Power Query to clean and organise data
- Apply Power Pivot to build simple data models
- Create clear visuals using PivotTables and PivotCharts
- Prepare client-ready reports from cleaned data
Speaker
Richard Edgerton
Digital Productivity and Office Applications: Learning consultant
Richard Edgerton is a Microsoft Office Master Instructor with 30 years' experience, and he's QA’s lead on Office 365 End User Applications and Power BI courses for business users.