Excel L5-Power Query Basics

Excel L5-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.

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 officeproductivitytraining@gmail.com for more information. Visit OfficeProductivityTraining.com to learn more about our company and the services we offer.