Skip to content
UdemyExcelPaid courseAll LevelsCertificate

Microsoft Excel - Data Analytics Power Query and PivotTables (Udemy.com)

Clean, Transform and Summarize Microsoft Excel Data Quickly with Excel's Power Query and PivotTable Tools

Created by: Kyle Pew

Last updated April 2020

icon
What you will learn

  • Create Connections and Discover External Data Sources
  • Clean, Transform and Prepare Data Sets for Reporting within Excel
  • Transform Raw Data with Power Query Calculations
  • Create Consistentcy in Data with Power Querys Powerful Toolset
  • Streamline Data Work by Automating with Power Query Steps
  • Create Clean Data Interfaces with Power Query Parameters and Excel Variables

icon
Course Description

Microsoft Excel's Power Query tool is the biggest feature Microsoft has added to Excel since PivotTables. Seriously, no joke. Read on to learn more about Excel Power Query and how you'll save loads of time as you take advantage of this powerful feature.

In Excel 2016, 2019 and Office 365, Power Query is built directly in the Excel interface through the GET AND TRANSFORM command on the Data tab. (Power Query is NOT available on the MAC release of Excel)

Power Query is available on Excel 2010 and 2013 through a free download from Microsoft as described in the course.

Lets face it, retrieving, cleaning and transforming data to report on can take hours of precious time. With Excel Power Query you can eliminate repetitive tasks freeing your time for other important tasks, like lunch and going home on time. Excel Power Query removes the hassle and complex formulas of manual tasks such as:

  • Finding the Data each time you need a report

  • Cleaning Columns of Data

    • Splitting or Joining Column Values

    • Removing unnecessary characters and extra spaces

    • Formatting data correctly

  • Filtering data needed for the report

  • Combining multiple Datasets into a master list

  • Manipulating the data layout to work with other tools, i.e. Excel PivotTables and Charts

In just 3 easy steps, you'll have a final report ready for presentation and your next raise.

  1. Get Data

  2. Transform/Clean Data

  3. Report on Data

Once you've got it all setup with Excel Power Query all you need to do is hit the Refresh button to update the report with next weeks data. Microsoft Power Query remembers all the steps you performed to get, transform and clean the data all you do is refresh and your report is updated.

Sounds all too easy, right? Enroll now and let me guide you through Excel Power Query and you'll quickly be on your way to harnessing the power of managing and reporting on data with Excel Power Query.

This Excel Power Query Course Includes:

  • 6+ hours of video content

  • Downloadable exercise files to follow along

  • Access to the instructor through the QA section


icon
Udemy Discount

The discount is applied through our link. Open the course from here and Udemy's current promotional price is applied at checkout on most courses, no code to type.

Some courses are excluded from Udemy's promotions. If the price does not drop, clear your browser cookies and use the button again.

icon
Instructor Details

Kyle Pew

Welcome! I'm Kyle Pew, a Microsoft Certified Trainer (MCT), Microsoft Office Master Instructor, and Udemy Instructor Partner, with over 20 years of experience training over 2 million students in Microsoft Office and beyond. I’m passionate about helping students of all backgrounds and skill levels succeed in using tools like Excel, Word, PowerPoint, Access, and more, as well as diving into advanced topics like VBA and SharePoint.


With a background in media arts and animation from the San Francisco Art Institute and industry experience as a game designer at Electronic Arts, I bring a unique perspective to my training. My clients have included major corporations like Chevron, Facebook, Walmart, and many more, delivering training to both large-scale audiences and individuals, adapting each lesson to address real-world applications. My courses are built around the principle that the best way to learn is by tackling real-life challenges—allowing you to build confidence and problem-solving skills.


Join me on Udemy and let’s take your skills to the next level. When I’m not teaching, I’m enjoying time with my six children or cheering on my favorite hockey team, the San Jose Sharks.

icon
More courses by Kyle Pew

$139.99

$15.99

$18.99

$14.99

$79.99

$15.99

icon
More Excel courses

$39.99

Free

$99.99

Free

$15.99

$119.99

icon
Reviews

4.7

2,667 ratings on Udemy

Select a bar to show only those reviews.Select the bar again to show every rating.

By Olga Usenko on 7/22/2026

I liked the lecturer and the approach very much. A small minus for me was the form of the excercises: these workbooks did not look so great although the ideas behind the excercises were clear and well thought-through. Though I use Power Query actively, I got some more structure and a few great tips for my work. Thanks a lot!

By Massimiliano Angelo Silipigni on 6/14/2026

The teacher is top-notch! Always effective, precise, clear and professional, yet with a very friendly approach. This makes the course a real pleasure to follow and absolutely worthwhile. Thank you. It’s a great inspiration to put into practice straight away.

By Lattanatay Philavanh on 5/29/2026

Great course with clear explanations and a comfortable pace. Kyle’s teaching style is easy to follow, and the exercises were practical and well‑structured. I’ll be revisiting the steps again to consolidate the learning. Highly recommended.

By Samantha Weitz on 3/19/2026

Great course, learnt how to use a very powerful tool, which I can use and automate processes saving time every day. Great instructor, explains very clearly and intuitively with the right level of enthusiasm!

By Gaurav Jagetiya on 1/19/2026

As I have previously power query Knowledge, so it was simple for me. but instructor simple and lucid instructions were good.

By Tatiana Buzuleac on 1/18/2026

Fantastic course! Power Query finally makes sense to me thanks to the clear explanations and hands-on examples. The lessons are well paced, practical, and easy to follow. I feel much more confident using Power Query in my daily work now. Definitely worth taking!

By Mark Kevin Vergara on 11/15/2025

Kyle Pew has been an amazing teacher! He explained all the concepts in a simple and straight forward manner. if the lesson is a bit challenging, he takes time to explain it slowly and gives examples/applications to better understand it.

By Taja Perez on 11/9/2025

I am a slow learner and it takes me a while to process new information. Kyle does an excellent job of breaking down the basics into comprehensive steps. Once daunting tasks now seem achievable.

By Aniko Kara on 11/5/2025

Very useful course — easy to follow and well structured, with detailed explanations throughout each section. I loved the plenty of practice opportunities. I gained a lot of valuable knowledge from this single course. Thank you, Kyle! Highly recommended for beginners in Power Query.

By Khatia Butkhuzi on 10/28/2025

I would highly recommend this course to anyone with little or no experience in Power Query. I really like how the course is structured: first, you learn the logic behind building queries—how they are constructed, how everything connects, and why it's beneficial to work with them. Once these fundamentals are clear, the course gradually introduces more specific features and techniques.

Showing all 10 reviews on CourseDuck

Read all 2,667 reviews on Udemy

icon
Quality Score

No CourseDuck member has rated this course yet. Taken it? Give each part a thumbs up or down.

Content Quality
/
Video Quality
/
Qualified Instructor
/
Course Pace
/
Course Depth & Coverage
/

Overall Score : 94 / 100