SpeakersAgendaMasterclassesVisitor Info
Partners
Event PartnersParticipating Companies
ContactGet Tickets
0

Your Cart

  • :
Remove
Subtotal:
Pay with browser.
Continue to Checkout
No items found.
Product is not available in this quantity.
Power Query in a Day

Power Query in a Day

16 & 17 Oct 2025
09:00–12:00 BST
Online-only

‍Discover the full potential of your data with Power Query - one of Excel's most powerful tools for data transformation and process automation.

In this special in-depth 2 half-day Masterclass,Microsoft MVP Wyn Hopkins focuses on real-world techniques, utilising the amazing functionalities of Power Query. You will streamline your data workflows and enhance your reporting capabilities.

Whether you're cleaning messy data, combining data from multiple sources, or building automated reports, Power Query empowers you to work faster and smarter. Best of all, you will do it all without writing a single line of code. By mastering Power Query, you’ll reduce manual tasks, eliminate data entry errors, and create repeatable processes that save hours every week.

‍

What you'll learn?

  • Introduction to Power Query: Understand the basics and interface.
  • Data Importing: Learn how to import data from a range of different sources.
  • Data Transformation: Master data cleaning techniques.
  • Merging and Appending Queries: Combine data from multiple sources effectively.
  • Creating Custom Columns: Use formulas to add new insights.
  • Best Practices: Implement strategies for efficient and maintainable queries.

‍

This Masterclass will be delivered by Microsoft MVP Wyn Hopkins on 16 & 17 Oct 2025 as an online-only course.

What's included

6 hours Masterclass with Microsoft MVP Wyn Hopkins
6 hours of CPD (Continuing Professional Development) hours / points
All downloadable presentation and working files
Masterclass recording
Certificate of completion
Join from anywhere in the world

Who is it for

This Masterclass is perfect for professionals who work extensively with data and who would like to improve the efficiency and accuracy in their workflows. Typical attendees include:

  • Analysts who extract, re-organise and analyse data on a regular basis
  • Accountants, interested in automating their month end processes in Excel
  • Buisness Intelligence professionals connecting to data sources that are poorly organised
  • Anyone interested in saving huge amounts of time when creating recurring reports and dashboards

Download Course Brochure

Download Brochure

About trainer

Wyn Hopkins

Microsoft MVP, Excel Expert, Book Author

Wyn has been awarded MVP status by Microsoft every year since 2017 and is the author of the book “Power BI for the Excel Analyst”. He is known worldwide for sharing his knowledge via the Access Analytic YouTube channel with over 5 million views and 90,000+ subscribers.He gained his Chartered Accountant qualification at PwC in 2000 and has extensive Business Analyst experience with HBOS and Barclays in the UK plus multinational clients in Perth.Wyn is skilled in Excel and Power BI development, Power Query automation, management reporting and is an experienced Excel and Power Bl trainer.

What people think of

Wyn Hopkins

★★★★★

Once you see the magic, you cannot unsee it.

JUST DO IT! Any finance person who works with data must take this course.

Anonymous
★★★★★

This course is really helpful!

I would highly recommend it!

Anonymous

Course contents

Wyn Hopkins

No items found.

Training requirements

Skills Requirements
  • This is a beginner’s class. No previous knolwedge of Power Query will be expected.
  • Previous knowledge of Excel, VLOOKUP / XLOOKUP / Pivot Tables is highly recommended.

‍

Software Requirements
  • This class will be delivered, using Microsoft Excel 365. For Excel 365 ensure you have a build version greater than 2023  (you can check via File > Account > the About Excel section contains the Version  (2023 means March of 2022)
  • Windows only (No Mac)

Buy ticket

Buy 365-Day Digital Masterpass

Please submit proof of student status  before proceeding to checkout.
Max file size 10MB.
Uploading...
fileuploaded.jpg
Upload failed. Max size for files is 10 MB.
Thank you! Your file has been attached successfully.
Oops! Something went wrong while attaching your file. Please try again.

If you continue experiencing issues, you can send it to us via email to info@globalexcelsummit.com
5
Early Bird tickets left
Total (incl. VAT):
£ 280
%
Free cancellation before 1 October 2025.
Event Recording and all speaker files included.
6 hours of CPD points - accredited by CPD Standards Office UK.
Sold out.

Check out all upcoming CPD-accredited in-person/online Masterclasses.

Register your interest for the upcoming Global Excel Summit 2026 now.
Product is not available in this quantity.
16 & 17 Oct 2025
09:00–12:00 BST
Online-only

Join the Master Club

Your exclusive all-access pass to our entire digital learning experience for a whole year.

Get 365-Day Digital Pass
Pages
Home
20212022202320242025
About UsFAQsOnline CoursesBlogContact
LEGALS
Privacy PolicyTerms of Service
Subscribe to our newsletter!
The Global Excel Summit is a premium global conference bringing together thebrightest minds from the world of Excel.
© 2025 The Global Excel Summit is organised and managed by DATEL Productions Limited, a company incorporatedin England and Wales (no. 10106893) and registered at Suite 407, 95 Wilton Road, London SW1V 1BZ, UK.