NSAFD02: NSA - MICROSOFT EXCEL (ADVANCED)
NSA - MICROSOFT EXCEL (ADVANCED)
Course Duration
Mode of Assessment
Students must complete written question and practical performance assessments 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
Required Prerequisites:
** Kindly be informed that all trainees will have to take an Excel diagnostic test prior to registration.
(a) F2F Classes, these are the admission requirements.
- Have advance knowledge on Excel spreadsheet such as using Cells, Rows and Columns, Formulas and Functions, Formatting, Charts and preparing Outputs
- Be a proficient user of computer and computer software
- Be able to Speak, Listen, Read and Write English at WPL Level 4 or equivalent
- Be able to manipulate numbers at WPN Level 4 or equivalent
- Have keen interest to acquire new knowledge and skill
(b) Virtual Learning Classes, these are the admission requirements.
Trainings will be conducted on Zoom platform, thus webcam and microphone are compulsory
Applicants need to:
- Have a Windows OS PC prior to class (Apple Mac OS is not applicable)
- Have advance knowledge on Excel spreadsheet such as using Cells, Rows and Columns, Formulas and Functions, Formatting, Charts and preparing Outputs
- Be a proficient user of computer and computer software
- Be able to Speak, Listen, Read and Write English at WPL Level 4 or equivalent
- Be able to manipulate numbers at WPN Level 4 or equivalent
- Have keen interest to acquire new knowledge and skill
Course Outline
1. Formatting
- Cells
- Worksheets
2. Formulas and Functions
- Using Formulas and Functions
3. Charts
- Creating Charts
- Formatting Charts
4. Analysis
- Using Tables
- Sorting and Filtering
- Scenarios
5. Validating and Auditing
- Validating
- Auditing
6. Enhancing Productivity
- Naming Cells
- Paste Special
- Linking, Embedding and Importing
- Automation
7. Collaborative Editing
- Reviewing and Security
Certificate Obtained and Conferred by
This course prepares for trainees to sit through the ICDL external examinations. It is optional for trainees to take the examinations. A registration is needed with the exams unit department of LHUB. Trainees will need to sign and up and register in order to sit for the exam.
Successful trainees who pass 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: Trainee ratio is 1:20
Price
|
Course Fee and Government Subsidies |
||||
|
|
Individual Sponsored |
Company Sponsored |
||
|
Before GST |
After GST |
Before GST |
After GST |
|
|
Full Course Fee |
$480.00 |
$523.20 |
$480.00 |
$523.20 |
|
For Singapore Citizens aged 50 years and above |
$96.00 |
$139.20 |
$96.00 |
$139.20 |
Union Training Assistance Programme (UTAP):
- NTUC members enjoy UTAP* benefit of up to $250 each year when you sign up for courses with NTUC LearningHub.
* UTAP supports 50% of the course fees paid cap at $250 per year. You must be a union member throughout the course duration and at the time of claim. You must achieve a minimum of 75% attendance for each application and have sat for all prescribed examinations. Other terms and conditions apply.
Terms and conditions apply. NTUC LearningHub reserve 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 E-LEARNING)
View detail
SKILLSFUTURE FOR DIGITAL WORKPLACE 2.0 (SFDW 2.0) - GENERAL (1 DAY)(CLASSROOM WITH ASYNCHRONOUS E-LEARNING)
View detail
SKILLSFUTURE FOR DIGITAL WORKPLACE 2.0 (SFDW 2.0) - BUILT ENVIRONMENT (2 DAYS)(CLASSROOM WITH ASYNCHRONOUS E-LEARNING)
View detail
SKILLSFUTURE FOR DIGITAL WORKPLACE 2.0 (SFDW 2.0) - FOOD SERVICES (2 DAYS) (CLASSROOM WITH ASYNCHRONOUS E-LEARNING)
View detail
SKILLSFUTURE FOR DIGITAL WORKPLACE 2.0 (SFDW 2.0) - MANUFACTURING (2 DAYS) (CLASSROOM WITH ASYNCHRONOUS E-LEARNING)
View detail
SKILLSFUTURE FOR DIGITAL WORKPLACE 2.0 (SFDW 2.0) - RETAIL (2 DAYS) (CLASSROOM WITH ASYNCHRONOUS E-LEARNING)
View detail
SKILLSFUTURE FOR DIGITAL WORKPLACE 2.0 (SFDW 2.0) - TOURISM (2 DAYS) (CLASSROOM WITH ASYNCHRONOUS E-LEARNING)
View detail
SKILLSFUTURE FOR DIGITAL WORKPLACE 2.0 (SFDW 2.0) - TRANSPORTATION (2 DAYS) (CLASSROOM WITH ASYNCHRONOUS E-LEARNING)
View detail