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.
Learning Objectives:
- 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
Note: Due to differences between operating systems, Blackbaud University courses supporting Microsoft products are best consumed on computers running the Windows operating system.
Suggested Prerequisites:
