MS EXCEL DASHBOARD FOR BEGINNERS [VILT]
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’.
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 transforming raw data and reports into meaningful representation.
Stakeholder*: BND $ 700.00 (4% SBS)
Non-Stakeholder: BND $ 850.00
* Stakeholders are participants from MOFE, BDCB and all domestic banks in Brunei Darussalam.Download Brochure Here