Skip to content
Write a review
UdemyExcelPaid courseAll LevelsCertificate

Microsoft Excel Pivot Tables - Beginner to Advanced (Udemy.com)

Quickly calculate, summarize and analyze large data sets with Microsoft Excel Pivot Tables

4.7
5,032 reviews

Created by: Kyle Pew

Last updated January 2023

Our take

Based on the ratings of 5,032 students, a sample of their written reviews and the syllabus, as the course stood in January 2023. No course pays to be reviewed.

This course covers Microsoft Excel PivotTables from setup through advanced dashboard-style reporting, plus a bonus section on Power Query for pulling data from multiple sources. It runs a tight 4.5 hours across 59 lectures, taught by Kyle Pew, a Microsoft Certified Trainer who says he's worked with over two million students. It's billed as All Levels, but the syllabus and requirements make clear it's for people who already use Excel regularly and want to get serious about PivotTables, not first-time spreadsheet users.

Reviewers consistently praise Kyle's teaching style: clear, down-to-earth, and paced well enough to follow along with the provided exercise files. Several call out how logically the sections build on each other. The complaints are minor but real. One reviewer said a downloaded exercise file didn't match what was shown in a video for one section. Another noted the exercises get thinner in the second half, after Kyle assigns less hands-on practice, which that reviewer said is what really helps the material stick.

At 4.5 hours it's shorter and more focused than broader Excel bundles, which suits anyone who wants PivotTables and Power Query specifically rather than a full spreadsheet course. It was last updated in January 2023, so it's holding up but not brand new. With a 4.7 rating across more than 5,000 reviews, it's a solid, no-nonsense pick for intermediate Excel users who want to actually finish the course they start.

Best forExcel users who already know the basics and want to master PivotTables and Power Query fast.
Skip it ifComplete Excel beginners, since the course assumes basic spreadsheet skills already.

Pros

  • Kyle Pew explains concepts clearly and keeps lectures engaging, reviewers say
  • Includes a bonus section on Power Query, not just PivotTables
  • Exercise files let students practice each skill right after the lecture
  • Rated 4.7 from over 5,000 reviews, with 93% rating it 4 or 5 stars

Cons

  • Exercises thin out in the second half, per one reviewer
  • One student found a mismatch between a lecture video and its exercise file
  • Only 4.5 hours, so depth is limited compared to longer Excel bundles
Kyle is the best teacher, down to earth, funny, and with an amazing talent to explain concepts clearly.
James Hoffman, a student

Labeled All Levels but really for people already comfortable with basic Excel, not total beginners.

icon
What you will learn

  • Prepare Microsoft Excel data for PivotTable reporting
  • Connect PivotTables to various data sources
  • Create and manage PivotTable calculations
  • Format PivotTables for presentations
  • Update PivotTable source data
  • Create and manage Excel Data Models to pull in data from multiple sources
  • Create and manage data relationships
  • Create Dashboard elements in a PivotTable

Course content

10 sections · 59 lectures · 4.5 hours of video 8 assignments

  1. 1Microsoft Excel PivotTables - Beginner to Advanced Course Introduction 2 free previews3 lectures · 1 quiz · 11 min
  2. 2Introduction to Excel PivotTables 2 free previews7 lectures · 2 quizzes · 37 min
  3. 3Preparing Microsoft Excel Worksheet Data 1 free preview13 lectures · 2 quizzes · 54 min
  4. 4Microsoft Excel PivotTables Summary Values and Calculations4 lectures · 1 quiz · 24 min
  5. 5Grouping Excel PivotTable Data4 lectures · 1 quiz · 22 min
  6. 6Sorting and Filtering Excel PivotTable Data7 lectures · 1 quiz · 33 min
  7. 7Formatting Excel PivotTables4 lectures · 17 min
  8. 8Excel Pivot Charts5 lectures · 18 min
  9. 9Introduction to Microsoft Excel Power Query11 lectures · 50 min
  10. 10Congratulations1 lecture · 2 min

Who it is for

The instructor says it suits

  • This course is intended for users familiar with working in Microsoft Excel but wish to master working with Excels PivotTable feature.
  • Microsoft Excel users who want to become more efficient in summarizing and reporting on large datasets within Excel

What you need before you start

  • Familiar with working in Microsoft Excel

icon
Course Description

WHY EXCEL PIVOT TABLES

