PERFORM ADVANCED SPREADSHEET FUNCTIONS (EXCEL) 2019 (24 HOURS) (SYNCHRONOUS E-LEARNING)

PERFORM ADVANCED SPREADSHEET FUNCTIONS (EXCEL) 2019 (24 HOURS) (SYNCHRONOUS E-LEARNING)

POPULAR Funded
Course Duration
24.0 hr(s)
Mode of Assessment

There will be a compulsory ICDL Certification Online Assessment for this course.

Who Should Attend

Individuals who have successfully completed/reached ICDL basic skills levels and wish to further enhance their expertise in Advanced Spreadsheet Functions.

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.

This module sets out advanced skills that can be used to produce sophisticated reports, to perform complex mathematical and statistical calculations, and to improve productivity using a spreadsheet application.

Course Schedule

Next available schedule

Course Objectives

Upon completion of this course, you will be able to:

  • Apply advanced formatting options such as conditional formatting and customized 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

** 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

1. Formatting

  • Cells
  • Worksheets

2. Formulas and Functions

  • Using Formulas and Functions

3. Charts

  • Creating Charts
  • Formatting Charts

4. Analysis

  • Using Tables
  • Sorting and Filtering
  • Scenarios

5. Validating and Auditing

  • Validating
  • Auditing

6. Enhancing Productivity

  • Naming Cells
  • Paste Special
  • Linking, Embedding and Importing
  • Automation

7. Collaborative Editing

  • Reviewing and 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.

Additional Details

Price:

For Classes commencing until 31st Dec 2021

 

Individual Sponsored

Company Sponsored

Non-SME

SME

Before GST

With GST

Before GST

With GST

Before GST

With GST

Full Course Fee (For International Students)

$500.00 

$535.00  

$500.00 

$535.00  

$500.00 

$535.00  

For Singapore Citizens and PRs

 $100.00

$135.00 

 $100.00

$135.00 

 $50.00

$85.00 

For Singapore Citizens aged 40 years and above

 $50.00

$85.00 

 $50.00

$85.00 

 $50.00

$85.00 

 

For Classes commencing on or after 1st Jan 2022

 

Individual Sponsored

Company Sponsored

 

Non-SME

SME

Before GST

With GST

Before GST

With GST

Before GST

With GST

For International Students (Full Course Fee)

$500.00 

$535.00  

$500.00 

$535.00  

$500.00 

$535.00  

For Singapore Citizens and PRs

$250.00 

$285.00 

$250.00 

$285.00 

$150.00 

$185.00 

For Singapore Citizens aged 40 years and above

$150.00 

$185.00 

$150.00 

$185.00 

$150.00 

$185.00 

 

 

Funding Eligibility Criteria:

Individual Sponsored Trainee

Company Sponsored Trainee

  • Singapore Citizens or Singapore Permanent Residents
  • Trainee must achieve at least 75% attendance
  • Trainee must pass all prescribed tests / assessments, and attain 100% competency
  • NTUC LearningHub reserves the right to claw back the funded amount from trainee if he/she did not meet the eligibility criteria
  • Singapore Citizens or Singapore Permanent Residents
  • Trainee must achieve at least 75% attendance
  • Trainee must pass all prescribed tests / assessments, and attain 100% competency
  • NTUC LearningHub reserves the right to claw back the funded amount from the employer if trainee did not meet the eligibility criteria

 

Remarks:

Individual Sponsored Trainee

Company Sponsored Trainee

SkillsFuture Credit:

  • Eligible Singapore Citizens can use their SkillsFuture Credit to offset course fee payable after funding

 

PSEA:

  • Eligible Singapore Citizens can use their Post-Secondary Education Account (PSEA) funds to offset course fee payable after funding

 

UTAP:

  • NTUC Members can enjoy up to 50% funding (capped at $250 per year) under Union Training Assistance Programme (UTAP)

Absentee Payroll (AP) Funding:

  • $4.50 per hour, capped at $100,000 per enterprise per calendar year
  • AP funding will be computed based on the actual number of training hours attended by the trainee
  • Note: Courses / Modules under Professional Conversion Programme (PCP) will not be eligible for AP funding claim.

 

Terms and conditions apply. NTUC LearningHub reserve the right to make changes or improvements to any of the products described in this document without prior notice.

 

Prices are subject to other LHUB miscellaneous fees.

 

What Others Also Enrolled In