Skip to content
Write a review
UdemyExcelPaid courseAll LevelsCertificate

Excel for Mac 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

4.8
179 reviews

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.

How it compares

Against the other 355 rated Udemy courses in Excel on CourseDuck:

  • Rating4.8 out of 5higher than 96% of them
  • Reviews179#307 of 356 by number of reviews
  • Length5.8 hourslonger than 51% of them
  • Last updatedDecember 2024more recently than 60% of them

icon
Course Description

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

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 thesefirst 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 Expertuser of Pivot Tables, able to create reliable analyses which are able to be drilled-down quickly,and you'll beable to help others with their data analysis.

It will assist withthe Visualize Data sectionof the Microsoftexam 70-779 "Analysing and Visualizing Data with Microsoft Excel".
Who this course is for:
This is for you if you have ever heard of the "Pivot Table", but didn't know what it is or how to use it.
This is also for you if you use PivotTables, and want to go deeper. Much deeper. :-)We'll also go into the more advanced functions, and create charts as well, quickly and easily.
Read More All Levels All Levels product length iconTime: 5.8h

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

Phillip Burton

Phillip is a Computing Consultant providing expert services in the development of computer systems and data analysis. He is a Microsoft Certified Technology Specialist. He has also been certified as a Microsoft Certified Solutions Expert for Business Intelligence, Microsoft Office 2010 Master, and as a Microsoft Project 2013 Specialist.
He enjoys investigating data, which allows him to maintain up to date and pro-active systems to help control and monitor day-to-day activities. He has also developed expertise and programmes to catalogue and process and control electronic data, large quantities of paper or electronic data for structured analysis and investigation.
He is one of 9 award winning Experts for Experts Exchange's 11th Annual Expert Awards and was one of Expert Exchange's top 10 experts for the first quarter of year 2015.
His interests are working with data, including Microsoft Excel, Access and SQL Server.

Read More

icon
More courses by Phillip Burton

$18.99

Original price $129.9985% off

$22.99

Original price $159.9986% off

$22.99

Original price $159.9986% off

$14.99

Original price $99.9985% off

$13.99

Original price $99.9986% off

Free

All courses by Phillip Burton

icon
More Excel courses

$11.99

Original price $39.9970% off

Free

$14.99

Original price $99.9985% off

Free

$15.99

Original price $109.9985% off

$16.99

Original price $119.9986% off
All Excel courses

icon
Reviews

4.8

179 ratings on Udemy

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

Write a review

By Biju A K on 10/21/2020

Good

By Ario Brunet on 5/24/2020

Great course, I'm sure I learned pretty much everything there is to learn about Pivot Charts, and everything that goes with them. Plenty of useful general Excel tips as well to help the whole experience. Phillip is a great teacher, and quickly answers questions, which was much appreciated. I would strongly recommend this course!!

By Sathyanarayanan. R on 5/14/2020

Yes. A very good course !

By Michelle Dye on 2/16/2020

Extremely useful course! The explanations are very clear and the course has a good pace. I would definitely recommend this course.

By Kellie Clenton on 8/10/2019

I was despairing about making the switch to Mac and having to relearn all the functions - even something as small as having the group labels is going to make this so much easier! Thank you!

By Karthikeyan on 8/9/2019

Nicely explained.

By Ken Houston on 3/14/2019

Yes, as I used this to help me with the production of a report

By Laura Wilson on 11/14/2018

Great course to guide you really from the basics to advanced. Exactly what I was looking for. Thank you.

By Rachel Heidrick on 9/5/2018

I already learned how to do something that is useful to my job.

By Henrik Alksnis on 7/25/2018

Good explanation of pivot tables.

By Thokozani Lucky Sithole on 7/14/2018

I think this course has a lot more information above my knowledge with pivot, but I am trying to understand

By Jocelyne Meunier on 6/27/2017

Very clear and helpful. Explains the reasoning behind the different actions. Pace is slow enough so that I had time to assimilate what Phillip was doing/explaining yet fast enough to keep me engaged all the way through.

Showing all 12 reviews on CourseDuck

Read all 179 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 : 96 / 100

Excel for Mac 3: Pivot Tables Intro & Masterclass
$11.99Original price $64.9982% off
Visit course on Udemy Write a review
  • Video Duration: icon 5.8h
  • Price: $11.99
  • Provider: icon Udemy
  • Updated: icon December 2024
  • Level: All Levels All Levels
  • Language: icon English
  • Certificate: icon Yes
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