What’s in this course
Introduction to Excel Power Query
- Course Introduction
- Course Content
- Introduction to Power Query
- Power Query Benefits
- Power Query Version and Compatibility
- Navigating the Power Query Interface
- Connecting to Data Sources
- Excel, Database, and Online Services
- Data Transformation Fundamentals
- Filtering rows and Columns
- Sorting Data
- Splitting and Merging Columns
- Changing Data Types and Formatting
- Applying Conditional Logic
- Error Handling and Null-Values
- Unpivoting and Pivoting Data
- Pivoting Data
- Advanced Data Transformation Techniques For Grouping and Aggregating Data
- Merging and Appending Queries
- Creating and Managing Custom Columns
- Handling Many-To-Many Relationships
- Loading Data into Excel and Integrating with Pivot Tables
Power Query Functions and Optimization
- Introduction to Power Query M Language
- Creating Custom Functions and Managing Parameters
- Best Practices For Data Transformation and Modeling
- Performing Optimizing Tips
- Troubleshooting Common Issues
Real-World Scenarios and Case Studies
- Hands-on Examples Showcasing Power Query Applications In Various Industries
- Query Applications in Various Industries
- Tips and Tricks For Efficient Data Analysis
- Resources For Further Learning
Get the Course Files
- Download the course files
Curriculum
Member access: Lesson videos and downloadable resources require academy login. Existing members get the same access they had on academy.excel.tv.
