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
Keyword
Course #
State

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


Advanced Pivot Tables


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

 
     
Prerequisite: 
 
   
     
Duration: 
.5 Day  
     
     

View Printer Friendly Page

 


To Inquire About Future Classes

Request a class date

if one is not scheduled.