CCH Learning SEA

Office Series 2022 - Data Cleansing in Excel Made Easy - 17 February 2022


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).

What you will learn

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

Target Audience

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.

Expert Speaker

Ryan Racelis, Senior IT Trainer, Auldhouse

The webinar was recorded on 17 February 2022.

  • Elearning
    • $109.00 incl. GST
    • PD hours: 1.25
    Complete online at your own pace (Self-paced)
    • $109.00 incl. GST

Upcoming Events

All Upcoming Events >>

CCH Learning Corporate Training

Experience the benefit of CCH Learning events from the convenience of your own office. Providing customised training on a wide variety of specialised subjects, CCH Learning Corporate Training can be delivered in-house, at external venues or virtually. To find out how CCH Learning Corporate Training can help you build continuous learning strategies for your organisation, please contact us.

Join our Mailing list

Sign up here and be the first to hear about upcoming CCH Learning workshops and events.