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 the SkillsFuture website or contact the training provider directly.
More Courses from Republic Polytechnic
3D (three-dimensional) Modelling and Animation introduces students to the fundamentals of 3D modelli...
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...