Excel 2016 for Mac 3: Pivot Tables Intro & Masterclass




Skill Level


course Duration



Eng (Auto)


Share This Class:


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:

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 our first PivotTable and PivotChart
  • Expanding our PivotTable
  • Going deeper in our PivotTable
  • Modify field selections
  • PivotTable Options
  • Slicers
  • Dates
  • Formatting
  • Advanced calculations
  • PivotCharts

What people are saying

Are You Ready To Start?

More Courses

You might also be interested in these courses

Database Fundamentals in 8 hours

Learning Database Fundamentals with Microsoft SQL Server

Database Fundamentals in 8 hours

View Course

Microsoft SQL Server Reporting Services

Learn to create reports in SSRS

SQL Server Reporting Services

Learn how to create reports in SSRS
View Course