Skip to main content

Microsoft Office Excel Course

Join our 2-day Microsoft Excel Course, accredited by WSQ and supported by SkillsFuture Singapore. This basic excel course is suitable for beginners.

Microsoft Office Excel Course

Available locations

No location has been published for this course yet. Please contact us if you need a specific venue.

Course Outline Requirements Course Overview FAQs
Course Outline

LO 1: Understand Spreadsheet Fundamentals

  • Spreadsheet features and uses
  • Create, open, save, and close workbooks
  • Navigate the Excel interface
  • Use ribbons, toolbars, and zoom
  • Set basic options and use Help

LO 2: Insert, Edit, and Sort Data

  • Enter text, numbers, and dates
  • Select and navigate cells
  • Edit cell contents
  • Use Find, Replace, Undo, and Redo
  • Sort data

LO 3: Manage Cells, Rows, and Columns

  • Copy, cut, paste, and Paste Special
  • Insert and delete cells, rows, and columns
  • Adjust column widths and row heights
  • Use Clipboard
  • Freeze and unfreeze panes

LO 4: Manage Worksheets

  • Switch and select worksheets
  • Insert, delete, copy, and move worksheets
  • Rename worksheets
  • Show or hide gridlines

LO 5: Create Formulas and Use Functions

  • Create basic formulas
  • Use AutoSum
  • Apply common functions (AVERAGE, COUNT, MAX, MIN, ROUND)
  • Use relative and absolute references
  • Identify common formula errors

LO 6: Format Data

  • Format numbers and text
  • Use Format Painter

LO 7: Create Charts

  • Create charts
  • Move, resize, and delete charts
  • Edit chart elements

LO 8: Prepare and Print Worksheets

  • Use Spell Check
  • Set page layout and headers/footers
  • Preview worksheets
  • Set print areas
  • Use basic print options

Mode of Assessment

  • Written Assessment (Summative and Open Book)
  • Practical Assessment

Certification

Participants who fulfil the requirements of at least 75% attendance and pass their assessments at a competent level (refer to mode of assessment for details) in this Excel course will receive a Statement of Attainment (SOA) issued by the SkillsFuture Singapore (SSG).

Requirements

Minimum Entry

Learners are encouraged to:

  • Have basic knowledge on own work role and the corresponding responsibilities and limitations
  • Have minimum primary school education
  • Develop Writing, Reading, Listening and Speaking of English to a proficiency level equivalent to Workplace Literacy and Numeracy (WPLN) Level 2
  • Develop Numeracy skills to a proficiency level equivalent to Workplace Literacy and Numeracy (WPLN) Level 2
  • Have some work experience.

Our staff and course consultants attending course enquirers would screen interested trainees whether they fulfill the course pre-requisites which include the above WPLN levels. Learners who do not meet the WPLN Levels would be encouraged to take up the appropriate WPLN courses.

Who Should Attend

This course is intended for beginners with basic knowledge of using a spreadsheet application.

Course Overview

Course Objectives

This Microsoft Excel course provides learners with a fundamental understanding of spreadsheet concepts to effectively use the software. Participants will gain proficiency in developing, formatting, modifying, and utilising spreadsheets with standard formulas and functions. They will also demonstrate competence in creating and formatting insightful graphs and charts. This programme is WSQ-accredited and eligible for SkillsFuture Credit, Post-Secondary Education Account (PSEA), and NTUC Union Training Assistance Programme (UTAP) funding, making it an accessible investment in your digital literacy.

On completion of this Microsoft excel course, each learner will be able to:

  • Spreadsheet Management: Work confidently with spreadsheets, including saving them in various file formats.

Data Entry & Manipulation:

  • Enter data into cells and employ best practices for creating lists.
  • Efficiently select, sort, copy, move, and delete data.
  • Edit rows and columns within a worksheet.
  • Copy, move, delete, and appropriately rename worksheets.

Formula Creation:

  • Create mathematical and logical formulas using standard spreadsheet functions.
  • Apply best practices for formula creation and recognise common error values.

Formatting:

  • Format numbers and text content effectively within a spreadsheet.

Productivity & Presentation:

  • Utilise built-in options like the Help function to enhance overall productivity.
  • Choose, create, and format charts to communicate information meaningfully.

Printing & Review:

  • Adjust spreadsheet page settings for optimal presentation.
  • Thoroughly check and correct spreadsheet content before printing.
  • Set print areas for specific output requirements.
FAQs

Frequently Asked Questions about this Excel Course in Singapore

What level of proficiency will I achieve with this Microsoft Excel course?

This Excel course is designed for beginners and aims to equip you with a comprehensive understanding of core Excel functionalities. You'll gain proficiency in spreadsheet management, data entry, formula creation, formatting, and chart generation, providing a solid foundation for various professional tasks.

How do I use my SkillsFuture credit to offset the course?

To utilise your SkillsFuture Credit for this Excel course, you will need to submit your claim before the course start date.

  • Please visit the mySkillsFuture portal (www.myskillsfuture.gov.sg) and log in with your Singpass.
  • Navigate to "Submit SkillsFuture Credit Claims" and search for the course using the TGS Code provided in your invoice.
  • Select Food Safety Course Level 1 and enter the amount of SkillsFuture Credit you wish to claim, ensuring it matches the "SkillsFuture Credit" amount on your invoice.
  • Upload a copy of your invoice, review the details, agree to the terms, and submit your claim.
  • Finally, screenshot the Claim ID page and email it to your Coursemology agent for confirmation.
What are the benefits of taking a Microsoft Excel course in Singapore?

Proficiency in Excel is a highly valued skill across numerous industries in Singapore. Taking this course will boost your productivity, improve your ability to manage and analyse data, enhance your resume, and open up more career opportunities in data-driven roles.

Upcoming classes

Showing 6 of 6 upcoming runs. All shown runs are 9am - 6pm.

Related courses

Customer Management (SSO Level 3)

16 Hours

From S$156.00 Eligibility applies

Next class 8 Sep – 9 Sep 2026

This cleaning supervisor course is a core unit for the WSQ Advanced Certificate in Environmental Cleaning for professionals in the cleaning...

View dates & fees