Course description
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 and interactive session with leading trainer Alan Murray is for you.
Upcoming start dates
Outcome / Qualification etc.
Training Course Content
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
Expenses
MBL Seminars Limited
MBL is a leading learning and development provider for professional service firms. Over the past 18 years, more than 198,000 people across 23,000 different organisations spanning 81 countries, have chosen us to deliver their training. With over 800 expert speakers...