Power Query Bootcamp Online with Expert Support

This course includes

6 hours of project-based training from experts
Learn from a Microsoft Certified Trainer
Retake for free within 1 year
Verified digital certificate of completion

This course is self-paced. For live online or in-person instruction, take the Power Query Bootcamp.

This course teaches students how to prepare and manage data using Power Query through a structured, step-by-step approach. Participants will learn to apply data transformations, reorganize datasets with pivoting and reshaping tools, and combine information from multiple files and tables.

The course also emphasizes building summarized views with grouping and conditional logic, creating new columns from examples, and maintaining organized queries through duplication, applied steps, dependencies, and data refresh processes.

This course has a prerequisite

Participants should have knowledge equivalent to our Excel Bootcamp.

Tuition

Full Tuition

$299
Due before the class starts

This course includes

6 hours of project-based training from experts
Learn from a Microsoft Certified Trainer
Retake for free within 1 year
Verified digital certificate of completion

Learning Experience Highlights

Learn from world-class creators

Classes taught by leading photographers, designers, and artists who share real workflows and insights

Several students, sitting at computers, looking at the front of the classroom

Watch anywhere, on your schedule

Stream on-demand video lessons at your own pace. Rewatch anytime, on any device, whenever inspiration strikes

Shabang! I'm really enjoying the class. This course feels like a workshop with step by step demo on every piece of theory and with tons of details."
— Gerald B.

Comprehensive course materials

Downloadable guides & practice files crafted to support your creative journey

Join a global creative community

Connect with thousands of fellow learners and get inspired by creators from around the world

100% Online. Start Anytime

24/7 access to our premium course videos and projects.
Industry experts are assigned as your course instructor. Message your instructor with any questions.
Participate in CreativeLive online discussion forums — share ideas and receive additional support.
Hands-on quizzes and mini projects to test and reinforce concepts.

Earn a Certificate of Completion

Upon completion of this course, you’ll receive an official certificate testifying to your mastery of the curriculum. We’ll send you a link where you can download your certificate, share it online with your friends, post it to your professional network on LinkedIn, and view all your earned certificates. Congratulations on your achievement!

Shareable on

Sample credential for completion of Power Query Bootcamp (Self-Paced)

Power Query Bootcamp (Self-Paced) Curriculum

What You'll Learn at a Glance

Navigate the Power Query interface, understand the data analysis process, and work with Power Query options, applied steps, and refresh behavior.
Clean and transform data by filtering rows, removing and reordering columns, changing data types, splitting and merging columns, and applying text cleanup techniques.
Create structured transformations using grouping, conditional columns, date and duration calculations, and columns generated from examples.
Reshape datasets using Pivot, Unpivot, Transpose, and split-to-rows techniques to support analysis and reporting.
Combine data from multiple sources by appending tables, worksheets, and CSV files, and merging data using inner and anti joins.
Organize and manage queries by duplicating and referencing queries, handling errors and values, removing duplicates and blank rows, and working with query dependencies.

Course Syllabus

Download Syllabus PDF

Getting Started with Power Query

The Data Analysis Process
What Is Power Query?
The Power Query Interface
Power Query Options & Settings
One – Extracting
Two – Transforming
Three – Loading
Four – Refreshing
Benefits of Power Query

Transpose, Pivot, and Un-Pivot

Transformations Overview
Introduction to Transforming Data
Removing Rows by Filtering Data
Removing, Renaming & Reordering Columns
Loading Your Transformations
Applied Steps
Saving Transformations
Data Type Transformations

Combining Data from Two or More Data Sets

Relationships
Appending Two Tables
Appending Multiple Tables
Query Organization
Appending Multiple CSVs
Appending Data with Different Column Headers
Merging Tables
Merging via Composite Columns
Inner Joins
Right & Left Anti Joins
Appending Multiple Worksheets

Duplicating and Parameters

Duplicate & Reference Queries
Remove Duplicates
Deleting Queries
Replacing Errors & Values
Removing Top/Bottom Rows
Using First Row as Headers
Removing Blank Rows

Steps, Groups and Dependencies

Transformation Steps Level 1
Splitting Columns
Merging Columns
Trim, Clean, and Changing Case
Transformation Steps Level 2
Filling Down
Sorting
Extracting
Math Calculations
Unpivot
Pivot
Transpose
Split Columns into Rows
Group By
Grouping by Dates/Times
Date/Duration Calculations
Conditional Columns
Columns from Examples
Extracting from Data Sources
Getting Data from Excel
Getting Data from CSV
Getting Data from PDF
Getting Data from Websites

Installments
	10% non-refundable deposit
$299.00	Total You Pay