This Excel Power Query training course teaches attendees how to set up Excel for automation and use Power Query and Power Pivot to create pivot tables, reports, and other visualizations. Participants learn how to use the new advanced features of Excel and extract different types of data, clean up the data, and load the clean data into Excel. This class is appropriate for Excel 2016, 2019, Online, and later.
Accelebrate offers instructor-led enterprise training for groups of 3 or more online or at your site. 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 private corporate training on-site or online, please contact us.
In addition, some courses are available as live, instructor-led training from one of our partners.
This course is best suited for intermediate to advanced Excel users who regularly receive data sets that they must clean up and create reports in Excel.
All Excel Power Query training attendees receive a course workbook.
First, you will need to import your data into Excel. The Power Query Editor can clean, transform, and load your data. The Power Query Editor is a graphical interface that makes it easy to edit your data, including:
See our guide for clear, step-by-step instructions on creating a query in Excel Power Query.
Looking for tips and tricks at a glance? Check out our Excel Power Query Cheat Sheet.
Webinar: How to use Power Query with Microsoft Excel and Power BI
Get a thorough overview of Power Query and learn how to use Power Query within Excel and Power BI Desktop to save you time and money.
Webinar: Introduction to Excel Power Query
Get a thorough overview of Power Query and watch a walkthrough of how to use Power Query within Excel.
Our live, instructor-led lectures are far more effective than pre-recorded classes
If your team is not 100% satisfied with your training, we do what's necessary to make it right
Whether you are at home or in the office, we make learning interactive and engaging
We accept check, ACH/EFT, major credit cards, and most purchase orders
New York City
Salt Lake City