Fundamental Data Analysis using Excel

Link to Home page
PACE Home
Courses
Course Catalogue
Fundamental Data Analysis using Excel

Overview

Course Date:
17 Mar 2025 to 18 Mar 2025
Registration Period:
07 Feb 2025 to 20 Feb 2025
Duration/Frequency:
16 Hours | Monday & Tuesday (9 am - 6 pm)
Mode of Training:
Classroom
Venue:
Singapore Polytechnic
Funding:
-

Course Objective

Ever wonder how you can generate relevant information and convert it to business insights, using Microsoft Excel? Well, take this course and master this powerful tool, increasing your job efficiency with enhance Data Analysis skills. Designed for analysing data in Business applications, you will learn how to digitally import it from various sources, merge and process data for visual presentation, as well as build predictive models to support complex decision-making.

Course Outline

By the end of the course, participants will be able to:

Understand how to apply commonly used statistical and lookup functions
Gather data and organise it for Business analysis
Generate and interpret charts
Build dashboards using PivotTables and PivotCharts
Use Excel What-If Analysis and Data Analysis tools for generating different Business Development scenarios and aid decision making

Topics to be covered

Collecting and Managing Business Data
Constructing Charts
Building Dashboard using PivotTables and PivotCharts
Decision Making using What-If Analysis

Hands-On Practice
Practicing a list of tasks that help hone data analysis skills in generating required information

Minimum Requirements

Must have basic computer skills, and prior knowledge of Microsoft Excel is advantageous (though not necessary)

Certification / Accreditation

• Certificate of Attendance (electronic Certificate will be issued)
A Certificate of Attendance will be awarded to participants who meet at least 75% attendance rate

• Certificate of Completion (electronic Certificate will be issued)
A Certificate of Completion will be awarded to participants who pass the assessment and meet at least 75% attendance rate

Suitable for

Public Service Officers, Managers, Administrative Officers, Executives, and general public planning to use Excel for performing Data Analysis in the workplace