Visualize Stunning & Dynamic Dashboard (Online Training)



  • Made up from charts, tables and numbers to provide visual representation of the report
  • One central place to visualize the summarized report
  • Gives high level view of current business status or performance
  • Users allow to quickly slicing and dicing data that they need

When to Use

  • Need visualize the data trend to make business decision
  • To track and compare current business status or performance
  • Need to create multiple report according to department or products

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 : Sporting trends with Conditional Formatting
    • Highlighting the Top 10 analysis
    • Spotting larger or smaller numbers in a range
    • Applying indicator icon to visualize range of value

  • Lesson 2 : Showcase Meaningful data as Pivot Chart
    • Getting the right chart to visualize the data
    • Customizing Pivot Chart Layouts and style
    • Joining two type of chart to represent 2 corresponding value

  • Lesson 3 : Mini charts for series of data with Sparkline
    • Show trends in a series of values with Sparkline – Line
    • Highlight maximum or minimum values with Sparkline – Column
    • Quick formatting multiple sparkline with ONE click

  • Lesson 4 : Sketch Dashboard Layout
    • Compiling all visual representation into one page
    • Create best layout by position all items
    • Standardize the Formatting of the page

  • Lesson 5 : Create and manage cell / shape link
    • Linking important value from pivot table into Dashboard

  • Lesson 6 : Interactive Selection with Slicer and Timeline
    • Dynamic filter to update entire dashboard with slicer
    • Focusing on a selected time period with Timeline

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
  • 21 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?