Excel 2010: Virtual Training - Pivot Tables

COURSE OUTLINE:

Description This 1/2-day training will help students organize and analyze data using Pivot tables and Pivot Charts. Pivot tables allow you to summarize and organize large databases into manageable and understandable reports. After the pivot table is created, it will be necessary to modify it to obtain the desired formatting and adjustments. This will also show how to manipulate complex pivot reports with drill-down capabilities, and build a dynamic pivot table reporting system.

Virtual classes are interactive training sessions delivered in real-time via the Web. Analyze Data Using PivotTables, Slicers and PivotCharts

  • Create a PivotTable Report
  • Choose the Type of Calculation to Summarize Data
  • Sort Data
  • Filter Data
  • Group Field Data
  • Format a Pivot Table Report
  • Analyze Data Using a PivotChart
  • Choose the Most Effective Chart Type
Course Content

FORMULA MANIPULATION REVIEW

Methods to enter Formulas Methods to check Formulas Fill Handles Absolute Values

MANAGING DATA

Working with Named Cells and Ranges Named Range Box and Menu Options Paste Names into a Cell or Formula Create Names from a List Apply Names to Existing Formulas Relative/absolute and row/column name

IF LOGIC

IF Function Nested IF AND / OR Logic IS Functions

ARRAY FORMULAS

Array Formulas Creating an Array Formula Summing a Range that Contains Errors Count the Differences in Ranges Check for Specific Values in a Range Sum Product Function

LOOKUP FUNCTIONS

VLOOKUP Function MATCH Function INDEX Function MATCH with INDEX Function VLOOKUP with IF LOOKUP Function

DATABASE FUNCTIONS

Database Basics Database Function Basics DAVERAGE Function DCOUNT Function DMAX Function DSUM Function DGET Function