Excel Power Query - Change the Way You Work with Data

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