Create an Interactive Dashboard in a Day
Training Provider: Republic Polytechnic
Course Reference: TGS-2021005423
S$81
Original: S$270
Save S$189
About This Course
Using use cases, participants will be able to:
• Apply statistical, logical, string and date functions to do data manipulation, such as Vlookup, Index, Match, If/Ifs, IsNA/IsError, And/Or, CountIf/CountIfs, SumIf/SumIfs, etc.
• Use Power Query to efficiently clean and process data.
• Create Pivot Table and Pivot Charts to analyse large amount of data.
• Design and build a simple Dashboard to present data in a professional manner.
• Experience the basic features of Power Pivot and Power View.
What You'll Learn
This is a 1-day hands-on course designed to empower participants with basic-to-advanced Excel knowledge and skills. Upon the completion of the course, participants will be able to prepare a professional dashboard presentation using Excel.
Entry Requirements
Participants should have basic IT literacy and be proficient in Microsoft Excel.
Course Details
Back to All Courses
Note: To apply for this course, visit or contact the training provider directly.
More Courses from Republic Polytechnic
The application of Computer Vision in object identification and classification is well-established s...
The course equips learners on the skills of qualitative market research such as facilitating focus g...
The course equips learners on the skills of qualitative market research such as facilitating focus g...