ES WSQ – 3 Days – Perform Advanced Spreadsheets Functions (Ms Advanced Excel 2013 – 24 hrs) (ICDL Certification Module: Advanced Spreadsheets)

Overview

Course Duration

24 Hours

Target Audience

For beginner and professional who in need of Advanced Spreadsheets in order to produce higher quality management information.

Pre-requisites

Need to possess basic knowledge of Excel 2013

Certification

Successful trainees will receive the internationally recognized ICDL Certificate upon completion of the course. This certificate is administered by ICDL Singapore. This is a joint certification between WDA and ICDL Singapore. Student must take a 60 minutes online assessment at the end of the course.

Course Pathway

Any other ICDL courses

Objectives

ICDL Advanced Spreadsheets is a high level certification program which presents candidates with the opportunity to bring their spreadsheet skills to an expert level. This allows them to use the full potential of the spreadsheet application to produce higher quality management information.


Individuals with ICDL Advanced Spreadsheets certified skills can:

 

  •  Produce higher quality information
  •  Pinpoint key information quicker and more easily
  • Provide more sharply-defined analysis
  •  Produce more sophisticated reports
  • Use advanced editing, data handling, functions and analysis features
  • Use macros within the spreadsheets application

Course Details

SECTION

DESCRIPTION

Section 1 – Introduction

Spreadsheet Design
Identify the Different Techniques to Use

Section 2 – Formatting

Split Windows
Use Conditional Formatting
Use Format as a Table
Use Paste Special
Transpose Data
Copy and Move Sheets

Section 3 – Protection       

Protect Cells
Hide & Unhide Columns & Rows
Create Read-Only Workbooks
Hide and Unhide Worksheets & Workbooks
Protect Workbooks
Hide Formulas

Section 4 - Cell Comments

Use Cell Comments
Display Comments
Create, Edit & Delete Comments

Section 5 – Names

Use Names
Create and Delete Names for Cell Ranges
Paste and Apply Names
Use Names in Formulas
Use Names with Go To

Section 6 – Templates



 

Create & Understand Templates
Use Templates
Edit Templates

Section 7 – Formulas

Display and Check Formulas
Understand Formulas that Produce Errors
Use Mixed Cell Referencing
Create Custom Number Formats

Section 8 – Outlines

Create an Outline
Expand and Collapse Outline Level Details

Section 9 – Scenarios

Create Scenarios
Use, Edit and Delete Scenarios
Create Scenario Summary Reports

Section 10 - Linking & Importing
 

Link Cells
Link between Worksheets & Workbooks
Link to a Word Document
Use Hyperlinks
Importing Delimited Data
Consolidate using 3D-Sum

Section 11 – Sorting

Sort Data
Perform Multiple Sorts
Create and Use Custom Lists
Perform Custom Sorts

Section 12 – Lists

Filter Lists using the AutoFilter
Use Custom Criteria with AutoFilter
Use the Advanced Filter
Filter using Complex Criteria
Extract Filtered Data
Add Subtotals to Lists

Section 13 - Pivot Tables

Understand PivotTables
Create a PivotTable
Update a PivotTable
Filter, Group and Sort Data in a PivotTable

Section 14 – Functions

Use Date and Time Functions
Use Lookup Functions
Use Mathematical and Statistical Functions
Use Financial Functions
Use Text and Database Functions
Use Nested Functions

Section 15 – Charts

Add and Remove Data Series
Change Chart Types
Change Chart Axis Scales
Create Combination Charts
Add Images to Charts

Section 16 - Data Tables

Create a One Input Data Table
Create a Two Input Data Table

Section 17 – Macros

Understand Macros
Record a Macro
Run a Macro
Assign a Macro to the Quick Access Toolbar

Section 18 – Auditing

Use Auditing Tools
Trace Precedents and Dependents
Add and Remove Tracer Arrows
Trace Errors
Add Data Validation

Section 19 – Tracking Changes

Track Changes in Worksheet
Share Workbooks
Merge Workbooks

Fees Structure

Subsidy and Nett Payable Amount

Subsidy Categories

Fees after subsidy

Fees payable with GST

Company

SME Company

$46/-

$78.20/-

Non – SME Company

$92/-

$124.20/-

Foreigner (WP, S-Pass, E-Pass, Dependant Pass)

$460/-

$492.20/-

Individual

Singaporean - 40 yrs and above

$46/-

$78.20/-

Singaporean – 21 – 39 yrs

$92/-

$124.20/-

Singapore PR

$92/-

$124.20/-

WTS (35 yrs and above - salary less than $2000)

$23/-

$55.20/-

Foreigner and work pass holders – WP, S-Pass,

E-Pass, Dependant Pass)

$460/-

$492.20/-

SME: Small and Medium Enterprise

WTS: Workfare Training Support

Participant need to pass the test to get subsidy

Commencement Dates

Full Time: Monday, 29 May 2017 (29 - 31 May - 9am to 6.15pm)

Thank you for your enquiry. One of our course consultants will keep in touch with you shortly.

Request more information

What would you like to request?



+



WE ARE...
Adobe authorized training center
WSQ work skills qualification training center
ICDL test center
EduTrust CPE Singapore
GENETIC COMPUTER SCHOOL
Registration No: 198902296M
24 June 2015 to 23 June 2019
OUR LOCATION
Block 118 Aljunied Avenue 2
#02-100 Singapore 380118
Tel: +65 6339 7588