Practical Excel 2016 Pivot Tables And Pivot Charts

  1. Home
  2. Pivot-tables
  3. Practical Excel 2016 Pivot Tables And Pivot Charts

Tags: Pivot Tables

Become indispensable at work! Become a power user and earn a huge raise by working Pivot magic in Excel.

Last updated 2022-01-10 | 3.9

- An understanding of how pivot tables allow you to break down numerical data by categories
- something other Excel tools can do
- but not nearly so quickly or easily
- How to build pivot tables by clicking and dragging
- An understanding of the advantages of using Excel tables as a basis for pivot tables

What you'll learn

An understanding of how pivot tables allow you to break down numerical data by categories
something other Excel tools can do
but not nearly so quickly or easily
How to build pivot tables by clicking and dragging
An understanding of the advantages of using Excel tables as a basis for pivot tables
How to base pivot tables from an external source or an Excel data model
How to build pivot charts
which are automatically synchronized with the corresponding pivot tables
How to sort and filter in pivot tables
Methods for grouping categories
especially dates
with many categories in pivot tables
An understanding of the role of pivot caches for extremely fast pivot table calculation
How conditional formatting in pivot tables provides even more insightful reports
How to create calculated items and calculated fields for pivot tables
How to use pivot tables for finding unique values
creating histograms
and classification (learning which variables are related to a Yes/No variable)

* Requirements

* Microsoft Office 2016

Description

  • An understanding of how pivot tables allow you to break down numerical data by categories, something other Excel tools can do, but not nearly so quickly or easily
  • How to build pivot tables by clicking and dragging
  • An understanding of the advantages of using Excel tables as a basis for pivot tables
  • How to base pivot tables from an external source or an Excel data model
  • How to build pivot charts, which are automatically synchronized with the corresponding pivot tables
  • How to sort and filter in pivot tables
  • Methods for grouping categories, especially dates, with many categories in pivot tables
  • An understanding of the role of pivot caches for extremely fast pivot table calculation
  • How conditional formatting in pivot tables provides even more insightful reports
  • How to create calculated items and calculated fields for pivot tables
  • How to use pivot tables for finding unique values, creating histograms, and classification (learning which variables are related to a Yes/No variable)

Course content

7 sections • 36 lectures

Introduction to Course 3 lectures

Welcome to Pivot Tables and Pivot Charts Course Preview 05:07

How to download Exercise Files and Handouts Preview 00:22

REMINDER: Turn on HD Preview 1 page

Why Pivot Tables? 2 lectures

What Pivot Tables Do for You Preview 07:46

Life Without Pivot Tables Preview 03:56

Creating a Pivot Table 7 lectures

Data Structure for Pivot Tables Preview 04:29

Creating a Pivot Table Preview 06:05

Pivot Charts Preview 05:18

Pivot Table Layouts Preview 05:11

Excel Tables Preview 06:37

Pivot Tables Based on a Table Preview 03:29

Pivot Tables Based on External Data Preview 04:56

Basic Pivot Table Tools 13 lectures

Pivot Table Fields Pane Options Preview 04:21

Placing Fields in a Pivot Table Preview 04:13

Multiple Fields in the Values Area Preview 03:16

Value Field Settings for a Numeric Field Preview 04:30

Displaying Counts in a Pivot Table Preview 06:17

Show Values As Options Preview 05:05

Filtering and Collapsing on Row and Column Fields Preview 05:18

Field Settings for a Categorical Field Preview 04:22

Sorting in Pivot Tables Preview 04:43

Sorting with a Custom List Preview 02:44

More Filters for Row and Column Fields Preview 06:14

Slicers for Filtering Preview 06:48

Styles for Pivot Tables and Charts Preview 03:33

Other Pivot Table Tools 8 lectures

Pivot Cache Preview 05:28

Converting a Pivot Table to Static Values Preview 01:51

Grouping by Selection Preview 04:38

Showing Report Filter Pages Preview 02:51

Displaying Cells with No Data Preview 02:31

PivotTable Options Dialog Box Preview 03:02

Using GetPivotData for Custom Reports Preview 07:43

Efficiency Tips for Pivot Tables Preview 05:26

Selected Uses of Pivot Tables 2 lectures

Finding Unique Values with a Pivot Table Preview 03:56

Creating a Histogram with a Pivot Table Preview 02:55

Conclusion to Course 1 lectures

Conclusion to Pivot Tables and Pivot Charts Course Preview 02:54