Course description
If you work with a lot of data, you simply must learn how to use Power Query.
Power Query is the best way to bring data from other sources such as PDF, Excel files, SharePoint, websites, and databases into Excel. In Power Query, steps are performed to clean and prepare the data and then load it to the Excel sheet, a PivotTable, or stored and used in the data model.
Presented by experienced Excel trainer Alan Murray, this full-day in-person seminar covers everything you need to know, including how to import data from various sources, how to clean and prepare data in just a few clicks, how to adjust the Power Query settings to work for you, and how to aggregate, group and pivot data, plus much more.
Upcoming start dates
Outcome / Qualification etc.
Training Course Content
Introduction
Power Query is the best way to bring data from other sources such as PDF, Excel files, SharePoint, websites, and databases into Excel. In Power Query, steps are performed to clean and prepare the data and then load it to the Excel sheet, a PivotTable, or stored and used in the data model.
What was once difficult, time consuming and would often involve advanced formulas or macros, is now easy thanks to Power Query.
Power Query is possibly the single best feature to appear in Excel in the last 20 years.
If you work with a lot of data, you simply must learn how to use Power Query.
NB: A laptop is required for the course.
What You Will Learn
This in-person course will cover the following:
- Import data from various sources including a folder of Excel files, PDF, CSV, and web into Excel
- Combine the data from multiple files and multiple sheets of an Excel file with ease
- Clean and prepare the data in just a few clicks
- Adjust Power Query settings to work for you
- Look up values in other tables and compare tables using Merge Queries
- Create and use parameters to dynamically change a value used by a query
- Perform calculations in Power Query including date calculations, standard arithmetic, conditional functions, and custom columns
- Aggregate, group, and pivot data
- Load data from Power Query to a table, PivotTable, or the data model and understand the benefits of each option
- Use the data model to create PivotTables from multiple different data tables
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...