Using Microsoft (MS) Excel for Data Analysis
Training Provider: Ngee Ann Polytechnic
Course Reference: TGS-2025060994
S$258
Original: S$860
Save S$602
About This Course
This course is designed to equip participants with the essential skills to analyse and present data effectively using Microsoft (MS) Excel. Participants will be introduced to the fundamentals of workbook navigation, formatting, and simple functions, before progressing to data cleaning, pivot tables and visualisation techniques.
What You'll Learn
At the end of the course, participants will be able to:
1. Navigate Microsoft (MS) Excel efficiently and format the sheets so that they are neat,
consistent, and easy to read.
2. Use essential formulas (such as sum, average, if) to answer business questions.
3. Clean and prepare data using sorting, filtering, duplicate removal, and validation.
4. Build pivot table to summarise, group and slice data quickly.
5. Create clear and meaningful charts.
1. Navigate Microsoft (MS) Excel efficiently and format the sheets so that they are neat,
consistent, and easy to read.
2. Use essential formulas (such as sum, average, if) to answer business questions.
3. Clean and prepare data using sorting, filtering, duplicate removal, and validation.
4. Build pivot table to summarise, group and slice data quickly.
5. Create clear and meaningful charts.
Entry Requirements
Basic computer literacy
Course Details
Back to All Courses
Note: To apply for this course, visit or contact the training provider directly.
More Courses from Ngee Ann Polytechnic
The AD Penetration Testing module provides a comprehensive exploration of vulnerabilities in network...
This is the core business analysis module of the programme, where learners develop the skills to tra...
The capstone module brings together all skills developed across Modules 1 to 4, challenging learners...