O'Reilly logo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Microsoft Excel - Pivot Tables In-Depth

Video Description

In this Microsoft Excel – Pivot Tables training course, expert author Erin Olsen teaches you everything you need to know about pivot tables, one of the most powerful features in Excel. This course is designed for users that already have a basic understanding of Excel.
You will start out by learning the basics of pivot tables, such as how to prepare your data, creating manual pivot tables, and using pivot table tools. You will then learn how to manage pivot table data, including understanding and working with the pivot cache, working with the data source, and pivoting data in a pivot table. Erin will show you how to properly format pivot tables, teaching you how to apply basic formatting, rename pivot table fields, and format numbers. Finally, this video tutorial will cover topics such as how to sort and filter pivot tables, manipulate calculations, and visualize table data with charts.
Once you have completed this video based training course, you will be comfortable with creating pivot tables using a variety of different methods and manipulating their structure and functionality. Working files are included, allowing you to follow along with the author throughout the lessons.

Table of Contents

  1. Preparing For Pivot Tables
    1. Series Introduction 00:03:52
    2. What You Will Learn 00:03:29
    3. About The Author 00:04:21
    4. How To Access Your Working Files 00:01:15
    5. Getting Started 00:03:10
  2. Getting Started With Pivot Tables
    1. Getting Started 00:04:14
    2. Why Use Pivot Tables 00:06:12
    3. Identifying Parts 00:04:23
    4. Preparing Data 00:03:45
    5. What Has Changed With Pivot Tables 00:06:58
    6. Creating Pivot Tables - The Quick Analysis Tool 00:04:52
    7. Using Recommended Pivot Tables 00:03:28
    8. Creating Pivot Tables Manually 00:10:29
    9. Reviewing Summary Calculation Details 00:06:21
    10. Using General Pivot Table Tools 00:06:41
  3. Managing Pivot Table Data
    1. Managing Data 00:02:59
    2. Working With The Data Source 00:06:25
    3. Controlling Pivot Table Refresh 00:07:57
    4. Understanding The Pivot Cache 00:04:59
    5. Working With The Pivot Cache 00:07:35
    6. Pivoting Data In A Pivot Table 00:09:48
  4. Formatting Pivot Tables
    1. Formatting 00:04:27
    2. Applying Basic Formatting 00:04:07
    3. Modifying Pivot Table Design Using Layout Options 00:07:14
    4. Renaming Pivot Table Fields 00:04:10
    5. Repeating Row Labels In Pivot Tables 00:02:43
    6. Formatting Numbers In Pivot Tables 00:06:53
  5. Sorting And Filtering Pivot Tables
    1. Sorting And Filtering - Part 1 00:07:23
    2. Sorting And Filtering - Part 2 00:07:41
    3. How To Sort Pivot Tables 00:06:57
    4. How To Filter Pivot Tables 00:10:43
    5. Using Data Slicers To Filter Pivot Tables 00:07:45
    6. Applying Timelines To Filter By Date 00:05:42
    7. Grouping Data 00:04:55
    8. Grouping By Date 00:06:57
  6. Manipulating Pivot Table Calculations
    1. Manipulating Calculations 00:09:45
    2. Changing Summary Calculations 00:07:03
    3. Transforming Calculations With Show As 00:07:58
    4. Creating Calculated Fields And Items 00:06:58
  7. Visualizing Data With Pivot Charts
    1. Visualizing Table Data With Charts 00:03:14
    2. Creating Charts 00:03:54
    3. Manipulating Charts 00:07:34
  8. Course Closing
    1. What You Now Know 00:06:39