Excel Power Query Training Overview
Learn how to use Power Query within Excel in 1 day! This Excel Power Query training course teaches attendees how to extract different types of data, clean up the data in various ways, and load the cleaned-up data into Excel. Participants also learn how to work with Power Query data in Excel.
Location and Pricing
This course is taught as a private, live online class for teams of 3 or more. All our courses are hands-on, instructor-led, and tailored to fit your group’s goals and needs. Most Accelebrate classes can be flexibly scheduled for your group, including delivery in half-day segments across a week or set of weeks. To receive a customized proposal and price quote for online corporate training, please contact us.
In addition, some courses are available as live, instructor-led training from one of our partners.
Objectives
- Master the basics of Power Query
- Extract and transform data from a variety of sources
- Work with Power Query data to clean, shape, and analyze data
- Edit and refresh queries to ensure that your data is always up-to-date
- Use Power Query data to create pivot tables, reports, and other visualizations
Prerequisites
This course is best suited for intermediate to advanced Excel users who regularly receive data sets that they must clean up to create reports in Excel.
Outline
Expand All | Collapse All
Introduction to Power Query
- Extracting and Transforming Data
- Working with Power Query Data
Editing & Refreshing Queries
- Editing Queries
- Refreshing the Data
Appending & Merging Data
- Appending Files
- Hiding Queries
- Combining Data from Folder
- Merging Files
Creating Formulas in Power Query
- Using Custom Column Button
- Using Standard Functions
- Renaming Steps
- Editing Formulas
Using Power Query Data
- Creating Pivot Tables
- Sharing Files with Queries
Conclusion
Training Materials
All Excel Power Query training attendees receive a course workbook.
Software Requirements
- Excel installed from Microsoft Office Professional Plus or Microsoft 365
- Related lab files that Accelebrate will provide
