Excel Pivot Table

EXERCISE FILES Preview 00:16

Subtotals Preview 07:10

This First lecture sets the stage for understanding Pivot Tables by first explaining how to create automatic Subtotals.  In this lecture you will learn how to:

• Analyze large data sets by the different types of field data
• Quickly create subtotals
• Collapse lists for a given type of groupable data

Exercise: Subtotals Preview 2 pages

Answer: Subtotals Preview 04:21

Pivot Table Concept Preview 03:59

This Lecture explains the fundamental concepts behind what a Pivot Table is and why it is useful. At the end of this lecture you will understand what a pivot table is doing and how it acts as a "Super Subtotal

Creating Your First Pivot Table Preview 04:48

In this lesson you will create your first pivot table.  Learn how to:

• Insert a pivot table to your workbook
• Work with the Field List
• Modify your Pivot Table
• Remove fields

Exercise: Create a Pivot Table Preview 2 pages

Answer: Create a Pivot Table Preview 01:02

Check your knowledge

Changing The Values Field Settings Preview 03:38

Now that you have created a Pivot Table, we want to learn how to control how values are displayed in that table.  In this lesson, you will learn how to:

• Change the Pivot Table function from the default Sum to other functions
• Change the Way values are displayed to % of ...

Exercise: Changing the Values Field Settings Preview 2 pages

Answer: Changing Value Field Settings Preview 03:23

Drill To Feature Preview 01:49

In this lesson, we uncover a nifty feature of Pivot Tables, the Drill To feature which allows you to easily display the original records that made up a specific value in the pivot table.

Answer: Drill-To Feature Preview 01:30

Formatting And Pivot Table Design Preview 03:04

This lesson explores how to format your Pivot Table so it looks the way you want, and so you can share it with other people in a professional format.  You will learn how to:

• Apply a Style to your Pivot Table
• Change the Number Format of your values

Exercise: Formatting and Pivot Table Design Preview 1 page

Answer: Formatting and Pivot Table Design Preview 02:39

Adding And Manipulating Multiple Fields Preview 07:03

In this lesson, we raise the stakes and begin to explore the true power of Pivot Tables by adding more than one field to the row and column areas.  This will allow you to get even more specific on the type of trends you are able to extract from your data.  You will learn how to:

• Add multiple fields to the Row and Column labels
• Re-organize the layout of the fields
• Manage multiple fields in the Pivot Table

Exercise: Adding and Manipulating Multiple Fields Preview 1 page

Answer: Adding and Manipulating Multiple Fields Preview 02:07

Filtering And Slicing Pivot Data Preview 07:50

When dealing with large data sets, it's often important to be able to filter ou the extraneous data that is cluttering the answers you're looking for.  In this lesson, you learn how to do that from within the Pivot Table, and with a new filtering tool to Office 2010, the Slicer.

• Filter the row and column labels to hide certain values
• Create a slicer to filter the entire table without showing values
• Use the slicer tool to quickly manipulate your data

Exercise: Filtering and Slicing Pivot Data Preview 2 pages

Answer: Filtering & Slicing Pivot Data Preview 02:29

Creating Pivot Table Dashboards Preview 04:42

This lesson explores how to create a dashboard, or rollup of lots of different aspects of your dataset onto one sheet with multiple Pivot Tables.  This is especially useful when the data is changing regularly or you want to look at different trends in your data at the same time.

• Add multiple Pivot Tables to the same sheet
• Manage multiple Pivot Tables
• Connect one Slicer to multiple Pivot Tables

Exercise: Creating Pivot Dashboards Preview 1 page

Answer: Creating Pivot Dashboards Preview 02:03

Pivot Charts Preview 07:33

By graphically representing data, you can more easily identify trends or key performance indicators in your data, and make it easier to explain your findings to others.  In this lesson, we see how to create a Pivot Chart that reflects the Pivot Table, and how to manipulate that chart

• Create a Pivot Chart
• Format a Pivot Chart
• Add additional elements to a Pivot Chart

Exercise: Pivot Charts Preview 1 page

Answer: Pivot Charts Preview 01:07

Putting It All Together Preview 11:50

In this final lesson, we explore more real world examples of how Pivot Tables can answer important business questions using the tools we've discussed. 

Answer: Putting It All Together Preview 05:11