Duration: 1 day / 7.5 hours
Time: 9am to 5.30pm
Course Code: CRS-N-0041127

Funding available for this course :

SkillsFuture Credit PSEA Broad based Funding





What Will Be Taught For This Microsoft Excel PivotTable Course?

This in-depth one-day 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
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
  • Using Multiple Source Ranges
  • Review

Who Should Attend This Microsoft Excel PivotTable Course Training?

Anyone with general proficiency in Microsoft Excel 2010 and looking to perform various calculations with Pivot Table Data.


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

  w/o GST w GST
Course Fee $320 $342.40



  1. 2 to 4 weeks’ written notice from start date of training - 50% of course fee for cancellation

  2. Less than 2 weeks’ written notice from start date of training - 100% of course fees for postponement or cancellation

  3. ST Electronics (e-Services) Pte Ltd reserves the right to cancel or postpone any course or change the venue due to unforeseen circumstances.

Trainee shall be bound by the Terms and Conditions of any applicable funding scheme.

Please ensure that you have read our Terms and Conditions before submitting the enrolment form.

Please click on the course date to enrol.

  • CL: Classroom Learning
  • VILT: Virtual Instructor-Led Training
  • GTR: Guaranteed To Run
  • Sat: Saturday
  • Wkn: Weekend
Note: Courses are conducted via classroom unless stated otherwise beside the course dates.