Power Query with Excel: Introduction
Power Query makes self-service Business Intelligence easy!
Stream this recording multiple times at your convenience.
- $200.00 incl. GST
- PD hours: 1.25
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).
Please download the Power BI Desktop version from here https://powerbi.microsoft.com/en-us/get-started/
Webinar Learning Outcomes:
• 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.
Michael Blignaut 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.
You will be provided with:
• PowerPoint Presentation slide deck
• Any Supporting Documentation
• Webinar Recording to view multiple times for up to 6 months
• An opportunity to ask questions to the presenter
|Workflow Automation for Professionals (4 of 5)||Webinar Recording|
|The Best of Microsoft OneNote 2016||Webinar Recording|
|Office Series 2018 – MS Excel PivotTables||Webinar Recording|
|The Best of Microsoft PowerPoint 2016||Webinar Recording|