Office Series 2022 - Data Cleansing in Excel Made Easy


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

Have you ever had the experience of importing data into Excel and then having to reformat and clean it up to a workable format before you can even begin performing any kind of 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 and displays it in a way that Excel loves and can work with. 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!

Get & Transform is built into Microsoft Excel since 2016 (including Office 365) and is available as an add-in for Excel 2010 and 2013 users. (It was called Power Query).


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


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

  • Feb 17
    Thu, 10:30 AM NZDT - 11:45 AM NZDT Online
    • $195.00 excl. GST

Coming Soon

  • Tue 08 Feb 10:30 AM NZDT
    Mandating Vaccinations for Employees – Legal Developments 2022
  • Tue 08 Feb 2:30 PM NZDT
    Leading a Team 2022
  • Wed 09 Feb 10:30 AM NZDT
    Trust Series 2022 - Trust Fundamentals
  • Wed 09 Feb 2:30 PM NZDT
    Year-End Tax Planning 2022
  • Thu 10 Feb 2:30 PM NZDT
    Tax Residence Update 2022
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.