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 course, 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.