Office Series 2022 - Introduction to Get and Transform - 18 August 2022 (On Demand)


Get & Transform (Power Query) makes self-service Business Intelligence easy!

Do you want to learn how to extract, reformat and clean up the data before loading it into Power BI Desktop for analysis?

Join us in this webinar and we’ll show you how Get & Transform can make your life a lot easier. It accesses, cleans, and transforms all that untidy data before loading it to Power BI. The best thing is that the next time you receive the same file, all you need to do is press the Refresh button and your data will automatically be cleaned up and displayed the correct way!

Note: We will be demonstrating in Power BI Desktop.


18 August 2022


In this webinar you will learn:

  • How to get data from an Excel file, CSV, the web
  • How to cleanse/scrub/shape that data
  • How to load that data in Power BI desktop


This webinar is designed for Business professionals, Business owners, Financial Controllers, Accountants and anyone who requires to do data analysis.

Attendees should be comfortable with Microsoft Windows environment, and be familiar with Microsoft Office applications – particularly Excel.


Ryan Racelis, Senior IT Trainer, Auldhouse.

1.25 CPD Hours

  • On Demand Event
    • $195.00 Summer Sale 40% Discount - Apply Promotional Code: SUMMER40 $117.00excl. GST
    Complete online in your own time (Self-paced)
    • $195.00 Summer Sale 40% Discount - Apply Promotional Code: SUMMER40 $117.00excl. GST

Coming Soon

All Coming Soon >>


Our webinars operate on a 'one-connection-one-fee' basis so you can have your whole team participate for one cost effective price and claim CPD points.


All registrants to a live webinar will automatically be sent a recording at the end of that week along with a full transcript of the webinar, regardless of whether you attended or not.

Sole practitioners

A discount on webinars is available for sole practitioners. Please contact us at NZ‑ to confirm eligibility.