FeaturedUdemy
Intermediate Power Query in Excel
4.8(1,116)12k studentsINTERMEDIATEEnglish
Korshub's take
Course Overview
Master advanced data transformation and ETL capabilities in Excel Power Query. Learn to merge and append datasets with various join types, leverage the Advanced Editor, write custom M formula language functions, and manage dynamic filter parameters.
Who Should Enroll?
Designed for Excel analysts and data specialists who know Power Query basics and want to build sophisticated automated data preparation workflows.
Key Takeaways
- Dataset Integration: Append and merge complex datasets using various relational join strategies.
- M Language & Advanced Editor: Inspect and edit Power Query M code syntax for custom conditional columns and transformations.
- Custom Functions & Parameters: Craft reusable M functions and dynamic parameters to automate query execution.
About this course
Building on your foundational Power Query in Excel knowledge, this intermediate course takes you to the next level of data transformation mastery. Discover advanced data integration techniques, including appending and merging datasets with various join types. Delve into M language syntax for creating custom conditional columns and harness advanced table transformations. Unlock the Power Query Advanced Editor, exploring M's built-in functions, mastering best practices like query grouping, and dynamically adjusting filter criteria with parameters. Elevate your skills by crafting custom M formula language functions, unleashing advanced query design capabilities that will empower you to extract deeper insights from your data.
Price
Free
Advertisement