Power Pivot and Power Query Essentials
Power Query
You probably spend a lot of time importing, cleaning and transforming data before you analyze it. In this course, you’ll learn how to speed up that process with a tour of the Power Query tool in Excel.
Intermediate    17 Lessons    120 Minutes    CPD Credits
About This Course
When you know that your data is stored in the one place, is clean, and ready for analysis, you can spend more time on mining for insights. Power Query helps to prepare your data, before you begin working with it. This course will guide you through the tool’s use.
Across 17 lessons, you’ll learn how to create a query, edit and manipulate it, merge it with others, and run the query to best serve your needs.
By the end of this course, you’ll feel confident in prepping your data before importing it to Excel, where your analysis can begin.
Learning Outcomes
-
Connect to files or folders in Power Query
-
Pivot and unpivot a dataset
-
Adjust the types of your data
-
Merge columns of data and merge queries
-
Filter and format your data
-
Add custom columns to a dataset
-
Load queries into Excel
-
Refresh a query when the underlying data updates
Lessons
1. Power Query Overview and Installation
2. Connecting to an Excel File
4. Pivoting and Unpivoting
5. Q&A - Connecting to Data
6. Data Types
Read More
7. Merging Queries and Columns Part 1
8. Merging Queries and Columns Part 2
9. Q&A - Unpivoting and Merging Queries
10. Filtering
11. Formatting Columns
12. Q&A - Filtering and Formatting Columns
13. Adding Custom Columns
14. The M Formula Language in Power Query
15. Editing and Loading Queries
16. Adding New Data
17. Q&A - Adding Columns and Managing Queries
Learning Certificates
Showcase Your Skills
Each time you complete a course exam, you earn a certificate that demonstrates your proficiency in that subject matter. We are proud to be able to say that Kubicle certificates are recognized by the most respected employers from around the world.
When you earn internationally-recognized certificates, you increase confidence. And when you enhance your ability, speed and accuracy, you increase your employability.
