• Skip to main content
  • Skip to footer

Novasoft Academy

IT Training Courses in Singapore

  • All Courses
  • Adobe
    • Adobe Dreamweaver – Beginners
    • Adobe Dreamweaver – Advanced
    • Adobe InDesign – Beginners
    • Adobe InDesign – Advanced
    • Adobe Illustrator – Beginners
    • Adobe Illustrator – Advanced
    • Adobe Photoshop – Beginners
    • Adobe Photoshop – Advanced
  • Digital Marketing
    • Pay Per Click (PPC)
    • Search Engine Optimisation (SEO)
    • Social Media Marketing (SMM)
    • WordPress Website Creation
  • Microsoft
    • Microsoft Excel – Beginners
    • Microsoft Excel – Advanced
    • Microsoft Powerpoint – Beginners
    • Microsoft Powerpoint – Advanced
    • Microsoft Project – Beginners
    • Microsoft Project – Advanced
    • Microsoft Word – Beginners
    • Microsoft Word – Advanced
  • NICF
    • CCNA Cisco Security Certification
    • Computer Hacking Forensics Investigator
    • Project Management Professional (PMP) Certification
    • Certification in IT Project Management
    • Certified Security Analyst
    • Ethical Hacking & Countermeasures
  • Blog
  • Contact Us

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 navigate the Microsoft office software Microsoft Excel and formulate formulas to enhance productivity.

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 excel Formulas
Module 12. Cut, Copy and Paste
Module 13. Data Management and data management formulas
Module 14. Creating Charts
Module 15. Using Page Setup
Module 16. Printing

Course Fees & Funding Options

Singapore Citizen/PR Collapse
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 Expand
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 Expand
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 Expand
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? Collapse

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? Expand

Please refer to the next section of this page below.

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

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

MS Excel Advanced Course Online

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

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

Microsoft Powerpoint (Beginners)

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

Learn more →

Excel Course Beginners Backup Image

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 →

Footer

About Novasoft

At Novasoft, we focus on competency-based learning methodologies to ensure real transfer of skills and knowledge happen.

Site Links

  • About Us
  • Contact Us
  • Privacy Policy
  • Adobe Courses
  • Digital Marketing Training Courses
  • Microsoft Office Certification Training Courses
  • NICF Courses Singapore

Contact Details

Trainings are conducted at:

10 Anson Road,
#06-19/20 International Plaza,
Singapore 079903

Email Enquiries:
enquiry@novasoftacademy.com

© Copyright Novasoft Academy · A Partner of COMAT Training Services · All Rights Reserved ·