Non-Certifiable

Effective Data Analysis Skills using MS Excel

course details

Duration and Time

Training Time

9am-6pm

Course Duration

8 HRS

Course Information

Course Reference Number

Funding Validity Period

Mode of Training

Classroom

COURSE OVERVIEW

At the end of the course, participants will be able to use Excel tools effectively to produce spreadsheet solutions.

At the end of the course, participants will be able to use Excel tools effectively to produce spreadsheet solutions.

USING EXCEL TABLE
  • Overview of Excel tables
  • Format as Excel Table
  • Managing data in an Excel table
  • Sorting and filtering
  • Formatting table data
  • Inserting and deleting table rows and columns
  • Using a calculated column
  • Displaying and calculating table data totals
CONDITIONAL FORMATTING
  • Overview of Conditional Formatting
  • Creating a conditional format based on cell content
  • Creating a conditional format using formula to determine which cell to format
  • Editing the Conditional Formatting Rules
  • Deleting the Conditional Formatting Rules
PERFORM WHAT-IF ANALYSIS
  • Using Scenarios to consider many different variables
  • Using Goal Seekto find out how to get a desired result
  • Use Data Tables to see the effects of one or two variables on a formula
EXCEL ADD-INS
  • Project backward for more variables by using the Solver Add-in
  • Using Regression Analysis Tool in the Analysis ToolPak Add-in

This course is aimed at participants who need to manage and perform statistical analysis of data using Microsoft Excel.

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) $300.00 $27.00 $210.00 (70% off course fee) $117.00
Non Small Medium Enterprises $300.00 $27.00 $150.00 (50% off course fee) $177.00
Singaporean Employees aged 40 years and above $300.00 $27.00 $210.00 (70% off course fee) $117.00

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) $300.00 $27.00 $210.00 (70% off course fee) $117.00
Singapore Citizens (21 to 39 years old) & Permanent Residents (21 years old and above) $300.00 $27.00 $150.00 (50% off course fee) $177.00

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