Microsoft Excel 2013 Pivot Table Training Course (SkillsFuture Approved)

Introduction to Pivot Table

• 1. What is Pivot Table
• 2. Create Pivot Tables
• 3. Editing Pivot Tables
• 4. Updating Pivot-Table
• 5. Filter Data
• 6. Split Items Into Different Worksheets
• 7. Pivot Chart

Shortcuts

• 1. Pivot-Table Keyboard Shortcuts

Customizing Pivot Table

• 1. Add Rows, Columns or Pages Field
• 2. Remove Field
• 3. Add New Fields
• 4. Flipping Orientation
• 5. Remove Fields by Changing Data Source
• 6. Move Items with a Field
• 7. Change Name of Pivot Table
• 8. Select Entire Pivot Table
• 9. Reset Pivot Table
• 10. Group Fields
• 11. Sort Pivot Table
• 12. Format Pivot Table
• 13. Expanding or Collapsing Buttons
• 14. Displaying More Information
• 15. Group Items with Numeric Labels

Work with Date Field

• 1. Group by Date
• 2. Insert Timeline
• 3. Filtering with Timeline
• 4. Clear Timeline Filters
• 5. Timeline Styles
• 6. Resize Timeline
• 7. Delete Timline

Filtering Data

• 1. Filter with Column Area
• 2. Filter with Row Area
• 3. Clear All Filters
• 4. Clear Individual Filters

Slicers

• 1. Inserting Slicers
• 2. Changing Slicer Styles
• 3. Move Slicer
• 4. Resize Slicer
• 5. Filter with Slicer
• 6. Clear Slicer Filters
• 7. Delete Slicer

Format Pivot Table

• 1.Report Layout
• 2. Value Labels
• 3. Pivot Table Styles
• 4. Copy Pivot Table Styles
• 5. Insert Blank Rows
• 6. Repeat All Item Labels
• 7. Grand Totals
• 8. Display or Hide Grand Totals
• 9. Display or Hide Subtotals
• 10. Format Numbers

Pivot Chart

• 1. Create Pivot Chart
• 2. Move Pivot Chart
• 3. Change Pivot Chart Style
• 4. Hide Legend
• 5. Data Table

Print Pivot Table

• 1. Print Headers
• 2. Print Pivot Table
• 3. Print Item on Own Page
• 4. Print Pivot Chart

Importing

• 1. Importing Text File
• 2. Importing Access File

Calculated Field

• 1. Create Calculated Field
• 2. How to Use Summary Calculation

Consolidating Multiple Worksheets

• 1. Consolidating Multiple Worksheets
• 2. Consolidating Data with Multiple Page Fields