Office Series 2018 - Introduction to Power Query
Self-service Business Intelligence made easy!
Stream this recording multiple times at your convenience.
- $180.00 incl. GST
- PD hours: 1
Have you ever had the experience of importing data into Excel and then having to spend time reformatting and cleaning it up so it’s in a useful format before you can even begin performing any kind of analysis? Then you need to do it all AGAIN to update your reports next month!
Join us in this webinar and we’ll show you how to make your life a lot easier by using Power Query to access, clean and transform all that untidy data and display it in a way that Excel loves to 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 new data will automatically be cleaned up and displayed exactly as you want it!
All files and documents used in the webinar will be made available to attendees.
Webinar Learning Outcomes:
Attendees will learn how to use Power Query to:
• get data from an Excel file, CSV file or the web
• cleanse, scrub and shape that data
• load that data
Business professionals, Business owners, Financial Controllers, Accountants and anyone who performs data analysis.
Attendees should be comfortable with Microsoft Windows environment, and be familiar with Microsoft Office applications – particularly Excel.
This webinar will be presented using Microsoft Excel 2016. Power Query is built in to Microsoft Excel 2016 and is known as ‘Get and Transform’ but it is available as an add-in for Excel 2013.
Michael Blignaut is a Senior IT Trainer for Auldhouse. He is an enthusiastic and certified Microsoft IT Trainer. He is able to offer a wide range of Microsoft end-user, soft skills, business skills and project management training. He has extensive experience delivering training in a variety of formats including classroom, video conference/webinar and in one-to-one sessions.
Your webinar purchase includes:
• the PowerPoint slide deck as a PDF workbook
• any supporting documentation required
• access to stream the Webinar Recording multiple times
• an opportunity to participate in Q&A.
|Magic bullets with Excel - data validations||Webinar Recording|
|Workflow Automation for Professionals (4 of 5)||Webinar Recording|
|Office Series 2018 - Mail Merge in MS Word||Webinar Recording|
|Data Analytics and Dashboards (3 of 5)||Webinar Recording|