Advanced Pivot Tables

.5 Day

Description

Create a Pivot Table using data already in Excel

From the Data TAB on the any of the spreadsheets create PivotTables for the following:

  • Customer Count by Week
  • Group Count by Week
  • Ship to Count by Week

Create a Pivot Table (linking it to an Access Database Table)

  • Importing the data
  • Importing as PivotTable
  • Auto-update the data
  • Update on Open
  • Refresh options

Change PivotTable settings

  • Sum / Count / Min / Max / Avg /
  • Formatting (Dates, Currency, )
  • Filters (Top 10, Starts with, )
  • Re-arranging fields / layout

Using Formulas for PivotTables

  • Adding new Columns/Rows/Fields for formulas
  • Making new Fields available
  • Adding multiple Fields (Count & Sum, Count & Max & Min, )

Totals for PivotTables

  • Grouping / Subtotals / Show Totals
  • Slicers
  • Showing different totals (% of Totals,
  • PivotTable options

No Upcoming Public Classes

There are currently no public events available for this course. However, you can submit a request for a new date and we will try our best to get you into a Advanced Pivot Tables class.

Private Training Available
No date scheduled, don’t see a date that works for you or looking for a private training event, please call 651-905-3729 or submit a request for further information here.
request a private session or new date

Course Overview

unknown

No Upcoming Public Classes

There are currently no public events available for this course. However, you can submit a request for a new date and we will try our best to get you into a Advanced Pivot Tables class.

Private Training Available
No date scheduled, don’t see a date that works for you or looking for a private training event, please call 651-905-3729 or submit a request for further information here.
request a private session or new date

Prerequisites

No Upcoming Public Classes

There are currently no public events available for this course. However, you can submit a request for a new date and we will try our best to get you into a Advanced Pivot Tables class.

Private Training Available
No date scheduled, don’t see a date that works for you or looking for a private training event, please call 651-905-3729 or submit a request for further information here.
request a private session or new date