ICDL Module 4: Spreadsheets (Microsoft Excel 2007)

Select Industry/Course: Select Course Introduction To Computers ICDL Module 2: Using the Computer and Managing Files (Microsoft Windows XP) Microsoft Project 2003 ICDL Module 3: Word Processing (Microsoft Word 2003) ICDL Module 4: Spreadsheets (Microsoft Excel 2003) ICDL Module 5: Using Databases (Microsoft Access 2003) ICDL Module 6: Presentations (Microsoft PowerPoint 2003) Microsoft Office Specialist Certificate – Word 2003 (Core) Microsoft Office Specialist Certificate – Excel 2003 (Core) Microsoft Office Specialist Certificate – Access 2003 (Core) Microsoft Office Specialist Certificate – PowerPoint 2003 Microsoft Office Specialist Certificate – Word Expert 2003 Microsoft Office Specialist Certificate – Excel Expert 2003 Microsoft Certified Application Specialist: Word 2007 Microsoft Certified Application Specialist: Excel 2007 WebPage Fundamentals using Microsoft FrontPage AutoCAD 2009 Essential AutoCAD 2009 Intermediate AutoCAD 2009 – Creating & Presenting 3D Models PC Building and Maintenance PC Networking Course Office Networking Jumpstart to Microsoft Visual Basic .Net Autodesk 3D Studio Max for Design Visualization Microsoft Certified Application Specialist (MCAS) - PowerPoint 2007 Microsoft Certified Application Specialist (MCAS) - Access 2007 ICDL Module 3 : Word Processing (Microsoft Word 2007) ICDL Module 4: Spreadsheets (Microsoft Excel 2007) ICDL Module 5: Using Databases (Microsoft Access 2007) ICDL Module 6: Presentations (Microsoft PowerPoint 2007) ICDL Module 2: Using the Computer and Managing Files (Microsoft Windows Vista) AutoCAD 2010 Essential AutoCAD 2010 Intermediate Learning AutoCAD 3D Web Communication using Dreamweaver CS4 Rich Media Communication using Flash CS4 Visual Communication using Photoshop CS4

Course Schedule & Online Registration

If you are an individual, please click here.
If you are representing a company, please click here

Target Audience

Individuals who are interested to learn about the creation of spreadsheet for easy calculations and charting.

Course Overview

1. Understand the concept of spreadsheets
2. Demonstrate the ability to use a spreadsheet application on a computer
3. Able to develop, format and modify using a spreadsheet
4. Able to generate and apply standard mathematical and logical formulas using standard formulas and functions
5. Demonstrate competence in creating and formatting graphs/charts

Course Duration

16 hours / 2 days

Assessment

Participants are required to sit for ICDL examination.

Course Outline

Using the Application

• First Steps with Spreadsheets
• Adjust Settings

Cells

• Insert Data
• Select Cells
• Rows and Columns
• Edit Data
• Duplicate‚ Move‚ Delete
• Search and Replace
• Sort Data

Formulas and Functions

• Arithmetic Formulas
• Cell Referencing
• Working with Functions

Formatting

• Numbers/Dates
• Contents
• Alignment‚ Border Effects

Charts/Graphs

• Using Charts/Graphs

Worksheets

• Handling Worksheets

Prepare Outputs

• Worksheet Setup
• Preparation
• Printing

More Functions and Formulas

• Formulas with several operators and cell ranges
• Using Insert Function
• Creating and using Range Name
• Using IF and PMT Function

Pre-requisites

ICDL Certification in Using the Computer & Managing Files‚ ESS Basic ICT Skills‚ ESS Workplace ICT Applications

Course Location

NTUC Trade Union House
73 Bras Basah Road
#02-01
Singapore 189556

Methodology

Instructor-led class

Certification

Successful trainees 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.

Price

Non Union Members:
Course Fee: $300.00
Exam Fee: $20.00

Union Members:
Course Fee: $250.00 (exam fees inclusive)

*All fees stated excludes GST

Funding Info

SPUR funding is available for Singaporeans/Permanent Resident and Corporate Sign up Trainees Only
* SPUR Funding is not applicable for individual sign up trainees and online registration

Enquiry

Type of enquiry Corporate Individual

Company Name

Name *

Contact No *

Email *

Preferred Contact Email Telephone Call Morning Noon Evening

Questions & Comments

Enter characters displayed

* Mandatory fields

Our Partners