NTUC LearningHub

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.
Categories
More Information
  • NTUC LearningHub
Sponsored Content
Location
  • Devan Nair Institute (e2i), Jurong East St 21, Singapore, South West Community Development Council 609607

  • No comments yet.
  • Add a review
    error: Content is protected !!