1. Congratulations!
Congratulations - you've made it to the end of this Introduction to Power Query in Excel course!
2. Getting started with Power Query in Excel
You learned about the main features of the Power Query editor, including how Power Query in Excel facilitates ETL in data workflows. You learned how to load data from multiple sources and manipulate rows and columns to set up data for analysis. You also learned the applied steps log and the interplay between the Power Query editor and loading tables into Excel workbooks.
3. Data Cleaning and Preparation
You learned how to leverage Power Query's column profile and view column features to assess for data quality and summary statistics. You also mastered filtering data, troubleshooting errors, and dealing with missing data. You learned how to identify and remove duplicates and how to handle outliers.
4. Column Transformations
You delved deeper into transformations by learning various techniques to perform numerical transformations by transforming existing and adding new columns. You learned to work with date and time fields and transform and derive necessary elements. You also mastered many text transformations, such as case conversion and sub-string extraction.
5. Shaping and Grouping Data
Last but not least, you learned how to effectively shape, reshape, group, and aggregate data of many different types and varieties. You learned to transpose data, pivot columns, perform group by transformations, and introduce how deriving new queries differs using reference versus duplicate.
6. Where we started
In this introductory course, you got hands-on experience with many of the great features that Excel Power Query offers in the ETL journey from raw data to analytical insights.
7. What we have covered
While we explored and touched on many features, it is still really scratching the surface of the many capabilities that Power Query in Excel has to offer.
Expanding beyond this introductory course is the opportunity to really delve into deeper use cases of each step and more advanced transformations and customizations to bring your analysis to the next level.
8. Congratulations!
Congratulations again, and great job on completing this course!
We hope you enjoyed getting to know some of the features of Power Query in Excel, and we look forward to seeing you in the next course!