Duration: 1 day
Time: 9am to 6pm

What Will Be Taught For This MS Excel Pivot Training Course?

This in-depth one-day Excel Pivot training course introduces ways to create and work with Pivot Tables to look, organize and summarizes, your data in a variety of ways. Discover how to perform a variety of calculations with Pivot Table Data. Pivot Table – a great analysis tool!

Module 1. Making Data Work For You
  • Maximize the Power of PivotTable
  • Ask the Questions
  • Get the Answer
  • Review
Module 2. A Quick Tour
  • Determine What You Need to Know
  • Identify the Source
  • Creating the Pivot Table
  • Working with Pivot Table Layout
  • Review
  • Practice – Creating the PivotTable
Module 3. Manipulating the PivotTable
  • Rearranging the Layout
  • Adding New Field
  • Renaming a Field
  • Formatting Numbers
  • Changing Sorting Order
  • Showing Top 10
  • Refreshing Data
  • Review
  • Practice – Manipulating the PivotTable
Module 4. Digging Deeper
  • Grouping Items
  • Displaying Subtotals
  • Hiding/Showing Grand Totals
  • Formatting PivotTable
  • Using Slicer
  • Formatting Slicer
  • Review
  • Practice – Grouping Item and Using Slicer
Module 5. Beyond the Basics
  • Creating s Second Data Field
  • Changing the Summary Function
  • Displaying Numerical Value as a Percentage of the Total
  • Creating a Custom Calculation
  • More Function in Custom Calculation
  • Review
  • Practice – Creating Custom Calculation
Module 6. More PivotTable Calculations
  • Using Formulas
  • Creating a Calculated Field
  • Creating a Calculated Item
  • Using GetPivotData Function
  • Turn off GetPivotData Function
  • Review
  • Practice – More PivotTable Calculations
Module 7. Optional Topics
  • Creating PivotChart
  • Publishing PivotTable to the Web
  • Timeline in PivotTable
  • Creating Relationships between Mutiple Tables
  • Mutiple Tables in Data Analysis
  • Drill To in PivotTable
  • Using Multiple Source Ranges
  • Review

Who Should Attend This Microsoft Excel PivotTable Course Training?

Anyone with general proficiency in Microsoft Excel 2013 and looking to perform various calculations with PivotTable Data.

Pre-requisite

An understanding of Microsoft Excel 2010 will be an added advantage.

  w/o GST w GST
Course Fee $350 $374.50

This course is applicable for Skills Development Fund (SDF).


Remarks:

Individual Sponsored

  • Eligible Singapore Citizens can use their SkillsFuture Credit to offset course fee payable after funding.
  • This course is supported under UTAP funding.
  • This course is eligible for using PSEA funds.

Terms & Conditions

  • All prices stated above are in Singapore Dollars (SGD). This funding support is only applicable for Singapore Citizen and Permanent Residents.
  • Trainee must attained minimum 75% attendance in order to qualify for Funding.
  • Trainee undertakes to reimburse ST Electronics (e-Services) FULL course fees should he/she be ineligible for course fee grant. ST Electronics (e-Services) is not liable for any other funding not approved by WSG.
  • ST Electronics (e-Services) reserves the right to change the date or venue without prior notice.
  • ST Electronics (e-Services) reserves the right to cancel or reschedule the course due to class size or unforeseen circumstances.


Please click on the course date to enrol.