Have you spent a lot of time performing repetitive cleanup tasks on your data, using multiple VLOOKUP functions to merge data, or trying to combine multiple datasets? If so, then Excel’s Power Query tool will transform how you work. You’ll learn how to connect to multiple data sources, and set up queries to remove unneeded data, manipulate existing data, and even create new columns. And the best part is, once you’ve set up your query, you’ll just refresh it when you need to perform those tasks. Microsoft certified trainer Kathy Jones will show you how to use the Power Query Editor to perform all of these functions and streamline your workflow in the process.
- 13 Sections
- 1h 45m Duration
Introduction
Purpose of Power Query
Connecting to Excel
Connecting to Other Sources
Cleaning Up Data
Working with Rows and Columns
Manipulating Data
Adding New Columns
Managing Applied Steps
Managing Queries
Using Append Queries
Using Merge Queries
Creating a Web Query
Free
Course Includes
- Connecting to data in Excel, databases, and other sources
- Cleaning up and transforming data
- Adding new columns
- Sorting, filtering, and unpivoting data
- Managing applied steps
- Managing multiple queries
- Creating append and merge queries
- Creating a web query
