Skip to content
UdemyExcelPaid courseAll LevelsCertificate

Excel in Microsoft Excel 3: Pivot Tables Intro & Masterclass (Udemy.com)

Create data analysis in Excel using Pivot Tables with just a few clicks, together with summary Pivot Charts. Exam 70-779

Created by: Phillip Burton

Last updated December 2024

icon
What you will learn

  • Create Pivot Tables with a just a few clicks, simply and quickly.
  • Maintain and expand Pivot Tables.
  • Update data sources, and maintain formatting during refreshes.
  • Create Pivot Charts in a few simple clicks.
  • Know and use about the more advanced features, and create advanced Pivot Tables.
  • Find out how much powerful it is, and how quickly it can improve your data analysis.

icon
Course Description

Review:

"The knowledge of the teacher is impressive, and he knows how to teach. The speed of the course is just right. And going thru the exercises after each one is great. I only have one word for the teacher and the way he's presenting the course WOW!!!" -- Daniel Sandberg

This course covers one of the most useful, but scariest-sounding, functions in Microsoft Excel; PIVOT TABLES.

Please note: This course is not affiliated with, endorsed by, or sponsored by Microsoft.


It sounds difficult, but in fact can be done in just a few clicks. We'll do our first one in a couple of minutes - that's all it takes. We'll also add a chart as well in that time.

After only these first few minutes, you will be streets ahead of anyone who doesn't know anything about Pivot Tables - it is really that important.

After this introduction, we'll go into some detail into how to set up your Pivot Table - the initial data, and the various options that are available to you. We will go into advanced options that most people don't even know about, but which are very useful.

By the end, you will be an Expert user of Pivot Tables, able to create reliable analyses which are able to be drilled-down quickly, and you'll be able to help others with their data analysis.

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

Phillip Burton

Hi. I'm Phillip, and I'm proud to Teach with Udemy as a Udemy Instructor Partner. I have been teaching on Udemy since 2015, and I have over 1,000,000 students and more than 60 video courses, including over a dozen Bestseller courses.

My courses include Microsoft Power BI and Fabric, Tableau, SQL Server, Power Platform (Power Apps, Power Automate, etc.), Azure, Microsoft Office, and more. The majority of my courses align with the requirements for official certifications from Microsoft, Oracle, and Tableau - so with a bit of practice, you could enter the exam or assessment and put it on your CV or resume.

I have been a Computing Consultant providing expert services in the development of computer systems and data analysis. I am one of 9 award winning Experts for Experts Exchange's 11th Annual Expert Awards. My interests are working with data, including Microsoft Power BI, Excel, Access, SQL Server, and the Power Platform.

icon
More courses by Phillip Burton

$18.99

$22.99

$22.99

$99.99

$13.99

Free

icon
More Excel courses

$39.99

Free

$99.99

Free

$15.99

$119.99

icon
Reviews

4.5

387 ratings on Udemy

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

By Terry Dale on 2/24/2026

The content appears to be 10 years or more old. How useful will it all be?

By Anonymized User on 12/10/2025

Awesome class of study! This was a great match for me. I knew how to move around in excel and work with pivot tables, but this particular class taught me some more in depths education around excel. Will review this course again. The professor was great! Very easy to follow and understand his teaching. Way to go!

By Kathleen Donovan on 4/11/2023

I like that he included a pivot table worksheet to practice with while he is demonstrating. I was following him to see if I would get the same results. So far, pivot tables are easy.

By Christopher James Brant on 4/21/2022

Very insightful and education course on pivot tables. I enjoyed seeing how dynamic and creative one can be with pivot tables and how easy it is to summarize data and activate a timeline to summarize data within a prescribed window of time.

By Charles Berteau on 1/17/2021

This is my second course with this instructor, and I'm pleased again at the structure and information. I find the instructor to have a clear and engaging voice and style, and a good sense of humor. I find he occasionally goes down ratholes - for example on how to avoid specific things that irritate him, but may not irritate the student - but this is a minor quibble. Overall the course is excellent value for cost.

By Santosh Kiran Keerthi on 4/19/2020

The course is excellent. I would recommend this to anyone who wants to learn and master pivot tables and graphs.

By Gwen Sauvage on 11/27/2019

I really like the way the instructor dives into the details and really tells us exactly what every little button or feature does. It is a really in-depth learning and that works very well for me!

By Nancy Jo Melucci on 5/28/2018

I passed the Expert exam. Mr. Burton's courses were very helpful in my achieving that goal. I hope he will publish more Excel Courses about data analysis related functions. Excel is deep.

By Daniel Sandberg on 4/9/2017

The knowledge of the teacher is impressive, and he knows how to teach. The speed of the course is just right. And going thru the exercises after each one is great. I only have one word for the teacher and the way he's presenting the course WOW!!!

By Gillian on 3/15/2017

Whilst I have previously created them, I didn't know that there was such depth to Pivot Tables. The curriculum was very comprehensive, and I liked doing the Practice Tests - I have learned a lot from it.

Showing all 10 reviews on CourseDuck

Read all 387 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 : 90 / 100