Power Query Training

Automate Your Data Cleaning Workflow

A FREE Microsoft Excel tool that:

  • Prepares your data accurately for reporting and analysis.

  • Automates data updating, cleaning, and shaping processes extensively.

  • Does not need macros or VBA programming.

  • Can be applied to Power BI.


But first, What's in it for You?

Save HOURS of self study. We give you the boost you need.

Learn exciting ways to add value to your data. We’ve carefully tailored our courses to feature all important aspects of Excel’s Power Query. This includes learning how to build speedy, automated data cleaning workflows. In just 2 days, you’ll gain useful skills to help you achieve maximum efficiency. 

Get inspired through personalised engagement.

Our Power Query training class focuses on interaction, coupled with a hands-on approach. Discuss your Excel pains with us and address your challenges. We’ll guide you to sustainable solutions as you engage in class and with our coach. You'll have access to expert advice on how to get your data talking for you.

Free consultation to ensure you're on the right track.

We care about your success: it’s important to us that you show off those new Excel ninja skills at work. Learning is a continuous process, so if you need extra advice or have more questions on Power Query, we've got you covered. Reach out to us anytime for a no-frills 90 mins post class session.

The future belongs to those who learn more skills and combine them in creative ways
— Robert Greene

 Course Overview

(Upcoming classes 20 & 21 December 2018, 14 & 15 February 2019, 16 & 17 March 2019)


What you learn:

Effective use of Power Query editor to:

  1. Connect and combine multiple data sources without VLOOKUP(), INDEX() or MATCH().

  2. Clean, shape, and transform raw data into flexible and easy-to-manipulate forms.

  3. Group and summarise your raw data easily.

  4. Add calculated columns.

  5. Create custom functions that lets you automatically apply the same data preparation steps to separate files and combine them.

What you get :

  • Course materials

  • Light refreshments

  • FREE 90-minute after-class consultation session. If you need some extra help to implement what you have learned in our classes, we've got you covered! You'll receive customised advice on which specific functions / set-up you should consider applying to your report-building process.

Need an extra boost? Consider our 2-in-1 course!

FREE e-book and additional consultation session if you register for both Power Query and Power Pivot training classes now.

lightdotlab reviews from past participants