- Getting started with Power Query
- Shaping data to delete and move rows and columns
- Building calculations
- Performing actions on multiple worksheets
- Combining data into one source
- Summarizing data with PivotTables and PivotCharts
Learning Lab - Microsoft Excel: Transforming Data with Power Query
- Date: 03/28/2023
- Start Time: 2:00 PM Eastern Time
- End Time: 4:00 PM Eastern Time
- Instructor: Ms. Dawn Bjork, MCTOwner/Software TrainerMs. Dawn Bjork, MCTdawn@thesoftwarepro.com — Phone: 303-699-6868With over 25 years' experience as a tech translator and problem solver, Dawn Bjork is The Software Pro®. Her informative and engaging style helps you discover easy ways to be more productive with software. The author of hundreds of training programs, Dawn is a Microsoft Certified Trainer as well as a Microsoft Office Specialist Master and Certified Virtual Presenter. In addition, Dawn has earned the Certified Speaking Professional designation or CSP, a credential held by less than 850 professional speakers worldwide. Fun Fact: Dawn is the only female CSP that is also a Microsoft Certified Trainer.
- Level: Foundation
- Format: Virtual Instructor-Led
- Contact Hours: 2
- CEUs: 0.2
Power Query is an Excel tool designed to help you import, clean, and consolidate data. With Power Query, you can process data from multiple sources and apply automatic actions to the data sets. In this session, explore how to transform data without wasting time on manual steps