Skip To Content
Perform Advanced Spreadsheet Functions (Excel) 2019 (24 Hours) is a Program

Perform Advanced Spreadsheet Functions (Excel) 2019 (24 Hours)

Self-paced

Sorry! The enrollment period is currently closed. Please check back soon.

Full program description

Perform Advanced Spreadsheet Functions (Excel) 2019 (24 Hours)

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.

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 Duration

24 hours

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

Mode of Assessment

Written Assessment

Certification 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.

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

Pre-requisites

Prior to attending this course, trainees should:

  • Complete/Reach ICDL Spreadsheet Functions
  • 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

Price

 

Individual Sponsored

Non-SME

SME

 

w/o GST

w GST

w/o GST

w GST

w/o GST

w GST

Original Course Fee

 $500.00

 $535.00

 $500.00

 $535.00

 $500.00

 $535.00

Singapore Citizens & PRs aged 21 years and above

 $100.00

 $135.00

 $100.00

 $135.00

 

 

Singapore Citizens aged 40 years and above

 $50.00

 $85.00

 $50.00

 $85.00

 

 

 

 

 

 

 

 

 

Enhanced Training Support for SMEs Companies (90%) **

 

 

 

 

 $50.00

 $85.00

Course reference code in SkillsConnect:

  • For Training Grant application, please use the following reference code

Reference code:

  Perform Advanced Spreadsheet Functions (Excel) 2019 (24 Hours)

CRS-Q-0040852-ES

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.

3ADLE19