1. Congratulations!
Congratulations! You have completed the Intermediate Power Query in Excel course!
2. Combining queries in Power Query
You learned how we can combine queries within the Power Query editor, including appending to stack datasets together and merging based on common columns. You learned the various types of joins that can be leveraged, including when special join conditions such as fuzzy matching can be useful.
3. Custom Columns
You deepened your understanding of how Power Query automatically generates M code for each query step taken and mastered how to build various types of custom columns, including nested conditional logic and advanced indexing.
4. M Formula Language
Last but not least, you gained an in-depth understanding of the Advanced Editor, learned the basic value types (primitive and structured) within M code, and explored various Power Query's built-in functions. You also leveraged flexible query parameters and built custom functions of your own.
5. Congratulations!
Congratulations again, and great work on completing this course!
We hope you enjoyed delving deeper into some intermediate features and functions within Power Query for Excel!