Power Query Basics
This 90-minute virtual session teaches the basics of using Excel’s Power Query to transform and clean data imported into Excel.
About this event
Excel is an excellent tool for managing large data lists from many sources, but what do you do if your data is inconsistent? Data entry inconsistencies, formatting, and different column names can make working with your Excel information hard. Using the Power Query tool helps you import or connect to different data sources and then shape, clean, and transform that data in a way that is easier for you to analyze using tables, charts, and PivotTables.
Join the Office Productivity Training, LLC staff for “Using Excel’s Power Query to Clean Your Data.” This 90-minute virtual session teaches the basics of using Excel’s Power Query to clean data imported into Excel from other worksheets or data sources.
Topics include:
- Overview of Power Query
- The Power Query Interface
- Connecting to Source Data
- Transform Data
- Removing Columns
- Changing Data Types
- Filtering Data
- Split Column
- Add Column-Column from Example
- Add Column – Custom Column
- Replace Values
- Removing Rows
- Removing Duplicates
- Removing Blank Rows
- Loading Data to Excel
- Adding and Refreshing Data
Course materials include a quick reference guide and practice files. We will host this training using Zoom.
