Description
Focuses on using Power Query to clean, shape, and transform data while still allowing you a one-click refresh.
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.
Highlights
- File maintenance
- Custom columns
- Un-pivoting a table
- Look-up tables