Learn Excel Power Query for Beginners

Name: Learn Excel Power Query for Beginners
Rating: 4.4 (12 reviews)

Master Excel Power Query for Data Analytics and Other Fields

Created byKhosru Siddique

Last updated 4/2025

English

English [Auto],

What you'll learn

Step by step tutorial about Power Query with proper demonstration
Each video is followed by an assignment for your practice
Loading and Transforming Data into Power Query
Advanced features like Merge and Append Queries
Row and Column Manipulation
Extracting necessary data from a given dataset
Number Formatting and many more

Course content

4 sections • 17 lectures • 53m total length

Introduction0:49
Meet your instructor Zafer and begin the Excel Power Query for Beginners course, featuring video lessons, post-lecture assignments, and a wide range of topics to build practical skills.
How to Learn Anything1:12
Identify two daily learning approaches. Six hours a day risks burnout and instability, while two hours a day promote energy, consistency, and better learning outcomes.
Power Query Overview4:14
Apply Power Query Editor to import, clean, and reshape data from multiple sources in Excel and Power BI, handle large datasets efficiently, and prepare queries for analysis.
Importing Data4:19
Learn how to load Power Query and import data by converting a range into a table, then import from Excel, PDF, XML, and JSON using the Power Query Editor.

Merge Columns1:11
Merge two columns in Power Query Editor by selecting both columns, using the transform tab to apply a space separator, and renaming the result to full name.
Split Columns1:44
Split a column in Power Query Editor by delimiter to separate first and last names using the space delimiter, then rename columns to first name and last name.
Merge Queries4:19
Learn how to merge two queries in Power Query Editor by matching a common column, then expand and tidy the results, or create a new merged table.
Append Queries2:29
Learn how to append queries in Power Query Editor by combining three tables into one, yielding a 60-row result, either by appending to table one or creating a new table.

Add Column3:22
Learn to add a new column in Power Query using the conditional column feature, with examples like 2024 evaluation and 2021 evaluation to categorize data as satisfactory or not satisfactory.
Find and Replace2:25
Learn to replace values in Power Query Editor, converting M to male and F to female, and fix single-cell typos to standardize gender data.
Row and Column Manipulation4:19
Explore row and column manipulation in Excel Power Query, including selecting specific columns, removing others, keeping top or bottom rows, removing duplicates, blanks, or errors, and counting rows.

Extraction7:33
Learn to extract data in Power Code Editor using delimiter-based methods, including removing serials, trimming spaces, measuring length, and extracting substrings by range, with before/after and between delimiter options.
Basic Math Operations3:50
Learn basic mathematical operations in Power Query, including max, min, and average; add, multiply, and divide numbers, and apply percentage, square root, cube, and base ten logarithm.
Number Format3:58
Explore basic mathematical operations in Excel Power Query, including max, average, add 100, divide by 30, subtract 40, percent, and square, cube, and square root with standard and scientific options.
Transpose2:43
Master transpose in Power Query Editor to switch rows and columns for easier analysis of yearly sales data; use the Transform tab, then apply first row as headers.
Format3:37
Learn to use the format option in Power Query to standardize text by capitalizing each word, converting to lowercase or uppercase, trimming spaces, and adding prefixes or suffixes.
What's Next?1:42
Plan your next steps after mastering Excel Power Query: build with Power BI, MySQL, Python, and GitHub while studying statistics and probability for informed decisions.

Requirements

Excel 2016 or later versions.

Description

Are you tired of spending hours cleaning, transforming, and preparing data in Excel? Power Query is your ultimate tool for automating these tasks efficiently. Whether you're an analyst, accountant, business professional, or data enthusiast, mastering Power Query will save you time and enhance your data handling skills. After finishing this course, you will be able to handle data effectively and continue your journey towards data analytics field.

You'll Learn:

Merge & Split Columns – Combine and separate data efficiently Merge & Append Queries – Connect multiple datasets seamlessly
Add Conditional Columns – Apply logic-based transformations
Basic Mathematical Operations – Perform calculations directly in Power Query
Extraction, Find & Replace – Clean your data with precision
Number Formatting & Data Import – Handle various data types effortlessly
Row & Column Manipulation – Restructure data for better analysis
Transpose Data – Switch between row and column formats

Why Take This Course?

Beginner-friendly with step-by-step guidance
Hands-on examples for real-world applications
Lifetime access and downloadable resources
No prior coding experience needed

By the end of this course, you'll have the confidence to automate data preparation, streamline workflows, and improve your data analytics skills using Power Query in Excel.

Enroll now and transform the way you handle data! This course will support you throughout your learning journey.

Minimum Requirement: You need to have Microsoft Excel 2016 or later version.

Who this course is for:

This course will be helpful for those who want to work in the data industry.

Learn Excel Power Query for Beginners

What you'll learn

Explore related topics

Course content

Introduction4 lectures • 11min

Merge and Append4 lectures • 10min

Rows and Columns3 lectures • 10min

Misc.6 lectures • 23min

Requirements

Description

Who this course is for: