Effective Data Analysis using Excel

Funding Validity Period

17 April 2027

16 April 2027

Course Overview

This course will equip learners with data analysis skills using Excel by applying the various formulae
and functions available in Excel as well as using Power Pivot to connect to different and multiple
data sources for statistical analysis.

Skills Acquired

By the end of this course, learners will be able to:

Apply principles of data modelling and visualization to create data models to identify and predict trends and patterns.
Use data science techniques to perform data analysis on data sets.
Apply data protection and legal guidelines to support the creation of business insight reports
Apply DAX language to summarize data to provide business insights from data source.
Apply statistical techniques and formulas to produce analytical dashboards and insight reports.
Join multiple tables using unions to extract data analysis aligned to the domain context.
Create clean required dataset with functions and formulas to visualize data.

Learning Modules

Learning Unit 1 – Understanding Data Modelling and Visualization to Perform Data Analysis

Create Data Models using Power Pivot
Create Pivot Tables and Pivot Charts for Forecasting and Recognizing Patterns and Trends.

Learning Unit 2 – Using Excel Functions to Apply Techniques on Data Sets for Data Analysis

Introduction to Advanced Excel Functions and Features for Data Analysis

Learning Unit 3 – Using Power Pivot for Data Modelling and Applying Data Integrity

Using Power Pivot Models to Create Business Insight Reports
Applying Data Protection Rules in Excel

Learning Unit 4 – Using DAX for Analysis to Provide Business Insights

Using DAX to summarize data for analysis and business insights

Learning Unit 5 – Using Statistical Techniques and Data Analysis Tool Pak for creation of Dashboard reports

Introduction to Statistical Formulas and Techniques for Dashboard Reports
Data Analysis Tool Pak for Business Insight Reports

Learning Unit 6 – Using Excel Functions and Queries to Extract Data for Data Analysis

Joining Multiple Tables to Extract Data for Data Analysis and Visualization

Learning Unit 7 – Transforming Data for Data Analysis using Excel Functions and Formulae

Data cleaning and validation of Required Dataset for Visuals

Create Data Models using Power Pivot
Create Pivot Tables and Pivot Charts for Forecasting and Recognizing Patterns and Trends.

Introduction to Advanced Excel Functions and Features for Data Analysis

Using Power Pivot Models to Create Business Insight Reports
Applying Data Protection Rules in Excel

Using DAX to summarize data for analysis and business insights

Introduction to Statistical Formulas and Techniques for Dashboard Reports
Data Analysis Tool Pak for Business Insight Reports

Joining Multiple Tables to Extract Data for Data Analysis and Visualization

Data cleaning and validation of Required Dataset for Visuals

Who is this course is for

This training is relevant to PMETs who are aspiring to move away from just creating spreadsheets onto a data analytics scale using a tool that they are relatively familiar with.

Academic prerequisites

Learners are required to have basic excel knowledge

Course Fees

Company Sponsored

Fees	Small Medium Enterprises (SMEs)	Non Small Medium Enterprises	Singaporean Employees aged 40 years and above
Full Fee	$580.00	$580.00	$580.00
9% GST (on full course fee)	$52.20	$52.20	$52.20
Funding Amount	$406.00 (70% off course fee)	$290.00 (50% off course fee)	$406.00 (70% off course fee)
Nett Fee Payable (incl. GST)	$226.20	$342.20	$226.20

SME: Company registered or incorporated in Singapore AND employment size of not more than 200 or with annual sales turnover of not more than $100 million
Non-SME (MCES): Employee is Singaporean aged 40 years and above

Course Fee Funding:
SME: 70% of course fee
Non-SME: 50% of course fee
Non-SME(MCES): 70% of course fee

Eligible for Absentee Payroll Funding

$4.50 per training hour capped at $100,000 per enterprise per calendar year

Eligible for SkillsFuture Enterprise Credit (SFEC)

Self Sponsored

Fees	Singapore Citizens (40 years and above)	Singapore Citizens (21 to 39 years old) & Permanent Residents (21 years old and above)
Full Fee	$580.00	$580.00
9% GST (on full course fee)	$52.20	$52.20
Funding Amount	$406.00 (70% off course fee)	$290.00 (50% off course fee)
Nett Fee Payable (incl. GST)	$226.20	$342.20

MCES: Singaporean aged 40 years and above
Normal: Singaporean / PR aged 21 years and above

Course Fee Funding:
MCES: 70% of course fee
Normal: 50% of course fee

Eligible for UTAP funding
Eligible for SkillsFuture Credit
Eligible for PSEA Funds