Excel Get & Transform/PowerQuery
Automate messy data cleanup and transformation with Excel's Get & Transform / Power Query tools.
Scheduled dates
This course is available for private and onsite training - delivered for your team anywhere in the U.S., or virtually on your schedule. You can also ask us to add it to the public calendar, or let us know you’re interested and we’ll reach out when a date is set.
Course objective
In this class, we will delve into the benefits and features provided using Power Query. We will examine the options available within the ribbon, as well as explore and demonstrate importing, filtering, transforming, and merging data using Power Query or Get and Transform.
Prerequisites
To ensure your success, we recommend that you first take Excel Level 1, Level 2, and In-Depth PivotTables, or have equivalent knowledge and skills - such as knowledge of advanced features and functions. Contact us to discuss if this class is right for you.
Course outline
- Get & Transform Data on the Data Tab
- Identify Data Source Types Available for Import
- Connect to a Data Source
- Create Queries from Excel, Access, a Website, Folder and More
- Data Load Options and Query Navigation Panel
- Column Options in Query Editor
- View and Modify Query Steps
- Sort and Filter Data in Query Editor
- Transform Date using Number, Date & Time, and Structured Columns
- Pivot a Column
- Append Data from Two Queries
- Merge Two Queries Together
- Manage the Queries Pane in Excel
- Use Query Editor to Aggregate Data from a Column
- Introduction to the Data Model