Effective Data Analysis Skills using MS Excel

Effective Data Analysis Skills using MS Excel (8 hrs)

Course Code: TGS-2018500058 | Broad-based Funding

*Classroom-based Learning*

This course aims to equip participants with the necessary skills and knowledge to use Excel tools effectively to produce spreadsheet solutions.

  • Learn to manage data using Excel
  • Able to perform statistical analysis of data using Excel

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

The course will be conducted through interactive training methods.

This course is suitable for those who need to manage and perform statistical analysis of data using Microsoft Excel.

Duration : 1 day (8 hrs)
Time : 9:00am to 6:00pm

With effect from 1 Jan 2024

TypeIndividuals
Employer-sponsored Singapore Citizens and Permanent Residents
Type of Funding
SkillsFuture Funding (Broad-Based Funding for Non-certifiable courses)
Course Fee$300.00
Less: SkillsFuture Funding $16.00
Total Nett Fee$284.00
Add: GST @ 9% of Course Fee$27.00
Total Fee Payable$311.00

Funding valid till 31 Dec 2024

* Please click HERE for detailed information on general terms and conditions.

* Please click HERE for detailed information on course fee funding schemes, SkillsFuture credit, and complete listing of funded courses. This course is eligible for use of SkillsFuture credit.

(A course in partnership with James Cook Institute Pte. Ltd. [formerly known as Eagle Infotech] UEN198802365N)

Key Benefits
  • Learn to manage data using Excel
  • Able to perform statistical analysis of data using Excel
Course Contents

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 Seek to 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
Learning Methodology

The course will be conducted through interactive training methods.

Who Should Attend

This course is suitable for those who need to manage and perform statistical analysis of data using Microsoft Excel.

Course Details

Duration : 1 day (8 hrs)
Time : 9:00am to 6:00pm

With effect from 1 Jan 2024

TypeIndividuals
Employer-sponsored Singapore Citizens and Permanent Residents
Type of Funding
SkillsFuture Funding (Broad-Based Funding for Non-certifiable courses)
Course Fee$300.00
Less: SkillsFuture Funding $16.00
Total Nett Fee$284.00
Add: GST @ 9% of Course Fee$27.00
Total Fee Payable$311.00

Funding valid till 31 Dec 2024

* Please click HERE for detailed information on general terms and conditions.

* Please click HERE for detailed information on course fee funding schemes, SkillsFuture credit, and complete listing of funded courses. This course is eligible for use of SkillsFuture credit.

(A course in partnership with James Cook Institute Pte. Ltd. [formerly known as Eagle Infotech] UEN198802365N)

Course Application

Details Registration
January 24, 2024 - January 24, 2024 (9:00 am - 6:00 pm)
[Classroom]
Closed
February 5, 2024 - February 5, 2024 (9:00 am - 6:00 pm)
[Classroom]
Closed
March 25, 2024 - March 25, 2024 (9:00 am - 6:00 pm)
[Classroom]
Closed
April 22, 2024 - April 22, 2024 (9:00 am - 6:00 pm)
[Classroom]
Closed
May 27, 2024 - May 27, 2024 (9:00 am - 6:00 pm)
[Classroom]
Register Now
June 3, 2024 - June 3, 2024 (9:00 am - 6:00 pm)
[Classroom]
Register Now