Focuses on using Power Query to clean, shape, and transform data while still allowing you a one-click refresh.
Learning Objectives
Use Power Query to solve your data clean-up issues.;Determine how Power Query allows you to get more data into Excel.;Apply a one-click step to refresh your data.
Major Topics
File maintenance;Custom columns;Un-pivoting a table;Look-up tables