Corporate Frontier Services

Email

info@cfrontier.com

Call Us

+6 088 731 570

Follow us :

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

INTRODUCTION

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: azrul@cfrontier.com / Tel: +6088731410

Ms. Tracy / email: tracy@cfrontier.com / Tel: +6088731570

Ms. Emily / email: emily@cfrontier.com / Tel: +6088731412

Ms. Joan / email: joan@cfrontier.com / Tel: +6088731575

Facebook
WhatsApp
Twitter
LinkedIn
Pinterest

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

ATTENTION!!!

In line with the announcement from the Ministry of Finance in October 2023, we wish to inform you about an upcoming changes in the Sales and Service Tax (SST) rate in Malaysia.

Effective March 1, 2024, the SST rate will be increased from 6% to 8%. As a result of this adjustment, there will be changes in the pricing of our training services provided by CF Learning Services Sdn Bhd starting March 2024 onwards.

We understand the importance of transparent communication and aim to minimize any inconvenience this may cause. If you have any questions or concerns regarding this change, please do not hesitate to reach out to our customer service team.

Thank you for your continued support and understanding.