.png)
Transform, analyse, combine and visualise your data more efficiently in Excel
Many Excel users still prepare data by hand and stitch tables together with VLOOKUP or XLOOKUP. It works until the data grows, the sources multiply and the same manual steps have to be repeated every month. Power Query and Power Pivot, two of Excel's most powerful data analysis tools, are built to solve exactly that.
This hands-on online Masterclass, delivered over two 3-hour sessions, introduces Power Pivot and Power Query, showing you how to build data models across multiple tables, automate data preparation and turn the results into interactive dashboards. You'll work with relationships, FACT and DIMENSION tables, your first DAX measures, and queries that clean and combine data from workbooks, CSV files and folders.
You'll move beyond traditional formulas and manual processes to more efficient, reliable and scalable data analysis workflows that you build once and simply refresh whenever new data arrives.
What you'll learn?
- How to build a data model in Power Pivot by creating relationships between multiple tables, without relying on complex lookup formulas
- How to structure your data correctly using FACT and DIMENSION tables
- The fundamentals of DAX (Data Analysis Expressions) to create calculated measures and more advanced calculations
- How to analyse your data model with PivotTables, PivotCharts and slicers, and design dashboards that are clear and easy to use
- How to import, clean, transform and combine data from workbooks, CSV files and folders with Power Query
- How to automate repetitive data preparation, so updating your report becomes a single refresh
This class will be delivered online over two sessions on 20 & 21 May 2027 (9:00 am–12:00 pm BST each day).
This training is available as a single Masterclass or as part of our Premium (Online) or Ultimate (Online) Global Excel Summit ticket.
What's included
Who is it for
For Excel users who spend too much time preparing, combining and summarising data by hand, and want reports that refresh in a click. Typical attendees include:
- Finance and accounting professionals
- FP&A and management reporting teams
- Financial controllers
- Business and data analysts
- Excel users ready to move beyond VLOOKUP, XLOOKUP and manual copy-and-paste
Download Course Brochure
Course contents
- A quick refresher on advanced Excel Tables and PivotTable features, including slicers and Show Values As
- Combining data from multiple tables without VLOOKUP or XLOOKUP, instead of building large "super tables"
- FACT and DIMENSION tables: structuring your data correctly and creating relationships between them
- A first introduction to DAX: creating custom measures and more advanced calculations
- Turning your data model into an interactive dashboard with PivotTables, PivotCharts and slicers, plus design best practices
- Connecting Excel to external data sources: other workbooks, CSV files, folders and data from other applications
- Choosing how to import and load data to suit your reporting and analysis needs
- The Power Query Editor: removing columns, filtering rows, splitting fields, changing data types and creating custom calculations
- Automating repetitive preparation: build the steps once, then refresh whenever new data arrives
- Appending and merging queries, and consolidating multiple worksheets and files into one structured dataset
About your trainer
Wim Verhaege
Wim Verhaege is an Excel and Power BI trainer, consultant and coach with more than 15 years of experience in data analysis across sport, pharmaceuticals, transport and international trade. A Microsoft Office Specialist (MOS) Excel Expert and certified Power BI Data Analyst, he is the founder of EXsport, a company specialising in Excel and Power BI training and consultancy.
Wim delivers more than 200 training sessions a year in Dutch, English, French and German, helping professionals build practical skills from beginner to expert level. He also provides consultancy and coaching in financial reporting and data analysis for organisations in banking, insurance, oil and gas, real estate and construction. As co-founder of the Belgian Power BI User Group, he organises free seminars and knowledge-sharing events for the data community.
What people think of
Wim Verhaege
Training requirements
Attendees should already be comfortable with day-to-day Excel use. Please make sure you have:
- A computer with a desktop version of Microsoft Excel 2021 or later (Excel for Microsoft 365 recommended). Excel for the web does not fully support Power Query and Power Pivot.
- A Windows computer, as Power Pivot is not available in Excel for Mac.
- A stable internet connection to join both live sessions.
Buy ticket
Buy 365-Day Digital Masterpass
If you continue experiencing issues, you can send it to us via email to info@globalexcelsummit.com
.gif)
Early Bird registration is open
18–19 May 2027 · London & Online. Save 20% – limited to 100 in-person and 100 online tickets.
