This class focuses on using Power Query (Get and Transform) to clean, shape and transform your messy data while still allowing you a one-click refresh. We will review various data issues including appending files, combining multiple files from a folder, adding custom columns, unpivoting data, creating a lookup table, and much more.
Learning Objectives:
Use Power Query to solve your data clean-up issues
Determine how Power Query allows you to get more data into Excel