KT-9123 Advanced Pivot Tables Training - Minneapolis, Minnesota IT MN Technical Financial New York, NY
Knowledge Transfer Microsoft Certified Silver Training Partner CPLS
Knowledge Transfer is a Microsoft Certified Silver Learning Partner
Oracle University


Microsoft Certified Training Partner CTEC
Search for a Course Topic:
Public Courses
Corporate Services & Training



 Course Search
Course #

 Training Delivery
Training Delivery
Custom Curriculum
Course List
 Main Menu
View Courses
Site Index

Advanced Pivot Tables


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

.5 Day  

View Printer Friendly Page


To Inquire About Future Classes

Request a class date

if one is not scheduled.