Power Query Bootcamp (Self-Paced)
IDQRB

Self-paced online training with expert support

Learn the core features of Power Query to streamline data preparation in Excel and Power BI. Through hands-on practice, you’ll clean, transform, and combine data to create analysis-ready datasets.

$299 6 clock hours Live Support Start anytime

This course includes

  • 6 hours of project-based training from experts
  • Learn from a Microsoft Certified Trainer
  • Retake for free within 1 year
  • Access to class recordings (30 days)
  • Verified digital certificate of completion
  • Learn at an accredited institution

Learn how to efficiently clean, organize, and reshape data using Power Query, a powerful feature built into Excel and Power BI. In this hands-on, self-paced course, you’ll streamline data preparation for analysis and reporting by importing datasets, setting data types, filtering unwanted information, and creating calculated columns to support clearer insights.

You’ll also work with tools such as Pivot, Unpivot, append, and merge to transform and combine data from multiple sources using common join types. The course covers ways to automate and optimize workflows by duplicating and referencing queries, using parameters, managing query dependencies, and troubleshooting with the Advanced Query Editor to support repeatable, reliable reporting.

Read more

This course has a prerequisite

Participants should have knowledge equivalent to our Excel Bootcamp.

A group of adult learners sits in a classroom, smiling and engaged in a government training session.
A government training instructor in a suit gestures while teaching in front of a whiteboard covered with notes and diagrams.
A person in professional attire holds a Graduate School USA folder, symbolizing participation in government training programs.

Related Courses: Compare to Power Query Bootcamp (Self-Paced)

These related courses share skills and topics with Power Query Bootcamp (Self-Paced). Select up to two and tap Compare selected courses to view a side-by-side comparison.

  • Power BI Bootcamp
    12 hours $599

    Learn how to use Power BI, a powerful data visualization tool, to create interactive and aesthetically pleasing charts, graphs, and maps. Learn how to connect to datasets, analyze and structure data, customize visualizations, and publish reports.

  • Power BI Bootcamp (Self-Paced)
    12 hours $599

    Learn to harness Power BI, a leading data visualization tool, to create interactive charts, graphs, and maps. Connect to datasets, structure and analyze data, customize visualizations, and publish professional reports.

  • Excel for Data Analytics Course
    18 hours $595

    Improve your data analysis skills with our Excel for Data Analytics class. Learn essential functions, formulas, and advanced techniques like Pivot Tables and VLOOKUP. Gain hands-on experience and optimize your workflow for efficient data analysis.

  • Excel for Data Analytics (Self-Paced)
    18 hours $595

    Improve your data analysis skills with our Excel for Data Analytics class. Learn essential functions, formulas, and advanced techniques like Pivot Tables and VLOOKUP. Gain hands-on experience and optimize your workflow for efficient data analysis.

Show all related courses