MICROSOFT EXCEL ADVANCE

MICROSOFT EXCEL ADVANCE

Funded

Course Duration

23.0 hr(s)

Mode of Assessment

Participants will be required to complete a paper-based assessment during class.

Who Should Attend

Individuals who have successfully completed/reached ICDL basic skills levels and wish to further enhance their expertise in Advanced Spreadsheet Functions.

Course Overview

Bring your Spreadsheets skills to an expert level and be more confident, efficient and effective in using Spreadsheets.

Master the advanced functions of Spreadsheets applications to produce more sophisticated reports with deeper data analysis and complex mathematical calculations. With this, you will be able to draw out key insights from data and enhance your productivity and effectiveness at work.
This module sets out advanced skills that can be used to produce sophisticated reports, to perform complex mathematical and statistical calculations, and to improve productivity using a spreadsheet application.

Course Schedule

Next available schedule

See All Schedules

Course Objectives

Upon course completion, learners will be able to:

  • Apply advanced formatting options such as conditional formatting and customized 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

The admission requirements are:

  • Have advance knowledge on Excel spreadsheet such as using Cells, Rows and Columns, Formulas and Functions, Formatting, Charts and preparing Outputs
  • Read, write, and speak English at WPL Level 4
  • Manipulate numbers at WPN Level 4
  • Hardware & Software
    • This course will be conducted as a Virtual Live Class (VLC) via Zoom platform
    • Participants must own a Zoom account and have a laptop or a desktop with “Zoom Client for Meetings” installed. Download from zoom.us/download. 

System Requirement

Must-have:
Please ensure that your computer or laptop meets the following requirements. 

  • Operating system: Windows 10 or MacOS (64 bit or above) 
  • Processor/CPU: 1.8 GHz, 2-core Intel Core i3 or higher 
  • Minimum 20 GB hard disk space 
  • Minimum 8 GB RAM 
  • Webcam (camera must be turned on for the duration of the class) 
  • Microphone 
  • Internet Connection: Wired or Wireless broadband 
  • Latest version of Zoom software to be installed on computer or laptop prior to the class. 

Good-to-have: 

  • Wired internet connection
    Wired internet will provide you with stable and reliable connection. 
  • Dual monitors
    Using a dual monitor setup will undoubtedly improve your training experience, enabling you to simultaneously participate in hands-on exercises and maintain engagement with your instructor. 

Not recommended: 
Using tablets are not recommended due to their smaller screen size, which could cause eye strain and discomfort over the course of the program's duration. 

Course Outline

Module 1: Formatting

  • Cells
  • Worksheets

Module 2: Formulas and Functions

  • Using Formulas and Functions

Module 3: Charts

  • Creating Charts
  • Formatting Charts

Module 4: Analysis

  • Using Tables
  • Sorting and Filtering
  • Scenarios

Module 5: Validating and Auditing

  • Validating
  • Auditing

 Module 6: Enhancing Productivity

  • Naming Cells
  • Paste Special
  • Linking, Embedding and Importing
  • Automation

Module 7: Collaborative Editing

  • Reviewing and Security

Certificate Obtained and Conferred by

  • Upon meeting 75% attendance and passing the assessment, participants will be awarded with a digital Statement of Attainment (SOA), accredited by SkillsFuture Singapore. SOA will be reflected as [LOG-LDR-2006-1.1 Data and Statistical Analysis].
  • Upon meeting 75% attendance and passing the assessment, participants will be awarded with a digital Certificate of Completion from NTUC LearningHub.
  • External Certification Exam
    Successful trainees who have passed the SSG assessment, will be able to sit for the ICDL external in-class examination. Trainees who have sat and passed and completed the exams will receive the internationally recognised ICDL Certificate upon completion of the course. This certificate is administered by ICDL Singapore, a new initiative from ECDL Foundation.
  • Certificate of completion from NTUC LearningHub

Upon meeting at least 75% attendance and passing the assessment(s), participants will receive a Certificate of Completion from NTUC LearningHub.

