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
Type | Individuals | |||
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)
- 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
Type | Individuals | |||
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 |