NICF168: MICROSOFT EXCEL ADVANCE
MICROSOFT EXCEL ADVANCE
Course Duration
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
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:
Good-to-have:
Not recommended: |
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 |
$585.00 |
$637.65 |
$585.00 |
$637.65 |
$585.00 |
$637.65 |
For Singapore Citizens aged 39 years and below |
$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 |
|
|
Remarks
Individual Sponsored Trainee |
Company Sponsored Trainee |
SkillsFuture Credit:
UTAP:
PSEA:
|
Absentee Payroll (AP) Funding:
|
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.
Batch ID | Course Period | Course Title | Funding Available |
Duration (Hours) |
Session (Hours) |
Venue | Available Seats |
Online Payment |
---|
What Others Also Enrolled In
SKILLSFUTURE FOR DIGITAL WORKPLACE 2.0 (SFDW 2.0) - GENERAL (2 DAYS) (CLASSROOM WITH ASYNCHRONOUS ELEARNING)
View detail