fbpx Effective Data Analysis Skills using MS Excel | Eagle Infotech Consultants Skip to main content

Effective Data Analysis Skills using MS Excel

Course Duration
8
Course Reference Number
CRS-N-0026775
Funding Validity Period
02 Jul 2019 To 30 Jun 2020
Mode of Training
Classroom
 

Course Objectives

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

Target Audience

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

Course Outline

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
Full Fee GST Nett Fee after Funding (Incl. GST)
SME/MCES Non-SME/Normal WTS
$300
$21.00
$321.00
-
-

MCES: Singaporean age 40 and above

Normal: Singaporean/PR age 21 and above

WTS: Singaporean age 35 and above and earning $2,000 or below per month

 

SME: Singapore registered companies with

(i) at least 30% local sharing AND

(ii) group annual sales less than or equal to $100 million OR group employment size less than or equal to 200 people