Microsoft Excel Dashboards Training Course in Singapore
Microsoft Excel Data Analysis & Dashboard Reporting: Create Dynamic and Interactive Dashboards
UTAP
NTUC membersSkillsFuture Eligible
Course Start Date
Schedule
- Days: 2 Days
- Duration: 16.5 Hours
- Timings: 9:30 AM - 5:30 PM
- 10 Anson Road, 26-08A International Plaza, Singapore 079903
Why Choose Us
- Expert Local Trainers
- Hands-on Training by experts
- Certificate of Achievement
SSG Course Details
- TGS-2019500567
- Mode of Training - Physical, in-class training
- Course Subsidy Validity - Until 31-12-2024
- Register Now
Who Should Attend This Microsoft Excel Dashboard Training Singapore
Designed for students with existing Excel skills, this course focuses on higher-level features to help you create dynamic and insightful dashboards.
Business professionals
Analyst
Entrepreneur
Training Professionals
Student
Course Completion Requirements
Minimum 75% attendance is required in order to complete the course and receive the course completion certificate
Above 16 years old
High School Level English
Basic internet & computer operation skills
Microsoft Excel Dashboards Training Course
Whether you are working in sales, inventory, IT, HR or any other department in an organization, at any level, you will have a unique and potentially valuable competitive advantage in being able to offer the right information to the right people at the right time. That’s right - not just valuable, but essential information in today’s fast-moving data-driven environments.
Of course you know the basics: formatting, formulas and organization. But Excel is capable of so much more. What makes Excel a game changer is the ability to turn uninterpreted data into intelligence, and then to present that information in a clear, graphical form to facilitate decision-making and lead to actionable insights, including trends. The objective of this course is to help you to maximize your use of Excel by developing dynamic dashboards that save your time, convey a story, and drive better decision-making.
Course Objectives
By the end of this course, you will be able to design and build professional dashboards in Microsoft Excel 2016. You will gain the skills to:
- Develop and apply advanced Excel formulas to streamline data analysis
- Automate tasks and enhance workbook functionality using built-in tools
- Use conditional logic to create dynamic and responsive reports
- Visualize data effectively with standard chart types
- Implement advanced charting techniques for deeper insights
- Analyze and summarize complex data using PivotTables, slicers, and PivotCharts
Target Audience
This course is ideal for learners who already have a solid foundation in Excel and are ready to explore more advanced features. It’s designed for those who want to efficiently summarize and analyze data using functions, charts, and PivotTables, and learn how to present that information in a dynamic dashboard format.
Requirements
To succeed in this course, you should have prior experience creating Excel workbooks that include basic formulas and functions. A working knowledge of Excel’s interface and standard features is recommended.
Unsure if this course is suitable for you? Take this Quick test to help you decide.
Grants available
UTAP
Union Training Assistance Programme
UTAP: Update info about UTAP funding on all pages.
SkillsFuture Eligible
SkillsFuture Credit : Singaporeans can use $500 SkillsFuture Credits for this training to offset the course fees
Master Excel Dashboard Training Course Outlines:
Lesson 1: Creating Advanced Formulas
Topic A: Use Range Names in Formulas
Topic B: Use Specialized Functions
Lesson 2: Automating Workbook Functionality
Topic A: Apply Data Validation
Topic B: Work with Forms and Controls
Lesson 3: Applying Conditional Logic
Topic A: Use Lookup Functions
Topic B: Combine Functions
Lesson 4: Visualizing Data With Basic Charts
Topic A: Create Charts
Topic B: Modify and Format Charts
Lesson 5: Advanced Charting Techniques
Topic A: Use Advanced Chart Features
Topic B: Create Sparklines
Lesson 6: Analyzing Data With PivotTables, Slicers, And PivotCharts
Topic A: Create a PivotTable
Topic B: Analyze PivotTable Data
Topic C: Present Data with PivotCharts
Topic D: Filter Data by Using Slicers
FAQ’s for Microsoft Excel Dashboards Training Course
Who is this Excel Dashboards course suitable for?
This course is ideal for professionals, analysts, executives, and students who already have basic Excel skills and want to learn how to create interactive, visually appealing dashboards using advanced Excel tools.
Do I need advanced Excel knowledge to attend this course?
No advanced knowledge is required, but you should be comfortable with Excel fundamentals—such as creating formulas, using functions, and basic formatting.
What topics are covered in this course?
The course covers:
- Advanced formulas and functions
- Conditional logic
- Basic and advanced charting
- Data analysis with PivotTables and slicers
- Dashboard design principles
- Automating workbook functionality
Will I receive a certificate after completing the course?
Minimum 75% attendance is required in order to complete the course and receive the course completion certificate.
Do I need to bring my own laptop?
For in-person sessions, participants are encouraged to bring their own laptops with Microsoft Excel installed. If you don’t have access to one, please inform us in advance so arrangements can be made.
Can I use SkillsFuture Credits for this course?
Yes, SkillsFuture Credits can be used to offset the course fees for eligible Singaporeans.