WSQ ICDL Microsoft Excel 2016 Advanced

TGS-2017500602

Course Overview

An advanced course preparing participants to advanced spreadsheet features and functionality.


Mode of Trainings

Full Time


Mode of Assessment

ICDL Online Assessment


Who Should Attend

Mix from various companies, industries, and departments


Course Duration

3 Days


Total Training Duration (Hour)

24 Hours


Course Outline

Section 1: Formatting

Section 2: Functions and Formulas

Section 3: Charts

Section 4: Data Analysis

Section 5: Pivot Tables

Section 6: Auditing and Validating Data

Section 7: Enhancing Productivity

Section 8: Collaborative Editing


Certification Obtained and Conferred by
  1. Avantus Certificate of Attendance (upon achieving minimum 75% class attendance)
  2. WSQ Statement of Attainment (upon passing the relevant assessment)

Course Objectives

Participants will have the knowledge and application skills in using a spreadsheet application at an advanced level. The skills include maintaining complex spreadsheets, using complicated functions of various types, and using auditing techniques to check for errors.


Course Learning Outcome

Successful candidates 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.

Pre-requisites

Users already with Excel basic proficiency


Medium of Instruction & Trainer

English


Funding Information

SSG WSQ Certifiable Funding


Criteria:

  • Applicant must either be a Singapore Citizen or Permanent Resident of Singapore and;
  • Applicant must be at least 21 years old and;
  • Applicant must achieve at least 75% attendance, and pass all examinations/assessments and;
  • Applicant is taking the course for the first time


Avantus reserves the right to charge the full course fee (without subsidy) if any of the conditions above are not met.


SSG Funding Validity Period

1 Jan 2019 – 27 Dec 2022


Singapore Citizens aged 25 years and above will be able to utilize their Skillsfuture Credits to offset against nett fee payable


Additional Notes

Assessment Retake fee at $80 (before GST)


Documents


Price
Course Fee Payable
Original Fee Before GST With GST
Course Fee $525.00 $567.00
Individual Pricing (Fee payable to Training Provider) Before GST With GST
SkillsFuture >=40 years old, Singapore Citizens $157.50 $199.50
SkillsFuture >=21 years old $262.50 $304.50
Corporate Pricing (Fee payable to Training Provider)
Non-SME Before GST With GST
SkillsFuture >= 40 years old $157.50 $199.50
SkillsFuture >=21 years old $262.50 $304.50
SME Before GST With GST
SkillsFuture $157.50 $199.50

Please note that prices are subject to change.
Back to Catalogue →
Next Available Schedules
Category:
Mode of Training:
Trainer:
Venue:
Session Dates: Please view schedule
Registration Date:
From To
Keyword Tags
Excel Spreadsheets Analysis Charts Conditional Formatting Custom Formatting Filter Formulas Functions Macros Nested Functions Outline Pivot Chart Pivot Table Sort Subtotal Track Changes Vlookup Data Validation Scenario