These are the exercise files used for NICF - Create Interactive Dashboard Using Excel course.
The course outline can be found in
https://www.tertiarycourses.com.sg/wsq-interactive-dashboard-excel.html
Topic 1 Data Visualization and Display using Excel Pivot Tables and Charts.
- Data analysis using Excel pivot tables and charts
- Organize and visualize data to show trends and correlation
Topic 2: Create Basic Excel Dashboard and Scorecards
- Sketch your dashboard layout
- Link to Excel pivot tables
- Incorporate appropriate dashboard elements such as gauge chart, KPI
Topic 3 Create Interactive Excel Dashboard
- Form control, value-based formatting and dynamic series selection
- Animating changes over time
- Limitations of data and Interpretation of findings
Mode of Assessment
- Practical Performance
- Oral Questioning