Mastering Microsoft Excel PivotTables will change the way you approach reporting. Through a few clicks of the mouse Excel PivotTables allow you to quickly and efficiently summarize large data sets.

COURSE DESIGNED TO HELP YOU SUCCEED

This Microsoft Excel PivotTables - Beginner to Advanced course will take your skills from absolute PivotTable beginner to Advanced PivotTable user. Each section of the course has been designed to focus on a specific skill set. Once that skill set is mastered, then you will move to the next section that builds upon the previous skill set. After completing the first few sections of the course you will feel like you can conquer the world with the reports you can create, but there's more.

Each section contains instructor lead lectures with step-by-step instruction and encouragement to try the various topics for yourself, using the course provided exercise files. Each section also contains mini challenges where you can practice the skill you are mastering with additional exercises and quizzes on the topics.

WHAT YOU'LL LEARN

  • Create dynamic reports that will help with making intelligent business decisions

  • Capture data from a single source or from multiple related sources

  • Apply proper list design techniques to make reporting a breeze

  • Summarize data with built in Excel functions and custom calculations

  • Format your report for clear presentation

JOIN ME

Enroll now and learn to harness the power of Microsoft Excel PivotTables.
Read More All Levels All Levels product length iconTime: 4.5h

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.

Get the Udemy discount

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.

Read More

icon
More courses by Kyle Pew

$139.99

$15.99

$18.99

$14.99

$79.99

$15.99

All courses by Kyle Pew

icon
More Excel courses

$39.99

Free

$99.99

Free

$15.99

$119.99

All Excel courses

icon
Reviews

4.7

5,032 ratings on Udemy

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

Write a review

By James Hoffman on 8/30/2026

Kyle is the best teacher, down to earth, funny, and with an amazing talent to explain concepts clearly. I can tell he's done a lot of in-person teaching to live classes because he knows what works and how to explain things in a way that holds your attention.

By Amanda Porter on 8/13/2026

In one section, the file provided did not match what was in the video. However, the instructor was excellent and I learned a lot!

By Ryan Koch on 6/30/2026

good course, but second half of the course he kind of skimped on exercises. Doing the exercises myself after the lecture is what really helps me to learn the material. Still worthwhile course.

By Dave Livesey on 6/27/2026

Good course - covered all the basics to advance forwards with

By Farinaz Ghafourinia on 5/13/2026

This looks perfect!!! Explanations are really to the point and details are explained very explicitly. I am really enjoying to listen . Perfect consistency between instructor explanation and the files that I downloaded first. I really was able go step by step with instructor.

By Ruthann Hartmann on 4/22/2026

I have taken several other courses taught by this instructor, and he consistently does an excellent job explaining the material. I have even learned concepts through his instruction that extend beyond the stated content area. He is a truly great instructor.

By Raul Araiza on 3/25/2026

Instructions are concise, clear, and easy to follow. I like that each lesson contains a specific file to quickly start from.

By Alexia Christiana Aparicio on 3/16/2026

I chose this course because Excel PivotTables is a requirement for a job im interested in. This course truly has helped me understand the topic and i am now fully confident that i am now able to tackle PivotTables at my new job. I enjoyed learning so much and can't wait to start my next course. Props to Mr. Pew!! Amazing teacher, really explained everything well and in detail so i never felt lost at any point.

By Awatif Shaikh on 2/21/2026

Very detailed guidance and the assignments are quite engaging and helps in application of our learnings. Overall well designed course for effective learnings.

By Christy Sajan on 1/26/2026

I am very glad to attend this course. Now its like a little loaded, but through practice i have the confidence i will be an expert in pivot table

Showing all 10 reviews on CourseDuck

Read all 5,032 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

Microsoft Excel Pivot Tables - Beginner to Advanced
Visit course on Udemy Write a review
  • Video Duration: icon 4.5h
  • Price: $84.99
  • Provider: icon Udemy
  • Updated: icon January 2023
  • Level: All Levels All Levels
  • Language: icon English
  • Certificate: icon Yes
  • Lectures:59 in 10 sections
  • Students:20,100
  • Subtitles:7 languages
30-day money-back guarantee on most paid courses

Udemy Coupon Price Tracker

Udemy price history

For any issues or feature requests please email CourseDuck's Co-Founder at mkuhlman12@gmail.com