Microsoft Excel Dashboard Training

Excel Dashboard & Interactive Reports Training Excel Dashboard & Interactive Reports
By TED Integrated
Microsoft® Excel Series:

Microsoft® Excel Dashboard & Interactive Reports

“Assess your company performance from large data in fingertips!”

By TED Integrated


PSMB Certified Training Provider
Request for In-house TrainingRequest for In-house Training
Register for Public Training Public program not yet available
Register for Public TrainingRegister for Public Training
Email Customer Service [email protected] Contact Customer Service +603-2386-7788
Course Title:
Microsoft® Excel Dashboard & Interactive Reports
Training Category:
Information Technology
Target Audience:
Business development personnel, marketing analysts, product managers, sales persons, and those who want to keep track of company's KPIs.
Duration:
2 Days
Public Training Events
Nov 2017 ›
Venue:
TED Learning Centre, Binjai 8, Kuala Lumpur, Malaysia
Schedule:
Mon 06 Nov 2017 - Tue 07 Nov 2017
9:00AM - 5:00PM

Fee Per Person:
RM1,400.00
Promotions:
  • 10% discount for group registration of 3 paxs or more from the same organization.
Register Now!

* Other terms & conditions apply.
Venue:
TED Learning Centre, Binjai 8, Kuala Lumpur, Malaysia
Schedule:
Mon 27 Nov 2017 - Tue 28 Nov 2017
9:00AM - 5:00PM

Fee Per Person:
RM1,400.00
Register Now!

* Other terms & conditions apply.
Dec 2017 ›
Venue:
TED Learning Centre, Binjai 8, Kuala Lumpur, Malaysia
Schedule:
Mon 04 Dec 2017 - Tue 05 Dec 2017
9:00AM - 5:00PM

Fee Per Person:
RM1,400.00
Promotions:
  • 10% discount for group registration of 3 paxs or more from the same organization.
Register Now!

* Other terms & conditions apply.
Jan 2018 ›
Venue:
The Zon Hotel, Jalan Ampang, Kuala Lumpur, Malaysia
Schedule:
Mon 22 Jan 2018 - Tue 23 Jan 2018
9:00AM - 5:00PM

Fee Per Person:
RM1,484.00
Register Now!

* Other terms & conditions apply.
Feb 2018 ›
Venue:
The Zon Hotel, Jalan Ampang, Kuala Lumpur, Malaysia
Schedule:
Wed 14 Feb 2018 - Thu 15 Feb 2018
9:00AM - 5:00PM

Fee Per Person:
RM1,484.00
Register Now!

* Other terms & conditions apply.
Mar 2018 ›
Venue:
The Zon Hotel, Jalan Ampang, Kuala Lumpur, Malaysia
Schedule:
Mon 12 Mar 2018 - Tue 13 Mar 2018
9:00AM - 5:00PM

Fee Per Person:
RM1,484.00
Register Now!

* Other terms & conditions apply.
Apr 2018 ›
Venue:
The Zon Hotel, Jalan Ampang, Kuala Lumpur, Malaysia
Schedule:
Thu 05 Apr 2018 - Fri 06 Apr 2018
9:00AM - 5:00PM

Fee Per Person:
RM1,484.00
Register Now!

* Other terms & conditions apply.
May 2018 ›
Venue:
The Zon Hotel, Jalan Ampang, Kuala Lumpur, Malaysia
Schedule:
Wed 02 May 2018 - Thu 03 May 2018
9:00AM - 5:00PM

Fee Per Person:
RM1,484.00
Register Now!

* Other terms & conditions apply.
Venue:
The Zon Hotel, Jalan Ampang, Kuala Lumpur, Malaysia
Schedule:
Thu 31 May 2018 - Fri 01 Jun 2018
9:00AM - 5:00PM

Fee Per Person:
RM1,484.00
Register Now!

* Other terms & conditions apply.
Jul 2018 ›
Venue:
The Zon Hotel, Jalan Ampang, Kuala Lumpur, Malaysia
Schedule:
Wed 11 Jul 2018 - Thu 12 Jul 2018
9:00AM - 5:00PM

Fee Per Person:
RM1,484.00
Register Now!

* Other terms & conditions apply.
Aug 2018 ›
Venue:
The Zon Hotel, Jalan Ampang, Kuala Lumpur, Malaysia
Schedule:
Mon 13 Aug 2018 - Tue 14 Aug 2018
9:00AM - 5:00PM

Fee Per Person:
RM1,484.00
Register Now!

* Other terms & conditions apply.
Sep 2018 ›
Venue:
The Zon Hotel, Jalan Ampang, Kuala Lumpur, Malaysia
Schedule:
Thu 13 Sep 2018 - Fri 14 Sep 2018
9:00AM - 5:00PM

