Excel 2016 for Mac 3: Pivot Tables Intro & Masterclass

Back To All Courses

86 Lessons

All

Skill Level

5:46h

course Duration

English

Audio

Eng (Auto)

Subtitles

Share This Class:

Overview

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 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.

Completing this course will help you:

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.

Who is the course 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.

Learning Path

Creating PivotTables and PivotCharts

Creating our first PivotTable and PivotChart
Expanding our PivotTable
Going deeper in our PivotTable
Modify field selections

Developing PivotTables and PivotCharts

PivotTable Options
Slicers
Dates
Formatting
Advanced calculations
PivotCharts

What people are saying

“It was great to learn about pivot tables and other aspects that affect tabular data in excel that has become so crucial for businesses nowadays!”
Paul
“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!!”
Ario
“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!”
Kellie
“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.”
Jocelyne
Previous
Next