Learning Excel 2000 Pivot Tables (Cd Rom)

List Price: $82.99

Features:

• 1.0 Background (10 Mins) 1.1 An Example 2.0 Creating a Pivot Table (18 Mins) 2.1 Using the Pivot Table & Pivot Chart Wizard 2.2 Viewing Pivot Tables & Pivot Charts 3.0 Manipulating the Layout (15 Mins) 3.1 Interchanging Fields
• 3.2 Adding & Removing Fields 3.3 Page Axis 4.0 Content & Formatting (7 Mins) 4.1 Numeric Formatting 4.2 Selecting Specific Information & AutoFormat
• 5.0 The Refresh Button (7 Mins) 5.1 Changing Original Data 5.2 Changing Field Names 6.0 Pivot Table Chart Sources (14 Mins) 6.1 Selecting & Manipulating Chart Data 6.2 The Pivot Chart & Pivot Table Relationship 6.3 Pivot Chart Formatting
• 6.4 Creating a Pivot Chart & Table Together from the Original Data7.0 Sorting Items (9 Mins) 7.1 Sorting by Field Order & Numeric Information 8.0 Hiding & Revealing Data (13 Mins)
• 8.1 Drop Arrows 8.2 Hiding Inner Fields 9.0 Grouping & Ungrouping (5 Mins) 9.1 Grouping Data 9.2 Grouping by Date 10.0 Totals (8 Mins) 10.1 Displaying Totals 10.2 Adding & Removing Totals

Click here for more details and discount information...