Microsoft Excel 2013 Pivot Table Training Course (SkillsFuture Approved / PIC Claimable)

 Microsoft Excel 2013 Pivot Table Training Course

Microsoft Excel 2013 Pivot Table Training Course at $250 (SkillsFuture Approved / PIC Claimable)
After PIC Price: $150 (Company Sponsored)
SkillsFuture Covers 100% of Course Fees (Self Sponsored)

Microsoft Excel 2013 Pivot Table Training Course Singapore

(SkillsFuture Approved / PIC Claimable)

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
  1. 26th April 2017, Wednesday, 9.30am to 5.30pm [Registration Closed]
  2. 31st May 2017, Wednesday, 9.30am to 5.30pm
  3. 27th June 2017, Tuesday, 9.30am to 5.30pm
  4. 28th August 2017, Monday, 9.30am to 5.30pm
  5. 22nd September 2017, Friday, 9.30am to 5.30pm
  6. 26th October 2017, Thursday, 9.30am to 5.30pm
  7. 30th November 2017, Thursday, 9.30am to 5.30pm

Oasia Hotel Office Tower (PS100) or International Plaza – Beside Tanjong Pagar MRT

MOCD Excel Course Banner

Pivot Table is one of Excel’s most powerful feature. At our Microsoft Excel 2013 Pivot Table Training Course, you can use Pivot Tables in Excel to extract data from large and detailed data source, and present, analyze and summarize your data easily.

In this intensive 1 day Excel 2013 Excel Pivot Table training course, you would learn how to use Pivot Table Excel and get the most from your data.

Various practical scenarios and hands-on examples would be presented to enable you to advance in your usage of Excel. You would learn how to generate formulas in an Excel pivot table and create pivot tables easily. You will have better skills in creating reports and analyze your data better.