UEN No.: 198802365N

WSQ

Perform Advanced Spreadsheet Functions

course details

Duration and Time

Training Time

9am - 6pm

Course Duration

24 HRS

Course Information

Course Reference Number

TGS-2023039918

Funding Validity Period

15 Nov 2023 To
14 Nov 2025

Mode of Training

Classroom

COURSE OVERVIEW

This module 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 advance features in a spreadsheet application to improve productivity.

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

Learning Unit 1: Formatting
  • Create custom data formats
  • Split text to columns
  • Using multiple worksheets
  • Add, move and remove splits
  • Hide and show rows, columns and worksheets
Learning Unit 2: Formulas and Functions
  • Use cell references in formulas
  • Use intermediate and advanced level functions and formulas in Excel
Learning Unit 3 – Creating charts and Sparklines
  • Creating charts and Sparklines
  • Formatting charts and Sparklines
Learning Unit 4: Analysis
  • Analysis with PivotTable and PivotChart
  • Using Excel tables
  • Apply Conditional Formatting
  • Sorting and filtering
  • Data table
  • Scenarios
  • Subtotals and Outlining
Learning Unit 5: Validating and Auditing
  • Data Validation
  • Formula auditing
Learning Unit 6: Analysis
  • Analysis with PivotTable and PivotChart
  • Using Excel tables
  • Apply Conditional Formatting
  • Sorting and filtering
  • Data table
  • Scenarios
  • Subtotals and Outlining
Learning Unit 7: Collaborative Editing
  • Working with notes and comments
  • Worksheet and Workbook Protections
  • Sharing workbooks
  • Track changes
  • Compare and merge workbooks

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.

  • Learners must be able to read, write, speak and listen to English at secondary school level
  • 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 must have basic to intermediate ability in using Microsoft Excel
Course Outline

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 $64.80 $504 (70% off course fee) $280.80
Non Small Medium Enterprises $720 $64.80 $360 (50% off course fee) $424.80
Singaporean Employees aged 40 years and above $720 $64.80 $504 (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 $64.80 $504 (70% off course fee) $280.80
Singapore Citizens (21 to 39 years old) & Permanent Residents (21 years old and above) $720 $64.80 $360 (50% off course fee) $424.80

Course Fee Funding:
MCES: 70% of course fee
Normal: 50% of course fee

Related Courses

IT

8 HRS

Non-Certifiable

IT

8 HRS

Non-Certifiable

IT

8 HRS

Non-Certifiable

GET IN TOUCH WITH US

Have an enquiry? Feel free to connect via any of the channels below.

enquiry form

Leave a message

WhatSAPP

Chat on WhatsApp at
+65 8767 0614

Training hotline

Give us a call at
+65 6737 5761

SHARE THIS COURSE
Main Category
IT COURSES
Generative AI Series
SOFT SKILLS COURSES
COURSE MONTH
Certification
COURSE LEVEL
Course Duration