All   >   Excel – Power Query

Excel – Power Query

Save time cleaning up and managing your data with Excel’s popular power tool

Course details

Save time cleaning up and managing your data with Excel’s popular power tool  

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. 

 

Topics covered include: 

  • 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 

 

High-quality HD content in the “Uniquely Engaging”TM Bigger Brains Teacher-Learner style! 

Course Contents:

1  Introduction  1:32 
2  Purpose of Power Query  3:51 
3  Connecting to Excel  6:45 
4  Connecting to Other Sources  8:50 
5  Cleaning Up Data  9:21 
6  Working with Rows and Columns  8:46 
7  Manipulating Data  6:24 
8  Adding New Columns  7:14 
9  Managing Applied Steps  8:31 
10  Managing Queries  9:53 
11  Using Append Queries  5:08 
12  Using Merge Queries  6:04 
13  Creating a Web Query  4:25 

Course details

Related Course Recommendations

Brain Bites – Microsoft Loop

Hybrid Meetings

Brain Bites – Fire Safety

OneDrive in 30 Minutes (2024)

Bigger Brains Course Catalog and Pricing

Fill out the information below to receive a download link for our latest course catalog.

Get More Information

Looking for eLearning content or other training solutions for your company? Let us know how we can help!