Leveraging Functions and Formulas using MS Excel (8 hrs)
Course Code: TGS-2017500062 | Broad-based Funding
*Classroom-based Learning*
At the end of the course, participants will be able to use Excel Functions and Formulas more effectively.
- Able to use Excel Functions and Formulas.
- Using SUM, AVERAGE, MAX, MIN, COUNT, COUNTA Functions
- Using Date and Time Functions: TODAY, NOW, DAY, MONTH, YEAR, DATE, TIME
- Using Mathematical Functions: ROUNDDOWN, ROUNDUP, SUMIF
- Using Statistical Functions: COUNTIF, COUNTBLANK, RANK
- Using Text Functions: LEFT, RIGHT, MID, TRIM, CONCATENATE
- Using Lookup Functions: VLOOKUP, HLOOKUP
- Use Database Functions: DSUM, DMIN, DMAX, DCOUNT, DAVERAGE
- Using Logical Function: IF, NESTED-IF, ISERROR, OR, AND
- Understanding Cell References in Formulas: Relative, Absolute, Mixed Reference
- Using a 3-D reference within a SUM Function
- Using TRANSPOSE Function
- Data Validation: Set, edit validation criteria for data entry in a cell range like: whole number, decimal, list, date, time
- Handling Error displays in Formulas:#######, #REF!, #NAME?, #DIV/0!, #VALUE!
- Auditing Functions: Trace precedent, dependent cells. Identify cells with missing dependents, Error Checking for Circular Reference, Watch Window
Lectures, demonstration and hands-on activities designed to provide practical experiences with skills being taught.
This course is suitable for those who need to utilise the various pre-set functions in Microsoft Excel to create formulas and perform calculations.
Prerequisites
Participants are assumed to:
- Have working knowledge of Microsoft Excel
- Be able to read, write, speak and listen to English at secondary school level
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)
- Able to use Excel Functions and Formulas.
- Using SUM, AVERAGE, MAX, MIN, COUNT, COUNTA Functions
- Using Date and Time Functions: TODAY, NOW, DAY, MONTH, YEAR, DATE, TIME
- Using Mathematical Functions: ROUNDDOWN, ROUNDUP, SUMIF
- Using Statistical Functions: COUNTIF, COUNTBLANK, RANK
- Using Text Functions: LEFT, RIGHT, MID, TRIM, CONCATENATE
- Using Lookup Functions: VLOOKUP, HLOOKUP
- Use Database Functions: DSUM, DMIN, DMAX, DCOUNT, DAVERAGE
- Using Logical Function: IF, NESTED-IF, ISERROR, OR, AND
- Understanding Cell References in Formulas: Relative, Absolute, Mixed Reference
- Using a 3-D reference within a SUM Function
- Using TRANSPOSE Function
- Data Validation: Set, edit validation criteria for data entry in a cell range like: whole number, decimal, list, date, time
- Handling Error displays in Formulas:#######, #REF!, #NAME?, #DIV/0!, #VALUE!
- Auditing Functions: Trace precedent, dependent cells. Identify cells with missing dependents, Error Checking for Circular Reference, Watch Window
Lectures, demonstration and hands-on activities designed to provide practical experiences with skills being taught.
This course is suitable for those who need to utilise the various pre-set functions in Microsoft Excel to create formulas and perform calculations.
Prerequisites
Participants are assumed to:
- Have working knowledge of Microsoft Excel
- Be able to read, write, speak and listen to English at secondary school level
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 19, 2024 - January 19, 2024 (9:00 am - 6:00 pm)
[Classroom]
|
Closed |
February 16, 2024 - February 16, 2024 (9:00 am - 6:00 pm)
[Classroom]
|
Closed |
March 15, 2024 - March 15, 2024 (9:00 am - 6:00 pm)
[Classroom]
|
Closed |
April 1, 2024 - April 1, 2024 (9:00 am - 6:00 pm)
[Classroom]
|
Closed |
May 31, 2024 - May 31, 2024 (9:00 am - 6:00 pm)
[Classroom]
|
Register Now |
June 18, 2024 - June 18, 2024 (9:00 am - 6:00 pm)
[Classroom]
|
Register Now |