Leverage Data with Power Query
Leverage data to create value with Power Query. This new Excel function does what it says on the tin – Gets data and Transforms it. Solve the problem of dirty data as you learn how to get and cleanse data from a wide range of sources before importing it for analysis into Excel.
Are you tired of exporting data from your accounting system and copying / pasting it into Excel? Sick of sorting and cleaning the data before you can use it in your calculations? Power Query (or Get and Transform, in Excel 2016) is the answer to your problems, and the best thing to happen to Excel since it was released.
In this webinar you will learn to harness the power of Power Query (for Excel 2010 and 2013). Connect to a range of data sources and clean it using a powerful and intuitive point-and-click interface – no formulae needed! Then, once you’re done, set it up so that it will update and refresh in the future with a click of a button, following your every step. If you haven’t used this before, this is a must-view session.
Presenter, Tim Heng, is a Director at the consulting firm SumProduct. He runs a range of Excel training courses listed on the Chartered Accountants Australia New Zealand store, and is a Microsoft MVP specialising in Excel, one of only ~110 worldwide.
Upon satisfactory completion of this webinar you will be able to:
- Connect to a range of data sources for import into Excel
- Transform the data into a format that meets your needs
- Process and link large amounts of data quickly to deliver key information in minutes
- Understand what version of Excel you have and how to get / enable Power Query
Leverage data to create value with Power Query. Learn how to use this powerful new function to simply and quickly increase your available clean data. Connect to a range of data sources and transform the data ready for use. Set yourself up to refresh with the click of a button.
Tim Heng, has over 10 years’ experience in financial model development, model auditing, banking, training and consultancy. He was previously the Head of Training at Corality, and is currently a Director at the consulting firm SumProduct. Tim has run numerous training courses in financial modelling and Microsoft Excel skills around the world. Tim is recognised by Microsoft as a Most Valuable Professional (MVP) expert in Excel, one off c.100 such individuals worldwide.
Topic: Business Mindset
Sub-Topic: Information & Communication Technology
Format: Recorded Webinar
Proficiency Level: Intermediate, Advanced
CPD: 1 hours