Level Up Your Excel Skills
TGS-2022017320
Course Overview
This course sets out advanced skills that can be used to perform complex mathematical and statistical calculations, to produce high quality management information and to use the advance features in a spreadsheet application to improve productivity
Training Type
Full Time
Who Should Attend
The job role(s)/occupations that this unit would be relevant for learners who are required to prepare data and analyse data using Microsoft Excel at an advanced level. The competencies covered in this course would be relevant to all industries and to organisations of all sizes.
Course Duration
2 Days
Total Training Duration (Hour)
17
Course Outline
Learning Unit 1 – Gather Data
- Import data
- Data consolidation
- Linking to cells, range, between applications, break links
Learning Unit 2 – Format & Manage Worksheets
- Custom number formats
- Data validation
- Worksheet grouping
- Paste special options
Learning Unit 3 – Advanced Data Handling
- Range name
- Go To special
Learning Unit 4 – Data Analysis
- Using Quick Analysis
- Conditional formatting
- Advanced sorting
- Advanced filters
- PivotTable and PivotChart
Learning Unit 5 – Advanced Excel Functions
- Cell referencing
- Logical functions
- Nested functions
- Mathematical functions
- Date functions
- Text functions
- Lookup & reference functions
- Database functions
- Formula auditing
Learning Unit 6 – Collaborative Editing
- Track changes
- Share workbook
- Compare & merge
Course Learning Outcome
By the end of this course, learners will be able to:
- Import and organise data sources
- Prepare worksheets for data entry and calculations
- Manage data and navigate cells effectively
- Perform efficient analyse of data
- Perform advanced calculations with Excel functions
- Collaborate and review workbooks
Pre-requisites
- Workforce Skills Qualifications (“ES WSQ”) Workplace Literacy (“WPL”) level 5
- Be able to read and write English at a proficiency level equivalent to ES WSQ WPL level 5
- Be able to manipulate numbers at a proficiency level equivalent to ES WSQ Workplace Numeracy (“WPN”) level 5
- Learners to have minimum GCE ‘O’ level or ITE certificate education
- Learner should have at least 1 year’s working experience in any industry
- Learners must be able to operate a personal computer, use keyboard and mouse
- Learners are expected to have basic knowledge of Microsoft Excel
Funding Information
02 Dec 2022 To 01 Dec 2026
Course Pre-Requisites
Price
| Course Fee Payable | ||
|---|---|---|
| Original Fee | Before GST | With GST (9%) |
| Course Fee | $480.00 | $523.20 |
| Individual Pricing (Fee payable to Training Provider) | Before GST | With GST (9%) |
| Individual (Baseline) | $240.00 | $283.20 |
| Individual (MCES) | $144.00 | $187.20 |
| Corporate Pricing (Fee payable to Training Provider) | ||
| SME | Before GST | With GST (9%) |
| Corporate (SME) | $144.00 | $187.20 |
| Non-SME | Before GST | With GST (9%) |
| Corporate (Non-SME, Baseline) | $240.00 | $283.20 |
| Corporate (Non-SME, MCES) | $144.00 | $187.20 |
Company Sponsored Funding Types
- SME
- Company registered or incorporated in Singapore AND employment size of not more than 200 or with annual sales turnover of not more than $100 million
- 70% of course fee funded
- Non-SME (Baseline)
- Non-SME companies, employee is Singaporean or PR aged below 40
- 50% of course fee funded
- Non-SME (MCES)
- Non-SME companies, employee is Singaporean aged 40 years and above
- 70% of course fee funded
Absentee Payroll Funding for Companies:
- $4.50 per training hour capped at $100,000 per enterprise per calendar year
------------------------------------------------------------------------
Self-sponsored Funding Types
- MCES
- Singaporean aged 40 years and above
- 70% of course fee funded
- Normal
- Singaporean / PR aged 21 years and above
- 50% of course fee funded
