Creating/Revising Pivot Tables

Creating a pivot table; changing the source range, inserting into and deleting from the source range

Adding Pivot Table Fields

Adding row, page, and column fields; moving and deleting pivot table fields

Changing the Pivot Table Layout

Adding multiple data fields, hiding and unhiding items, renaming a field, creating a page field report, hiding and showing row and column details, displaying data details

Formatting Pivot Tables

Using Enable Selection, selecting pivot table parts, formatting a pivot table and numbers, using the AutoFormat feature, and Pivot Table options, disabling Preserve Formatting

Using Pivot Table Calculations

Adding other summary fields, changing the summary function, creating and changing a custom calculation, creating a calculated field and item

Grouping Pivot Table Items

Grouping and ungrouping items, renaming groups, hiding/showing group details, grouping by dates, and by number, sorting a pivot table, using AutoSort and AutoShow feature

Using Multiple Ranges

Selecting the Type of Page fields, multiple source ranges, and field1 and field2 ranges; displaying the pivot table; renaming custom page fields; using the consolidated table

Using Macros

Defining and running macros; opening a macro workbook and the Visual Basic editor; using a shortcut key

Recording Macros

Recording a macro, assigning a shortcut key, using relative references, assigning a macro to a menu, deleting a macro from a menu

Editing Macros

Editing a macro manually, running a macro from the code window, inserting a macro line, copying macro text between modules

Using the Personal Macro Workbook

Recording, editing, running, and deleting a personal macro; viewing the personal macro workbook; hiding the personal macro workbook

Debugging Macros

Stepping through a macro, setting a breakpoint, debugging a macro, entering macro comments, correcting a statement error, using statement color codes

Using Custom Functions

Defining, creating, and using a custom function; inserting a macro module; using the Paste Function button

Using Custom Toolbars and Buttons

Creating, attaching, detaching, and deleting a custom toolbar; adding a button to a toolbar; adding a custom button; assigning a macro to a button; changing a button image

Creating a Macro Button

Using, creating, copying, formatting, moving, sizing and deleting a macro button

Creating Custom Menus

Using custom menus, creating a menu, submenu, and menu command; testing a menu; deleting a custom menu item