These are the exercise files used for Creating an Interactive Excel Dashboards for Business Analytics course.
The course outline can be found in
https://www.tertiarycourses.com.sg/excel-dashboards-business-analytics.html
Module 1: Overview on Interactive Dashboard
- What is Interactive Dashboard
- Why use Excel for Interactive Dashboard
Module 2 Preparing the data for the dashboard
- Keeping inputs clean with data validation
- Mass cleaning data with text manipulating functions
- Removing duplicates & highlighting errors with conditional formatting
- Merging tables with formulas
- Creating Variables
- Adding Reference Tables
- Creating Action Queries
Module 3: Designing Visually Professional Layout for Dashbord
- Creating a Visual Design
- Creating a pivot chart
- Formatting charts
- Creating Hierachy in the Template
- Styling the Layout
Module 4 Create a Report
- Import data with pivot tables
- Understanding the 4 quadrants of a pivot table
- Creating, sorting and filtering pivot tables
- Creating interactive data tables with slicers
- Recoding a macro
- Editing VBA code
- Inserting control buttons
- Goal seek & solver