Power Query - An Excel Tool to Change the Way You Work with Data

Introduction

Power Query is possibly the single best feature to appear in Excel in the last 20 years.

Power Query makes it easy to import sources from a variety of sources including CSV, text, PDF, the web or even folders on a shared drive.

Once imported we can perform transformation steps to prepare the data for analysis. Although there is much more to Power Query, this is its heartbeat. Simple (and more complex) transformations all recorded to be refreshed at the click of a button in the future.

If you are looking to import and transform data, merge queries and create robust reports then this live broadcast session is for you.

What You Will Learn

This live and interactive session will cover the following:

• Importing and transform data from external sources
• Merge Queries
• Merge queries are a fantastic feature making it easy and very efficient to combine data from different tables/sheets and to compare lists
• Creating Reports
• Power Query data is then loaded to a table on the worksheet, a PivotTable or the data model for further analysis and reporting. We will explore these options

Recording of live sessions: Soon after the Learn Live session has taken place you will be able to go back and access the recording - should you wish to revisit the material discussed.