WSQ

Effective Data Analysis using Excel

course details

Duration and Time

Training Time

9.00am - 6pm

Course Duration

16 HRS

Course Information

Course Reference Number

TGS-2023020187

Funding Validity Period

17 Apr 2023 To
16 Apr 2025

Mode of Training

Classroom

COURSE OVERVIEW

This course provides practical data analysis skills using Excel, teaching learners to utilise formulas, functions, and Power Pivot to connect to multiple data sources. Key areas covered include data modelling and visualisation, DAX language for data summarisation, statistical techniques for dashboard creation, and data protection guidelines. Learners will also master techniques for cleaning datasets and performing comprehensive data analysis

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 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

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.

Learners are required to have basic excel knowledge

Course Outline

Download the PDF below for a summary of the course outline.

COURSE FEES

Company Sponsored

Funding Type Full Fee 9% GST (on full course fee) Funding Amount Nett Fee Payable (incl. GST)
Small Medium Enterprises (SMEs) $480.00 $43.20 $336.00 (70% off course fee) $187.20
Non Small Medium Enterprises $480.00 $43.20 $240.00 (50% off course fee) $283.20
Singaporean Employees aged 40 years and above $480.00 $43.20 $336.00 (70% off course fee) $187.20

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

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

Self-Sponsored

Funding Type Full Fee 9% GST (on full course fee) Funding Amount Nett Fee Payable (incl. GST)
Singapore Citizens (40 years and above) $480.00 $43.20 $336.00 (70% off course fee) $187.20
Singapore Citizens (21 to 39 years old) & Permanent Residents (21 years old and above) $480.00 $43.20 $240.00 (50% off course fee) $283.20

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

REGISTER TODAY

Looking at in-house training or have an enquiry? Contact us!

Related Courses

IT

24 HRS

WSQ

IT

24 HRS

WSQ

IT

8 HRS

Non-Certifiable

GET IN TOUCH WITH US

Have an enquiry? Feel free to connect via any of the channels below.

enquiry form

Leave a message

WhatSAPP

Chat on WhatsApp at
+65 8767 0614

Training hotline

Give us a call at
+65 6737 5761

SHARE THIS COURSE
Main Category
IT COURSES
Generative AI Series
SOFT SKILLS COURSES
COURSE MONTH
Certification
COURSE LEVEL
Course Duration