Pantone-01.png)
CoC in Data Analytics Using Microsoft Excel
Campus
ITE College West
Course type
Part-time
Industry
Administrative Support
Business
Data Analytics
Participants will acquire essential skills in data cleaning, analysis, and visualisation using Microsoft Excel. You will learn to extract insights for management reporting and decision-making.
Course duration: 16 hours
Participants will acquire essential skills in data cleaning, analysis, and visualisation using Microsoft Excel. You will learn to extract insights for management reporting and decision-making. You will engage in hands-on exercises, real-world examples and interactive activities to enhance your proficiency.
What you'll learn
Understand the basics of data analytics and its importance
Perform data exploration, consolidation, and transformation in Excel
Design and develop data visualisations to support decision-making
Create and analyse performance reports
Automate repetitive tasks using Excel VBA
Entry requirements
Participants should have basic computer skills and familiarity with Microsoft Excel.
Fees
Fee for this course can be paid using SkillsFuture Credits.
STEP* will be used to administer all ITE Continuing Education & Training (CET) courses starting from 1 April 2024 onwards. For first-time users of STEP, please register and sign in here.
*STEP – Skills Training & Enhancement Portal, the new one-stop learning portal to manage all courses and learning needs across the 5 polytechnics and ITE.
Want to find out more about our courses?