This 90-minute virtual session teaches the basics of using Excel’s Power Query to transform and clean data imported into Excel.
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:
Course materials include a quick reference guide and practice files. We will host this training using Zoom.