3ADLE16: PERFORM ADVANCED SPREADSHEET FUNCTIONS (EXCEL) 2016 (24 HOURS)
PERFORM ADVANCED SPREADSHEET FUNCTIONS (EXCEL) 2016 (24 HOURS)
Course Duration
Who Should Attend
Individuals who have successfully reached ES-ICDL basic skills levels and wish to further enhance their expertise in Advanced Spreadsheets.
Course Overview
Bring your Spreadsheets skills to an expert level and be more confident, efficient and effective in using Spreadsheets.
Master the advanced functions of Spreadsheets applications to produce more sophisticated reports with deeper data analysis and complex mathematical calculations. With this, you will be able to draw out key insights from data and enhance your productivity and effectiveness at work.
Course Schedule
Next available schedule
Pre-requisites
** Kindly be informed that all trainees will have to take an Excel diagnostic test prior to registration.
(a) F2F Classes, these are the admission requirements.
- Have advance knowledge on Excel spreadsheet such as using Cells, Rows and Columns, Formulas and Functions, Formatting, Charts and preparing Outputs
- Be a proficient user of computer and computer software
- Be able to Speak, Listen, Read and Write English at WPL Level 4 or equivalent
- Be able to manipulate numbers at WPN Level 4 or equivalent
- Have keen interest to acquire new knowledge and skill
(b) Virtual Learning Classes, these are the admission requirements.
^Trainings will be conducted on Zoom platform, thus webcam and microphone are compulsory
Applicants need to:
- Have a Windows OS PC prior to class (Apple Mac OS is not applicable)
- Have advance knowledge on Excel spreadsheet such as using Cells, Rows and Columns, Formulas and Functions, Formatting, Charts and preparing Outputs
- Be a proficient user of computer and computer software
- Be able to Speak, Listen, Read and Write English at WPL Level 4 or equivalent
- Be able to manipulate numbers at WPN Level 4 or equivalent
- Have keen interest to acquire new knowledge and skill
Course Outline
Topic 1: Formatting
Worksheets
Topic 2: Functions and Formulas
Using Functions and Formulas
Topic 3: Charts
Creating Charts
Formatting Charts
Topic 4: Analysis
Using Tables
Sorting and Filtering
Scenarios
Topic 5: Validating and Auditing
Validating
Auditing
Topic 6: Enhancing Productivity
Naming Cells
Paste Special
Templates
Linking, Embedding and Importing
Automation
Topic 7: Collaborative Editing
Tracking and Reviewing
Security
Certificate Obtained and Conferred by
Successful trainees will receive the internationally recognised ICDL Certificate upon completion of the course. This certificate is administered by ICDL Singapore, a new initiative from ECDL Foundation.
This is a joint certification between SSG and ICDL Singapore
Additional Details
Medium of Instruction & Trainer
- Instructor Led Class
- Teacher: Student Ratio is 1: 24
Funding Information
SkillsFuture Funding:
- Participants must attend at least 75% of the course and complete the exam with a pass or competent result.
- Online applications are not applicable for companies applying for funding with Absentee Payroll.
For Company Registration:
- Customers who are applying for funding for trainee(s), please submit Training Grant applications in SkillsConnect website before registration.
- Training Grant number is to be submitted together with the registrations.
- For Training Grant application, please use the following reference code: CRS-Q-0030566-ES
- Payment for the course must be using company cheque or via GIRO.
Union Training Assistance Programme (UTAP):
- NTUC members enjoy UTAP* benefit of up to $250 each year when you sign up for courses with NTUC LearningHub.
* UTAP supports 50% of the course fees paid cap at $250 per year. You must be a union member throughout the course duration and at the time of claim. You must achieve a minimum of 75% attendance for each application and have sat for all prescribed examinations. Other terms and conditions apply.
Price
| Course Fee Payable | ||
| Individual Pricing | w/o GST | w GST |
| Course Fee | $500.00 | $535.00 |
| SkillsFuture Funding, 21 yrs old | $100 | $135.00 |
| SkillsFuture Funding, 40 yrs old | $50 | $85.00 |
| Corporate Pricing | ||
| Non-SME | w/o GST | w GST |
| Course Fee | $500.00 | $535.00 |
| SkillsFuture Funding, 21 yrs old | $100 | $135.00 |
| SkillsFuture Funding, 40 yrs old | $50 | $85.00 |
| SME | w/o GST | w GST |
| Course Fee | $500.00 | $535.00 |
| Enhanced Training Support for SMEs Companies (90%)** | $50 | $85.00 |
Prices do not include pre & post assessment fees and subject to GST and other LHUB miscellaneous fees
Note
SkillsFuture Funding, 21 yrs old: Applicable to Singapore Citizen/PR
SkillsFuture Funding, 40 yrs old : Applicable to Singapore Citizen ONLY
Please note that prices are subject to changes.
| Batch ID | Course Period | Course Title | Funding Available |
Duration (Hours) |
Session (Hours) |
Venue | Available Seats |
Online Payment |
|---|
What Others Also Enrolled In
PERFORM ADVANCED SPREADSHEET FUNCTIONS (EXCEL) 2019 (24 HOURS)
View detail
PERFORM SPREADSHEET FUNCTIONS (EXCEL) 2019 (24 HOURS)
View detail
PERFORM ESSENTIAL ONLINE FUNCTIONS (16 HRS) (ICDL CERTIFICATION MODULE: ONLINE ESSENTIALS)
View detail
%202016.png/9988f507-5767-faf5-c085-a6e1643076c9/)
PERFORM ADVANCED SPREADSHEET FUNCTIONS (EXCEL) 2016 (24 HOURS)
View detail
PERFORM ADVANCED PRESENTATION FUNCTIONS (POWERPOINT) 2019 (24 HOURS)
View detail
PERFORM ADVANCED WORD PROCESSING FUNCTIONS (WORD) 2016 (24 HOURS)
View detail%202019.png/e6cab8d2-ec5d-dcc7-bf84-72770f1eabd3/)
PERFORM ADVANCED WORD PROCESSING FUNCTIONS (WORD) 2019 (24 HOURS)
View detail
PERFORM ONLINE COLLABORATION (24 HRS) (ICDL CERTIFICATION MODULE: ONLINE COLLABORATION)
View detail
