Fundamental Data Analysis using Excel

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

Overview

Course Date:
25 Mar 2024 to 26 Mar 2024
Registration Period:
14 Feb 2024 to 01 Mar 2024
Duration/Frequency:
15 hours
Mode of Training:
Classroom
Venue:
Singapore Polytechnic
Funding:
Eligible for SkillsFuture Credit

Course Objective

Have you ever wondered how you could generate relevant information and gain insights from your data using Excel? Become an Excel power user and increase your job efficiency by equipping yourself with emerging data analysis skills.

This fundamental data analysis course is designed to equip you with relevant Excel skills for the purpose of analysing data in business applications. You will learn how to import data from various sources, merge data and organize them for visual presentation, and analyse the data to gain insights to support decision making.

By the end of the course, you will have:

An understanding of how to apply most commonly used statistical and lookup functions.
The ability to gather data and organize the data for analysis in business. Knowledge in chart generation and interpretation.
The ability to build dashboards using PivotTables and PivotCharts.
Skills in using Excel What-If Analysis and Data Analysis tools for generating different scenarios of business environment and aiding decision making.

Course Outline

Collecting and Managing Business Data

- Getting external data from various sources.
- Preparing data using text manipulation.
- Using statistical functions and formulae.
- Extracting data with lookup functions.
- Formatting and conditional formatting.
- Tapping into real data from the Internet for business analysis

Constructing Charts

- Plotting different types of charts.
- Customising charts for presentations.
- Using Sparklines.

Building Dashboard using PivotTables and PivotCharts

- Understanding and use of Excel tables.
- Creating PivotTables to analyze worksheet data.
- Creating dashboards using PivotCharts for visual presentation.
- Adding Slicers and Timelines for interactive display.
- Introducing multi-table PivotTables and data model.

Decision making using What-If Analysis

- Building Data Tables.
- Building charts from Data Tables.
- Using Scenario Manager for reporting different scenarios.
- Exploring Data Analysis tools.

Hands-On Practice

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

Minimum Requirements

Basic computer skills. Prior knowledge of Microsoft Excel, although advantageous, is 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 Officer, Managers, Administrative Officers, Executives and general public

Course Fees

The course fees payable above are inclusive of 9% GST rate.

Applicants/Eligibility	SkillsFuture Funding	GST	Subsidised Fee (after GST)
Singapore Citizens aged 40 and above	$333.00	$9.99	$46.99
Singapore Citizens aged below 40	$259.00	$9.99	$120.99
Singapore Permanent Residents and LTVP+ Holders	$259.00	$9.99	$120.99
SME-sponsored Singapore Citizens, Permanent Residents and LTVP+ Holders	$333.00	$9.99	$46.99
Others (Full fees payable)	$0.00	$33.30	$403.30

Application Procedure

1. For self-sponsored applicant, please click on the “Register” button to apply for the course. You will be directed to STEP portal to manage all your course activities. Please note that you will be prompted to sign in with Singpass/Student ID.

2. For company-sponsored applicant, please approach your company's Human Resource (HR) team to put in the application through the company portal using CorpPass. You may only apply after receiving the registration link from your company's HR.

3. Your application does not guarantee acceptance into the course. Your acceptance into the course is dependent on meeting the course requirements and course vacancy.

4. All successful applicants will be notified with a letter of confirmation via email.

6. PACE Academy course schedules, including course trainer, course fees and course availability are subject to change.

7. PACE Academy reserves the right to cancel or postpone any course at short notice; & at its absolute discretion without assigning any reason for such cancellation/postponements. In the event that the applicant’s chosen course is cancelled prior to its commencement, PACE Academy will make a full refund of course fees already paid by the applicant.

8. The data provided to Singapore Polytechnic will be kept strictly confidential and will be used for the purpose of course administration. The data may be passed on to the relevant organisations that require the information related to the course.