Office Series 2018 – Introduction to Power Query
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.
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!
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.