Microsoft Excel - Pivot Tables

by Ken Puls

2h 54m

Auto
  • HD
  • 360p
  • 270p
1.00x
  • 0.50x
  • 0.75x
  • 1.00x
  • 1.25x
  • 1.50x
  • 1.75x
  • 2.00x
cc
Auto
  • HD
  • 360p
  • 270p
1.00x
  • 0.50x
  • 0.75x
  • 1.00x
  • 1.25x
  • 1.50x
  • 1.75x
  • 2.00x
cc
Auto
  • HD
  • 360p
  • 270p
1.00x
  • 0.50x
  • 0.75x
  • 1.00x
  • 1.25x
  • 1.50x
  • 1.75x
  • 2.00x
cc

Overview

New to Pivot Tables or want to get more out of them? This online course is designed to give you a solid understanding of Pivot Tables, taking you from novice to ninja!


Syllabus

What is a Pivot Table - and Why Do You Care?3m 59s

Pivot Tables open up your world to quickly summarize data and build solutions that others can explore.

Watch lesson

The Pivot Table Life Cycle4m 22s

Understanding how the life cycle of a Pivot Table solution is different than an ad-hoc reporting solution.

Creating Your First Pivot Table5m 24s

Creating your first Pivot Table is the first step to unlocking serious Excel power in data optimization.

Field Well Options4m 15s

Determining the Field Well options you’d like to use to view your Pivot Table data.

Source Data Best Practices5m 11s

Setting up your data sets to ensure that they will be able to be consumed by a Pivot Table.

Using Excel Ranges5m 14s

Choosing between building quick and dirty Pivot Tables or future proofing Pivot Tables for future update.

Watch lesson

Preparing Source Data5m 05s

When you need to aggregate multiple tables or create new fields in order to display properly in a Pivot Table.

Using Database Data4m 23s

Pulling database data into Excel and Pivot Tables.

Totals and Sub-Totals5m 21s

Use to turn totals and subtotals on/off where needed in your Pivot Table.

Choosing Pivot Table Layouts4m 44s

Determining the basic layout you’d like to use to display your Pivot Table data.

Grouping5m 19s

Use to group different row or column fields together for a more logical display.

Aggregation4m 47s

When you wish to show different aggregation on your Pivot Table fields than what is provided by default.

Running Totals5m 04s

When you need to display a running total on your Pivot Table.

Percent of x Calculations6m 06s

When you need to display a value as the % of another value on your Pivot Table.

Difference From Calculations4m 31s

When you need to display values that are a difference from another value in a Pivot. This is very useful for showing growth/decline from previous periods.

Percentage Difference From Calculations4m 04s

When you need to display values that are a percentage of difference from another value in a Pivot.  This is very useful for showing growth/decline from previous periods.

Top and Bottom x Items5m 11s

When you want to filter your Pivot Table to show the top/bottom x items or top/bottom x% of items in the data set.

Calculated Fields5m 23s

Understanding how to create calculated fields in a Pivot Table.

Calculated Items5m 23s

Understanding how to create calculated items in a Pivot Table.

Value Field Formats4m 24s

Various ways to display numbers in the values area of a Pivot Table.

Preserving Cell Formats on Update3m 35s

How to force a Pivot Table to preserve cell formats and column widths when it is updated.

Pivot Table Styles3m 08s

Using pre-defined styles with a Pivot Table.

Watch lesson

Custom Pivot Table Styles5m 10s

Creating your own style to use with a Pivot Table.

Conditional Formatting on Pivot Tables4m 49s

Basics of applying conditional formats to a Pivot Table.

Basic Sorting3m 18s

Basic sorting of row and column headers in a Pivot Table.

Custom Sorting5m 05s

Creating Custom Sort Orders for a Pivot Table.

Sorting Values5m 31s

Sorting the values area of a Pivot Table.

Report Filters4m 30s

Using Report Filters to narrow down results in a Pivot Table.

Built in Filter Controls5m 12s

Using row and column filters to narrow down results in a Pivot Table.

Slicers4m 54s

Slicers are user-friendly filters for Pivot Tables.

Filtering Multiple Pivot Tables 5m 16s

Filtering multiple Pivot Tables at once with Slicers.

Show Details4m 58s

Using Show Details to extract details from a summarized value.

GETPIVOTDATA5m 00s

Using the GETPIVOTDATA function to extract specific fields from a Pivot Table.

Creating Pivot Charts4m 58s

Creating Pivot Charts out of a Pivot Table.

Automating Refresh6m 06s

Automating Pivot Table refresh operations.

Pre-release Considerations5m 10s

Items to consider before releasing your file to users.


Description

Pivot Tables are a powerful tool within Excel that can be used to analyze, sort, filter and present data in an understandable way.

In 36 engaging lessons you will learn best practices for preparing source data, using database data, how to preserve formats and create custom styles, sorting and filtering techniques, and much more.

Whether you use Excel for work or study, these tutorials will start you on your journey to becoming a Pivot Tables Ninja! Learn more about how a GoSkills Excel certification can boost your career.

The course is Microsoft Excel 2010 and 2013 compliant. Video tutorials are recorded in Microsoft Excel 2013 for PC, and where the user interface is significantly different, Excel 2010 videos are provided too.

If you’d like to learn more about Excel try our Basic, Advanced or Basic and Advanced Excel courses.

Once enrolled, our friendly support team and tutors are here to help with any course related inquiries.


Accreditations and approvals

CPD - The CPD Certification Service.

Reviews70

Love this course. It lays down all the basics I need to move on with this application. You can feel the dedication of instructor, Ken, through the way he taught which always never forget to mention about little details that matter. The quiz on each topic does really test understanding of each topic. I hope Ken will come up with more topics to cover on the advance level.

— Patinya Pinyoboon

I found the Pivot Tables - From Novice to Ninja online course very helpful. I received a refresher on some aspects that I already knew and learned some great new things to take my data reporting to new depths. I really liked the fact that everything was online and I could go at my own pace. The instructor is informative and pleasant to listen to, while the lessons are broken down into quick lesson segments.

— Lisa Hoffer

I really enjoyed this class - love the instructor he is very good.

— Deborah Davey

View all reviews