Drastically reduce the time you spend cleaning up cluttered raw data by harnessing the power of Microsoft Excel’s built-in Power Query. With Power Query, you can script your own step-by-step alterations to view your data the way you need it. In this session, identify which types of source data you can modify with Power Query. Explore the options contained within the Power Query Editor. Clean up messy raw data with a few quick steps. Transform and adjust your data for readability, importing, or reporting.
Define and recognize uses for Power Query
Identify View options to quickly identify trends
Manage duplications and missing information within raw data
Split and merge cell data
Add new columns based on existing data
Filter and refresh results to keep your tables up-to-date