• 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 Advanced 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 advanced course prepares you for the ICDL Module 4 Perform Advanced Spreadsheet Functions exam.

On top of that, you will learn how to apply more advanced spreadsheet functions such as sorting query and link data, editing and enhancing numerics, and presenting advanced formatting operations on graphs and charts.

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 Advanced (2010/2013)

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

Course Fees & Funding Options

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

*Singapore Citizens aged ≥ 21 years.

Singapore Citizen ≥ 35 years with earning ≤ $1900/month Expand
Course Fee (inclusive of GST)  $535
Course Fee after 95% Workfare Training Scheme (WTS) funding (inclusive of GST)*  $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)  $535
Course Fee after 90% Enhanced Training Support SMEs Funding*  $85

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

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

*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 Advanced (2010)
16 - 17 Mar 2017 (9am - 6pm)
21 - 22 Mar 2017 (9am - 6pm)
27 - 28 Mar 2017 (9am - 6pm)
30 - 31 Mar 2017 (9am - 6pm)
6 - 7 Apr 2017 (9am - 6pm)
17 - 18 Apr 2017 (9am - 6pm)

Microsoft Excel Advanced (2013)
2 - 3 Mar 2017 (9am - 6pm)
13 - 14 Mar 2017 (9am - 6pm)
30 - 31 Mar 2017 (9am - 6pm)
6 - 7 Apr 2017 (9am - 6pm)
17 - 18 Apr 2017 (9am - 6pm)
27 - 28 Apr 2017 (9am - 6pm)

Course Reservation Form

Select a Course Date to Reserve Your Seat

Related Courses

MS Excel Advanced Course Online

Microsoft Excel (Beginners)

Accomplish basic tasks with Microsoft Excel such as creating a workbook, formatting text and cells, and data management.

Learn more →

microsoft-word-advanced

Microsoft Word (Advanced)

Learn advanced word processing outputs, illustrating sophisticated typographical, formatting and layout presentations, including tables, forms or graphics.

Learn more →

microsoft-powerpoint-beginners

Microsoft Powerpoint (Advanced)

Learn advanced formatting and layout techniques, enhance the presentation with the use of drawing and imaging tools, and create and use macros and multimedia effects.

Learn more →

microsoft-project-advanced

Microsoft Project (Advanced)

Learn more advanced project information customisation, tracking project progress, importing and exporting data, and working with graphics and web pages.

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 ·