Novasoft Academy

IT Training Courses in Singapore

ICDL Module 4: ES WSQ
Perform Spreadsheet Functions
(Microsoft Excel 2010/2013)

What is Microsoft Excel?

In layman terms, Microsoft Excel is a software used to create spreadsheets for storing, organising, and manipulating data.

Course Overview

This 3-day Microsoft Excel course prepares you for the ICDL Module 4 Perform Spreadsheet Functions exam.

On top of that, you will learn how to accomplish basic tasks with Microsoft Excel such as creating a workbook, formatting text and cells, work with tables, and some advanced spreadsheet application data management, creating graphs and charts, and preparing the document for print.

Learning Outcomes

This is a bootcamp that provides students with the knowledge and skills necessary to install, operate, and troubleshoot a small to medium-sized network, including connecting to a WAN and implementing network security.

Course Outline

Microsoft Excel (2010)
Module 1. Using Conditional and Custom Formats
Module 2. Using Templates
Module 3. Working with Databases
Module 4. Working with Advanced Filters
Module 5. Revising Charting Features
Module 6. Creating/Revising PivotTables
Module 7. Using Auditing Tools and Range Names
Module 8. Exporting and Importing Data
Module 9. Using Advanced Functions
Module 10. Using Scenarios
Module 11. Using Worksheet Protection
Module 12. Tracking and Merging Workbooks
Module 13. Recording Macros
Module 14. Comments

Microsoft Excel (2013)
Module 1. Exploring Microsoft Excel 2013
Module 2. Getting Help
Module 3. Basic Workbook Skills
Module 4. Selection
Module 5. Working with Columns and Rows
Module 6. Number Formatting
Module 7. Text Formatting
Module 8. Cell Formatting
Module 9. Filtering Data with AutoFilter
Module 10. Working with Tables
Module 11. Basic Formulas
Module 12. Cut, Copy and Paste
Module 13. Data Management
Module 14. Creating Charts
Module 15. Using Page Setup
Module 16. Printing

Course Fees & Funding Options

Singapore Citizen/PR
Course Fee (inclusive of GST)  $406.60
Course Fee after 80% SkillsFuture Funding, capped at $17 per hour (inclusive of GST)*  $117.60

*Singapore Citizens aged ≥ 21 years.

Singapore Citizen ≥ 35 years with earning ≤ $1900/month
Course Fee (inclusive of GST)  $406.60
Course Fee after 95% Workfare Training Scheme (WTS) funding (inclusive of GST)*  $45.60

*If you are a Singapore Citizen 35 years old and above and earning less than $1900/month or less, you should have received a letter from WDA notifying you of your eligibility.

SMEs-Sponsored Singapore Citizen/PR
Course Fee (inclusive of GST)  $406.60
Course Fee after 90% Enhanced Training Support SMEs Funding*  $64.60

*Small and Medium Enterprises (SME) - sponsored Singapore Citizens and Permanent Residents.

Singapore Citizen aged ≥ 40 years
Course Fee (inclusive of GST)  $406.60
Course Fee after SkillsFuture Mid-Career Enhancement Funding (inclusive of GST)*  $64.60

*Singapore Citizens aged ≥ 40 years.

Frequently Asked Questions

What certification will I receive?

Upon completion of this module course under WDA funding, students will receive Statement of Attainment (SOA) Certificates from WDA. The details of SOA of each module are given below.
IT-NMM-401S-1 : Install and configure a Switch
IT-NMM-402S-1 : Install Switches and Multi-Switched local area network

Am I eligible for funding/subsidies?

Please refer to the next section of this page below.

What is the average class size?
What's next?

You may want to signup for our Adobe Dreamweaver Advanced course to further your web development skills.

Upcoming Classes

Microsoft Excel (2010)
9 - 10 Mar 2017 (9am - 6pm)
23 - 24 Mar 2017 (9am - 6pm)
10 - 11 Apr 2017 (9am - 6pm)
20 - 21 Apr 2017 (9am - 6pm)

Microsoft Excel (2013)
6 - 7 Mar 2017 (9am - 6pm)
16 - 17 Mar 2017 (9am - 6pm)
27 - 28 Mar 2017 (9am - 6pm)
3 - 4 Apr 2017 (9am - 6pm)
12 - 13 Apr 2017 (9am - 6pm)
20 - 21 Apr 2017 (9am - 6pm)

Course Reservation Form

Select a Course Date to Reserve Your Seat

Related Courses

Microsoft Excel (Advanced)

Learn advanced spreadsheet functions such as sorting query and link data, editing and enhancing numerics, and presenting advanced formatting operations on graphs and charts.

Learn more →

Microsoft Word (Beginners)

Acquire basic operational skills on Microsoft Word such as basic text editing, setting up a document, headers and footers, creating, and editing tables.

Learn more →

Microsoft Powerpoint (Beginners)

Acquire fundamental skills on creating amazing slide shows and charts, adding special effects, and slide formatting with Microsoft PowerPoint.

Learn more →

Microsoft Project (Beginners)

Learn basic project management, how to work with tasks and scheduling tools, how to assign budget and costs, and how to track progress in Microsoft Project.

Learn more →