Create Interactive Dashboard Using Excel
About This Course
Master the art of dashboard creation with our WSQ-endorsed course focused on using Excel for interactive data visualization. The course covers essential skills such as utilizing pivot tables, incorporating various data sources, and applying advanced Excel functions. With hands-on exercises and real-world examples, you'll gain practical know-how that can be immediately applied in your work or business.
Upon completing the course, you’ll be well-equipped to build interactive dashboards that provide a dynamic and user-friendly way to interpret complex data sets. Whether you're a business professional, data analyst, or someone interested in improving data presentation skills, this course sets the foundation for effective data visualization and decision-making through Excel dashboards.
What You'll Learn
- perform data analysis and create visualization using Excel
- develop basic dashboards and scoreboards by incorporating appropriate visual elements.
- create interactive dashboard and communicate limitation of findings.
Course Outline:
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
Entry Requirements
Knowledge and Skills
• Able to operate using computer functions
• Minimum 3 GCE ‘O’ Levels Passes including English or WPL Level 5 (Average of Reading, Listening, Speaking & Writing Scores)
Attitude
• Positive Learning Attitude
• Enthusiastic Learner
Experience
• Minimum of 1 year of working experience.