Additional Details

Medium of Instruction: English
Trainer to trainee ratio: 1:20
Mode of Delivery: <Virtual Live Class (VLC) via Zoom> or <Physical class>

Price

Course Fee and Government Subsidies

  

Individual Sponsored 

Company Sponsored 

 

Non-SME 

SME 

Before GST 

After GST 

Before GST 

After GST

Before GST 

After GST

Full Course Fee
(For Foreigners and those not eligible for subsidies)

$585.00

$637.65

$585.00

$637.65

$585.00

$637.65

For Singapore Citizens aged 39 years and below
and
For all Singapore Permanent Residents
(The minimum age for individual sponsored trainees is 21 years)

$292.50

$345.15

$292.50

$345.15

$175.50

$228.15

For Singapore Citizens aged 40 years and above

$175.50

$228.15

$175.50

$228.15

$175.50

$228.15

 

Funding Eligibility Criteria

Individual Sponsored Trainee

Company Sponsored Trainee
  • Singapore Citizens or Singapore Permanent Residents
  • From 1 October 2023, attendance-taking for SkillsFuture Singapore's (SSG) funded courses must be done digitally via the Singpass App. This applies to both physical and synchronous e-learning courses.
  • Trainee must pass all prescribed tests / assessments, and attain 100% competency
  • NTUC LearningHub reserves the right to claw back the funded amount from trainee if he/she did not meet the eligibility criteria
  • Singapore Citizens or Singapore Permanent Residents
  • From 1 October 2023, attendance-taking for SkillsFuture Singapore's (SSG) funded courses must be done digitally via the Singpass App. This applies to both physical and synchronous e-learning courses.
  • Trainee must pass all prescribed tests / assessments, and attain 100% competency
  • NTUC LearningHub reserves the right to claw back the funded amount from the employer if trainee did not meet the eligibility criteria

 

Remarks

Individual Sponsored Trainee

Company Sponsored Trainee

SkillsFuture Credit: 

  • Eligible Singapore Citizens can use their SkillsFuture Credit to offset course fee payable after funding.

UTAP: 

  • This course is eligible for Union Training Assistance Programme (UTAP).
  • NTUC members can enjoy up to 50% funding (capped at $250 per year) under UTAP.

PSEA: 

  • Eligible Singapore Citizens can use their Post-Secondary Education Account (PSEA) funds to offset course fees payable after funding. 
  • For Virtual Learning Class (VLC), currently unavailable.
  • For Face-to-Face class, check my SkillsFuture (TGS-2023037880), scroll down to “Keyword Tags” section to verify for PSEA eligibility.
  • If there is “PSEA” under keyword tags, the course is eligible for PSEA.  
  • And if there is no “PSEA” under keyword tags, the course is ineligible for PSEA. 
  • Not all courses are eligible for PSEA funding.

Absentee Payroll (AP) Funding: 

  • $4.50 per hour, capped at $100,000 per enterprise per calendar year.
  • AP funding will be computed based on the actual number of training hours attended by the trainee.
  • Note: Courses / Modules under Professional Conversion Programme (PCP) will not be eligible for AP funding claim.

 

Terms & Conditions apply. NTUC LearningHub reserves the right to make changes or improvements to any of the products described in this document without prior notice.

Prices are subject to other LHUB miscellaneous fees.

What Others Also Enrolled In

Funded

NSA - DIGITAL CITIZEN

View detail
Before Funding $320.00
View detail
Funded

NSA - DIGITAL CITIZEN PLUS

View detail
Before Funding $320.00
View detail

MICROSOFT EXCEL ESSENTIAL

View detail
$330.00
View detail
Funded

SKILLSFUTURE FOR DIGITAL WORKPLACE 2.0 (SFDW 2.0) - GENERAL (2 DAYS) (CLASSROOM WITH ASYNCHRONOUS ELEARNING)

View detail
Before Funding $750.00
View detail