Corporate Frontier Services


Call Us

+6 088 731 570

Follow us :

(Remote Online Training) Interactive Dashboard Reporting Using Excel, 20-21 July 2022 Via Zoom


The management and reporting of data is an important function of any modern business organisation. Business data is often available in the form of tables or data lists, which is a convenient format for Excel’s very considerable collection of powerful analytical and organisational tools. Building an Interactive Dashboard from these data sets help making informed business decisions easier. A typical dashboard consists of a collection of graphs, tables, statistical calculations and significant data, enabling management to monitor critical processes in a business or organisation.

This workshop will focus on Excel tools that you can employ for report building such as charting techniques, logical functions, tables and PivotTables. Also, learn how to effectively use drop-down lists and combo boxes, in combination with database functions. Understand how these features provide a convenient and flexible method of displaying key information using a simple mouse-click. This workshop will also show you a range of techniques for automatically updating dashboards when new data becomes available.

This workshop has been designed for professionals working with this application daily. It will provide you with a deeper knowledge of Excel, including many of the newer features introduced in Microsoft Excel.

Learning Objectives

At the end of this workshop, participants will be able to:

  • Use specialist Functions and Formulas
  • Manage Data in lists.
  • Use PivotTables to display and chart data
  • Use Power Pivot to create powerful reporting mechanisms
  • Create eye-catching visualizations and Dashboards with Power View
  • Design unique charts for Dashboard Visualisation
  • Automate Dashboards and Reports
  • Use Interactive Controls within Dashboards

100% HRD Corp Claimable Course: Skim Bantuan Latihan Khas

For more information, please contact the following Program Consultant:

Mr. Azrul / email: / Tel: +6088731410

Ms. Tracy / email: / Tel: +6088731570

Ms. Emily / email: / Tel: +6088731412

Ms. Joan / email: / Tel: +6088731575


Leave a Reply

Your email address will not be published. Required fields are marked *

About Author
Willaim Wright

Voluptas feugiat illo occaecat egestas modi tempora facilis, quisquam ultrices.

Follow us on