About this Event
Excel L6-Power Query Basics
Data transformation and cleaning can be challenging, but with our 90-minute virtual session, you can learn how to use Excel's Power Query to make it easier. Our experienced instructors will guide you through the fundamentals of transforming and cleaning imported data, equipping you with the necessary skills to simplify your workflow and save time.
Date: Wednesday, May 22
Time: 10:30 am - Noon (Central Standard Time)
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 Teams.
Become a Power Query pro! Join us to level up your Excel skills. Reserve your spot now!
Are you interested in offering this class to your organization?
Contact [email protected] for more information. Visit OfficeProductivityTraining.com to learn more about our company and the services we offer.
Event Venue
Online
USD 39.00