UEN No.: 198802365N

Effective Data Analysis Skills using MS Excel

COURSE details

Course Duration

8 HRS

Course Reference Number

TGS-2018500058

Funding Validity Period

02 Jul 2019 To
31 Dec 2024

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

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

COURSE FEES


Company Sponsored

Full Fee GST Broad-based Funding
($2 per training hour)
Nett Fee Payable (incl. GST)
$300 $27 $16 $311

Self-Sponsored

Full Fee GST Nett Fee Payable (incl. GST)
$300 $27 $327

REGISTER TODAY

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

Related Courses

IT

8 HRS

Non-Certifiable

IT

8 HRS

Non-Certifiable

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