UEN No.: 198802365N

Perform Advanced Spreadsheet Functions

COURSE synopsis

Course Details

Training Provider:

Course Duration

24 HRS

Training Time

9am - 6pm

Course Reference Number

TGS-2023039918

Funding Validity Period

15 Nov 2023 To
14 Nov 2025

Mode of Training

Classroom

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.

COURSE OBJECTIVES

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

Target Audience (Operational, Supervisory & Managerial)

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.

Assumed Skills

  • 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 Content

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
Course Outline

Download the PDF below for a summary of the course outline.

COURSE FEES

Company Sponsored

Funding Type Full Fee GST Funding Amount Nett Fee Payable (incl. GST)
SME $720 $64.80 $504 $280.80
Non-SME $720 $64.80 $360 $424.80
Non-SME
(MCES)
$720 $64.80 $504 $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 GST Funding Amount Nett Fee Payable (incl. GST)
MCES $720 $64.80 $504 $280.80
Normal $720 $64.80 $360 $424.80

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

Related Courses

IT

16 HRS

WSQ

IT

16 HRS

WSQ

IT

16 HRS

WSQ

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