Transforming Data To Decision (Online Training)



  • With little effort, you can organize and summarize large data sets using pivot table
  • Analyzing data to see comparisons, patterns, and trends in your data
  • Same data but you can view at different perspective to make business decision

When to Use

  • To extract only useful data from large and detailed data sets
  • Track the sums of data from long rows or columns
  • Grouping data into categories or break down into time period

Target Audience

  • Sales Executive / Managers
  • Business Analysist
  • Resource Planning Team
  • Project Managers
  • Purchasing Manager
  • Financial Executive / Managers


This program will be conducted with interactive lectures, PowerPoint presentation, discussion, and practical exercise over a video conference platform.


Basic knowledge of Windows is essential with the following pre-requisites:

  • Able to switch between task applications
  • Able to create a spreadsheet with simple formatting
  • Able to use Auto Filter command
  • Able to use basic functions – AutoSum, Count, Max, Min and Average functions

Course Modules

  • Lesson 1: Creating Pivot Table
    • Getting ready source data
    • Creating Your First Pivot Table
    • Simplifying summary organizing field

  • Lesson 2: Quick Formatting
    • Configure Pivot Table Layout
    • Setting Pivot Table Style
    • Changing Number Format
    • Turn On summary with Subtotal and Grandtotal
    • Navigating report using Expanding and Collapsing

  • Lesson 3: Extracting Meaningful Data
    • Rearranging Top and Bottom value
    • Enabling Multiple Filer
    • Label Filter
    • Value Filter

  • Lesson 4: Categorizing Large Set of Data
    • Grouping Date
    • Grouping Your Own Selection

  • Lesson 5: Analyzing Pivot Table
    • Changing Summary Value with different formula
    • Measuring Value as Percentage
    • Preparing Accumulated Value
    • Comparing value against previous and next category
    • Adding calculation for multiple value fields

  • Lesson 6: Getting Latest Data into Pivot Table Report
    • Refreshing Pivot Table for additional data
    • Changing Data Source

Get To Know The Trainer

Trainer Jarina

Trainer Jarina


Managing and maintaining a Microsoft Windows Server 2003 Environment - educate the IT professionals who implement, manage, and troubleshoot existing network and system environments based on the Windows Server 2003 platform. Implementation responsibilities include installing and configuring parts of systems. Management responsibilities include administering and supporting systems

Chat with us LIVE to get a



  • 4 hours of Live Online / Virtual Training
  • 19 August 2020
  • 9am - 1pm


  • E-Certification
  • 14 Days of Email Support
  • HRDF Claimable



*T&C Applies

What Other People Bought


Login with your social account


Don’t have an account with us?

Edit Profile



Sign Up to Bookmark your Favourite Course
or Request for a Quotation instantly

Sign in with your social account


By signing up, you agree to our Terms of Use and Privacy Policy

Have an account with us already?