Excel 2016 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

( 12 Reviews )

Created by: Phillip Burton

Produced in 2021

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.

Quality Score

Content Quality

Video Quality

Qualified Instructor

Course Pace

Course Depth & Coverage

Overall Score : 94 / 100

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.

Time: 5.5h

Instructor Details

Phillip Burton

4.7 Rating
12 Reviews

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.

70-461, 761: Querying Microsoft SQL Server with Transact-SQL

70-461, 761: Querying Microsoft SQL Server with Transact-SQL (2021)
4.6 (360 Reviews)

- Provider: Udemy
- Time: 29.5h

$11.99

SQL Server Integration Services (SSIS) - An Introduction

SQL Server Integration Services (SSIS) - An Introduction (2021)
4.6 (355 Reviews)

- Provider: Udemy
- Time: 4h

$11.99

70-462: SQL Server Database Administration (DBA)

70-462: SQL Server Database Administration (DBA) (2021)
4.5 (350 Reviews)

- Provider: Udemy
- Time: 9.5h

$11.99

Microsoft SQL Server Reporting Services (SSRS)

Microsoft SQL Server Reporting Services (SSRS) (2021)
4.2 (338 Reviews)

- Provider: Udemy
- Time: 6h

$11.99

70-778, DA-100: Analyzing and Visualizing Data with Power BI

70-778, DA-100: Analyzing and Visualizing Data with Power BI (2021)
4.5 (224 Reviews)

- Provider: Udemy
- Time: 24h

$11.99

SQL Server SSAS (Multidimensional MDX) - an Introduction

SQL Server SSAS (Multidimensional MDX) - an Introduction (2021)
4.5 (207 Reviews)

- Provider: Udemy
- Time: 8h

$11.99

All courses by Phillip Burton

More excel courses

Excel Skills for Business: Essentials (2017)
5.0 (432 Reviews)

- Provider: Coursera
- Time: 4h

Free

Excel Skills for Business: Intermediate I
4.9 (463 Reviews)

- Provider: Coursera
- Time: 22h

Free

Excel Dynamic Arrays - Beginner to Expert (Microsoft 365)

Excel Dynamic Arrays - Beginner to Expert (Microsoft 365) (2021)
4.9 (216 Reviews)

- Provider: Udemy
- Time: 7h

$11.99

Visually Stunning Microsoft Excel Dynamic Dashboard Course

Visually Stunning Microsoft Excel Dynamic Dashboard Course (2021)
4.9 (193 Reviews)

- Provider: Udemy
- Time: 7h

$11.99

Excel with Top Microsoft Excel Hacks (2016)
4.9 (95 Reviews)

- Provider: Udemy
- Time: 2h

$11.99

Microsoft Excel Complete Excel Guide (Excel 2007 2021)

Microsoft Excel Complete Excel Guide (Excel 2007 2021) (2021)
4.9 (62 Reviews)

- Provider: Udemy
- Time: 21h

$11.99

All excel courses

Reviews

4.7

12 total reviews

5 star 4 star 3 star 2 star 1 star

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.