Auldhouse Anywhere

Auldhouse Anywhere

Our range of Auldhouse Anywhere courses enable you to join live classroom training online – saving you time and money on travel.

Find out More
E-Learning

E-Learning

Discover the benefits of taking a course online at your own pace.

Find out More
Webinars

Webinars

Auldhouse deliver a number of vendor specific webinars. Webinars give you an effective training option with the freedom to attend from virtually anywhere.

Find out More

Introduction to Power Query

Code:
WEXLPQ
Days:
0.5 Day
Price:
$149 excl GST
Code:
WEXLPQ
Days:
0.5 Day
Price:
$149 excl GST
Overview:
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 Power Query 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!

Power Query is built in to Microsoft Excel 2016 and is available as an add-in for Excel 2010 and 2013 users. (Power Query is known as Get and Transform in Excel 2016)

Register now for this course

Please take special note of the course prerequisites as it is important that you meet these requirements before attending the course. If you have any questions about dates or locations please dont hesitate to make an enquiry contact us on 0800 835 835.

No classes currently scheduled in your location?Enquire about this course

Interested in a private class? Enquire about a private class