|
Pivot Tables
Creating a Pivot
Table with the Wizard (2003)
Creating a Pivot
Table from scratch
Using the Field
List
Using the Pivot
Table Toolbar
Choosing what
Data to Display and Hide
Creating Totals
and Subtotals
Creating
Averages, Counts, etc.
Pivot Table
Formulas
Refreshing Data
Changing the Layout of a Pivot Table
Rearranging
Fields
Creating Groups
Formatting a
Pivot Table
Using AutoFormat
Selecting
Elements within a Pivot Table
Field Options
Pivot Table
Options
Creating Pivot Tables from External Data
Creating Pivot
Tables from Multiple Consolidation Ranges
Creating Pivot
Tables from Other Pivot Tables
Creating Pivot
Charts
Working with
Pivot Charts
Formatting Pivot
Charts
|
Group & Outline, &
Subtotals
Grouping Rows/Columns on a
Sheet
Showing/Hiding Details in an
Outline
Display/Hide Outline Symbols
Using Subtotals
Adding Automatic Subtotals
Adding Other Automatic
Analysis (Average, Count, etc)
Removing Subtotals
Creating Database
Functions
Using DSUM, DAVERAGE, DCOUNT,
etc.
Creating Criteria Ranges
Editing Criteria to Change
Formula Results
Using Range Names in Database
Functions
Advanced Filter
Setting Up the Ranges
Performing the Filter
Setting Up the Criteria Range
|
