Learning Outcomes

In this free course, you will learn how to:

• Discuss the history of the Microsoft Excel Power Query tool
• Explain the process of manipulating data with Power Query in Excel
• Summarize the steps for wrangling data to solve various problems
• Define the concept of M code
• Indicate the process of locating the M code
• Outline the Power Query features and items
• List the stages for merging several datasets from various systems
• Describe how to change the sample file
• Summarize the process of combining data from other folders