On course for success

MS EXCEL DASHBOARD F OR BEGINNERS

Programme Overview

What is the difference between a Report and Dashboard?

More often than not, reports are commonly referred to as dashboards due to minor similarities, such as the inclusion of charts. Likewise, dashboards are also frequently referred to as a type of report. It is imperative to understand the core attributes of the different features available, to fully understand what should be considered as a ‘dashboard’.

Programme Outline

Module 1: Introduction to Dashboard (total of five practical tutorials).
Module 2: Data Visualization.
Module 3: Conditional Formatting.
Module 4: Excel logic functions adding dynamics to your dashboard.
Module 5: Explore the 5 rules of effective charting.
Module 6: Bar, Column, Pie and Line charts to display data.
Module 7: Complex charts like scatter plots & Combination charts
Module 8: Interactivity Dashboard with the MATCH () and INDEX ()functions.
Module 9: Leverage Pivot Tables.
Module 10: Conditional Formats to Pivot Tables for Dashboard Application.
Module 11: Filtering and Linking Dashboards Using Slicers.

Who Should Attend

This programme is suitable for participants who are interested in trans forming raw data and reports into meaningful representation.

Your Investment

Stakeholder*: BND $ 700.00 (4% SBS)
Non-Stakeholder: BND $ 850.00

* Stakeholders are participants from MOFE, AMBD and all domestic banks in Brunei Darussalam.

Download Brochure here
▲ Top