Excel 2003 Pivot Tables & Macros

EXCEL 2003 PIVOT TABLES & MACROS. WORKSHOP DESCRIPTION. The first leg of the Excel Workshop series was designed primarily for those who had little …

More PDF Content

Excel 2003 Pivot Tables & Macros
What is a PivotTable? …3 Sample Example …3 PivotTable Terminology…5 Creating a PivotTable …6 Launching the Wizard…6 Layout of the PivotTable…8 Pivoting a PivotTable…9 Refreshing a PivotTable …9 Grouping and Ungrouping Data …10 Removing Groups …11 Creating a PivotChart …12 Exercise # 1 …13 What is a Macro? …14 Recording a Macro …14 Run a Macro without Using Keyboard Shortcuts…16 The VBA Environment …17 Editing a Macro …19 Writing your own Macro using the VB Editor …21 Exercise # 2 …22

Download Excel 2003 Pivot Tables & Macros pdf from www.csus.edu, 22 pages, 851.63KB.
Related Books

Leave a Reply