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
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.
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.
Instructor Details
- 4.5 Rating
387 Reviews
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.
More courses by Phillip Burton
PL-300 certification prep: Microsoft Power BI Data Analyst (2026)
4.6 (38,841 Reviews)
Provider: Udemy
Time: 30.3h
$18.99
70-461, 761: Querying Microsoft SQL Server with T-SQL course (2026)
4.6 (18,624 Reviews)
Provider: Udemy
Time: 28.7h
$22.99
Salesforce Tableau Data Analyst/Specialist Desktop Cert Prep (2026)
4.7 (15,238 Reviews)
Provider: Udemy
Time: 15.7h
$22.99
PL-900 prep: Microsoft Power Platform Fundamentals (2026)
4.7 (15,071 Reviews)
Provider: Udemy
Time: 11h
$99.99
SQL Server Integration Services (SSIS) - An Introduction (2026)
4.6 (11,116 Reviews)
Provider: Udemy
Time: 3.9h
$13.99
Microsoft Excel - Improve your skills quickly (2024)
4.6 (9,076 Reviews)
Provider: Udemy
Time: 1.6h
Free
More Excel courses
Microsoft Excel Data Analysis - Learn How The Experts Use It (2026)
5.0 (5,696 Reviews)
Provider: Udemy
Time: 3h
$39.99
Microsoft Excel: Advanced Dashboard Design (Project-Based!) (2026)
4.9 (4,868 Reviews)
Provider: Udemy
Time: 6.4h
$99.99
Master NEW Excel Functions in Office 365 & Office 2021+
4.8 (5,262 Reviews)
Provider: Udemy
Time: 7.1h
$15.99
Microsoft Excel Certification Exam Prep: MO-201 Excel Expert (2026)
4.8 (3,239 Reviews)
Provider: Udemy
Time: 8.6h
$119.99
Reviews
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.
Quality Score
No CourseDuck member has rated this course yet. Taken it? Give each part a thumbs up or down.
Overall Score : 90 / 100












