Perform Advanced Spreadsheet Functions (with CoPilot)

Funding Validity Period

15 November 2023

14 November 2027

Course Overview

This module, in conjunction with CoPilot, 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 advanced features in a spreadsheet application to improve productivity.

Skills Acquired

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 Modules

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
Creating charts with CoPilot

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

Create custom data formats
Split text to columns
Using multiple worksheets
Add, move and remove splits
Hide and show rows, columns and worksheets

Use cell references in formulas
Use intermediate and advanced level functions and formulas in Excel

Creating charts and Sparklines
Formatting charts and Sparklines
Creating charts with CoPilot

Analysis with PivotTable and PivotChart
Using Excel tables
Apply Conditional Formatting
Sorting and filtering
Data table
Scenarios
Subtotals and Outlining

Data Validation
Formula auditing

Analysis with PivotTable and PivotChart
Using Excel tables
Apply Conditional Formatting
Sorting and filtering
Data table
Scenarios
Subtotals and Outlining

Working with notes and comments
Worksheet and Workbook Protections
Sharing workbooks
Track changes
Compare and merge workbooks

Who is this course is for

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.

Academic prerequisites

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 Fees

Fees	Small Medium Enterprises (SMEs)	Non Small Medium Enterprises	Singaporean Employees aged 40 years and above
Full Fee	$720.00	$720.00	$720.00
9% GST (on full course fee)	$64.80	$64.80	$64.80
Funding Amount	$504.00 (70% off course fee)	$360.00 (50% off course fee)	$504.00 (70% off course fee)
Nett Fee Payable (incl. GST)	$280.80	$424.80	$280.80

SME: Company registered or incorporated in Singapore AND employment size of not more than 200 or with annual sales turnover of not more than $100 million
Non-SME (MCES): Employee is Singaporean aged 40 years and above

Course Fee Funding:
SME: 70% of course fee
Non-SME: 50% of course fee
Non-SME(MCES): 70% of course fee

Eligible for Absentee Payroll Funding

$4.50 per training hour capped at $100,000 per enterprise per calendar year

Eligible for SkillsFuture Enterprise Credit (SFEC)

Fees	Singapore Citizens (40 years and above)	Singapore Citizens (21 to 39 years old) & Permanent Residents (21 years old and above)
Full Fee	$720.00	$720.00
9% GST (on full course fee)	$64.80	$64.80
Funding Amount	$504.00 (70% off course fee)	$360.00 (50% off course fee)
Nett Fee Payable (incl. GST)	$280.80	$424.80

MCES: Singaporean aged 40 years and above
Normal: Singaporean / PR aged 21 years and above

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

Eligible for UTAP funding
Eligible for SkillsFuture Credit
Eligible for PSEA Funds