Excel – Power Query
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.
- 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
