UEN No.: 198802365N
UEN No.: 198802365N
course details
Duration and Time
Training Time
9am - 6pm
Course Duration
24 HRS
Course Information
Course Reference Number
TGS-2023039918
Funding Validity Period
Mode of Training
Classroom
COURSE OVERVIEW
This module, in conjunction with CoPilot, sets out advanced skills and knowledge that can be used to perform complex mathematical and statistical calculations, to produce high quality management information, to present that information in sophisticated reports, and to use the advanced features in a spreadsheet application to improve productivity.
*This course includes an online assessment (ICDL).
By the end of this course, learners will be able to:
• Apply advanced formatting options such as conditional formatting and customised number formatting and handle worksheets
• Use functions such as those associated with logical, statistical, financial and mathematical operations
• Create charts and apply advanced chart formatting
• Work with tables and lists to analyse, filter and sort data. Create and use scenarios
• Validate and audit spreadsheet data
• Enhance productivity by working with named cell ranges and macros
• Use linking, embedding and importing features to integrate data
• Compare and merge spreadsheets. Apply spreadsheet security features
This training is relevant to anyone with a basic working knowledge of using Microsoft Excel who need to upgrade their skills and knowledge to better manage large sets of data, efficiently and effectively analyse these data sets and present findings in an impactful manner to benefit from data-based decision-making.
Download the PDF below for a summary of the course outline.
COURSE FEES
Company Sponsored
| Funding Type | Full Fee | 9% GST (on full course fee) | Funding Amount | Nett Fee Payable (incl. GST) |
|---|---|---|---|---|
| Small Medium Enterprises (SMEs) | $720.00 | $64.80 | $504.00 (70% off course fee) | $280.80 |
| Non Small Medium Enterprises | $720.00 | $64.80 | $360.00 (50% off course fee) | $424.80 |
| Singaporean Employees aged 40 years and above | $720.00 | $64.80 | $504.00 (70% off course fee) | $280.80 |
Course Fee Funding:
SME: 70% of course fee
Non-SME: 50% of course fee
Non-SME(MCES): 70% of course fee
$4.50 per training hour capped at $100,000 per enterprise per calendar year
Self-Sponsored
| Funding Type | Full Fee | 9% GST (on full course fee) | Funding Amount | Nett Fee Payable (incl. GST) |
|---|---|---|---|---|
| Singapore Citizens (40 years and above) | $720.00 | $64.80 | $504.00 (70% off course fee) | $280.80 |
| Singapore Citizens (21 to 39 years old) & Permanent Residents (21 years old and above) | $720.00 | $64.80 | $360.00 (50% off course fee) | $424.80 |
Course Fee Funding:
MCES: 70% of course fee
Normal: 50% of course fee
Select a date below
There is no course available now
Related Courses
Have an enquiry? Feel free to connect via any of the channels below.
Leave a message
Chat on WhatsApp at
+65 8767 0614
Give us a call at
+65 6737 5761
Offering an extensive range of courses conducted by our pool of accredited trainers, we take pride in providing training solutions to meet your learning and professional objectives.
Connect With Us