Fee Per Person:
RM1,484.00
Register Now!

* Other terms & conditions apply.
Oct 2018 ›
Venue:
The Zon Hotel, Jalan Ampang, Kuala Lumpur, Malaysia
Schedule:
Mon 08 Oct 2018 - Tue 09 Oct 2018
9:00AM - 5:00PM

Fee Per Person:
RM1,484.00
Register Now!

* Other terms & conditions apply.
Nov 2018 ›
Venue:
The Zon Hotel, Jalan Ampang, Kuala Lumpur, Malaysia
Schedule:
Thu 08 Nov 2018 - Fri 09 Nov 2018
9:00AM - 5:00PM

Fee Per Person:
RM1,484.00
Register Now!

* Other terms & conditions apply.
Dec 2018 ›
Venue:
The Zon Hotel, Jalan Ampang, Kuala Lumpur, Malaysia
Schedule:
Mon 03 Dec 2018 - Tue 04 Dec 2018
9:00AM - 5:00PM

Fee Per Person:
RM1,484.00
Register Now!

* Other terms & conditions apply.
For In-house Training
Request for Quotation Request for Quotation
For Other Inquiries
Contact TED Integrated
Contact customer service +603-2386-7788
Email customer service [email protected]
Delivery Methods
  • Language: English
  • PowerPoint Presentation
  • Presentation Handouts
  • Computer Lab Work
  • Participant Presentation
  • Certificate of Participation
Ad by Google
*Terms & Conditions

Course Introduction ›

This is a 2-Day Excel Dashboard & Interactive Reports training for those who want to dive into company's large data and look at the company's KPIs for decision making purposes. If you have the basic knowledge of Excel charts, pivot tables, functions and formulas, you can proceed to this course to learn how to create dashboard out of your, example sales data, that allows you to interactively slice-and-dice within the data and gain greater insights out of your company's business performance. It enables you to have a high level view of your company KPIs and later zoom into details to figure out the cause of each KPI. Excel Dashboard is definitely a great tool to help business people to make good and wise decisions.

To request for in-house training, click on the Request for In-house Training link as displayed above for quotation. For a complete course cotent and more information about this course, feel free to contact the training provider as shown above. If the public program is available, you can request for a registration online by clicking on the Register for Public Training link. If the link is disabled, it simply means it has yet to be available for public. You can contact the training provider for further inquiry.

Course Objectives ›

After the completion of this workshop, participants should be able to understand the following:

  • What is Excel Dashboard?
  • Excel Data Visualisation Tools
  • Analysing Data with Pivot Reports
  • Adding Interactive Elements
  • Creating Interactive Reports
  • Variance Analysis Dashboard
  • Automating Dashboards with Functions
  • Visual Basic for Applications (VBA)

Prerequisites ›

Participants must have basic knowledge of Excel charts, pivot tables, functions and formulas.

Course Outline ›

DAY 1

Dashboards

  • Introduction to Dashboards
  • Excel Dashboards
  • What Makes Good Dashboard
  • Using the Proper Visualizations
  • Dashboard Creation Process
  • Why Is the Chart Type Important?

Data Visualisation Tools

  • When to Use a Secondary Axis
  • Combining Two Chart Types
  • Formatting Tricks

Analysing Data with Pivot Reports

  • What Are Pivot Reports?
  • Creating a Dynamic Range for Data Expansion
  • Creating a Pivot Report
  • Incorporating Visual Analysis with Conditional Formatting
  • Grouping Data

Adding Interactive Elements

  • Slicing & Dicing Data
  • Querying Pivot Reports
  • Creating Pivot Charts
DAY 2

Creating Interactive Reports

  • An Alternative to the VLOOKUP Function
  • Charting Tricks
  • Showing Positive & Negative indicators

Variance Analysis Dashboard

  • Returning a Value Based On User Selection
  • Incorporating Form Controls
  • Incorporating Hyperlinks

Automating Dashboards with Functions

  • Offset Function
  • CountA Function
  • Structuring Your Data
  • Linked Textbox
  • Named Formulas
  • Creating Gauge / Speedometer Charts

Visual Basic for Applications

  • What Is VBA?
  • Basics of VBA & Macros
  • Executing a Procedure
  • Converting a Workbook To A Macro Enabled Workbook

Contact us now ›

  • Course content customization
  • In-house training request
  • Available public program
  • Consultation services
  • Other inquiries
Contact Customer ServiceCall : +603-2386-7788
Email Customer Service E-mail : [email protected]

Related Courses ›

Published by: ,