Microsoft Office Specialist Certificate – Excel 2003 (Core)

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 Duration

21 hours / 3 days exclude examination hours

Assessment

Participants are required to sit for 1 Microsoft Office Specialist (MOS) examination.
*Any amendments (subject to availability) to a confirmed exam booking, an administrative charge of $21.40 will be imposed.

Course Outline

Creating Data and Content

• Enter and edit cell content
• Locate specific cell content
• Locate‚ select‚ and insert supporting information
• Insert‚ position‚ and size graphics

Analyzing Data

• Filter lists using the AutoFilter feature
• Sort lists
• Insert and modify formulas
• Use statistical‚ date and time‚ financial‚ and logical functions
• Create‚ modify‚ and position diagrams and charts based on worksheet data

Formatting Data and Content

• Apply and modify cell formats
• Apply and modify cell styles
• Modify row and column formats
• Format worksheets

Collaborating

• Insert‚ view‚ and edit comments

Managing Workbooks

• Create new workbooks from templates
• Insert‚ delete‚ and move cells
• Create and modify hyperlinks
• Organize worksheets
• Preview data in other views
• Customize window layout
• Setup pages for printing
• Print data
• Organize workbooks using file folders
• Save data in appropriate formats for different uses

Pre-requisites

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

Course Location

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

Methodology

Instructor-led class

Certification

• Certificate of Completion from NTUC LearningHub
• Microsoft Office Specialist Certification upon passing the exam

Price

Without GST
Non Union Members:
Course Fee: $420.00
Exam Fee: $114.00

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

With GST
Non Union Members:
Course Fee: $449.40
Exam Fee: $121.98

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