Excel - Power Query
What you'll learn
- Describe the purpose of Power Query
- Connect to data in Excel, databases, and other sources
- Clean up and transform data
- Add new columns
- Sort, filter, and unpivot data
- Manage applied steps
- Manage multiple queries
- Create append and merge queries
- Create a web query
Requirements
- Mastering Microsoft Excel 365 Intermediate course or strong Excel skills
Description
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
Describe the purpose of Power Query
High-quality HD content in the “Uniquely Engaging”TM Bigger Brains Teacher-Learner style!
Course Goal: By the end of this course, you will be able to describe the purpose of Power Query, link to multiple types of datasets, transform data, and manage queries.
Who this course is for:
- Intermediate to advanced Excel users who need to import, clean up, or manage data on a repeated basis.
Instructor
- 4.3 Instructor Rating
- 23,657 Reviews
- 106,345 Students
- 140 Courses
Let's face it, no online training courses are "fun." But some (like Bigger Brains) are engaging and better to spend time on than others!
Bigger Brains courses are built in a unique Teacher/Learner style, featuring two people on camera to recreate some of the interactivity and physiological benefits of classroom training, including dialogue, humor, and practical use case examples. This uniquely engaging video-based format is more enjoyable and, more importantly, more effective than traditional eLearning formats.
Bigger Brains courses are popular with both learners and training professionals around the world. Because we use experienced teachers and subject matter experts with real-world experience, we have the most realistic and comprehensive online training courses possible.
There are also resources to help you learn along with the way. Most Bigger Brains courses include handouts and practice files. Some even include free post-training reinforcement through the BrainBot learning retention app.
Join the hundreds of thousands of learners around the world and upskill, reskill, and stay in the know with Bigger Brains!