Excel Dashboard and Interactive Reports (SBL KHAS)

About Excel Dashboard
An Excel Dashboard can be an amazing tool when it comes to tracking KPIs, comparing data points, and getting data-backed views that can help management make decisions also. An Excel dashboard is one pager (mostly, but not always necessary) that helps managers and business leaders in tracking key KPIs or metrics and take a decision based on it. It contains charts/tables/views that are backed by data. Excel dashboards and executive reports are powerful, fairly easy to design and a great way to improve your Excel and data visualization skills. Because of its flexibility, you can virtually design any dashboard in Excel exactly the way you, or the users, imagined. And, best of all, you may want to implement it yourself or consider it a prototype and ask IT to implement it.
OUTLINE
MODULE 1: EXCEL DASHBOARD
- Intro To Excel Dashboards
- Using The Proper Visualizations
- Dashboard Creation Process
MODULE 2: DATA VISUALISATION TOOLS
- Selecting the right chart
- Chart Making Process
- Formatting Tricks
MODULE 3: CREATING INTERACTIVE REPORTS
- An Alternative To The VLOOKUP Function
- Calculating Standard Deviation
- Showing Data Dispersion With Error Bars
- Variance Analysis Dashboard
- Returning A Value-Based On User Input
- Incorporating Controls
- Incorporating Hyperlinks
MODULE 4 : ANALYSING DATA WITH PIVOT REPORTS
- Creating a Pivot Report
- Creating A Dynamic Range For Data Expansion
- Incorporating Visual Analysis
- Adding Interactive Elements
- Slicing & Dicing Data
- Querying Pivot Reports
MODULE 5: AUTOMATING DASHBOARDS WITH FUNCTIONS
- Offset Function
- CountA Function
- Structuring Your Data
- Linked Textbox
- Named Ranges & Formulas
MODULE 6: AUTOMATING DASHBOARDS WITH VBA
- Basics of VBA & Macros
- Incorporating macros in Dashboards