Microsoft Excel 2016 – Level 1 EssentialsIT Short Courses

Enquire MoreRegister NowCorporate Courses

DurationTwo days
Course Dates18 Jan 2024 9:00am - 19 Jan 2024 5:00pm
11 Apr 2024 9:00am - 12 Apr 2024 5:00pm
18 Jul 2024 9:00am - 19 Jul 2024 5:00pm
17 Oct 2024 9:00am - 18 Oct 2024 5:00pm

Course Fee

Member $277.95
Non-Member $327.00
  • Members enjoy a 15% discount before GST
  • Group Discount (5 or more participants) - 10%
  • Course fees updated with 9% GST for 2024

Funding Available

    SDF Grant Amount: S$28.00
    Course Reference No.: TGS-2020500481
    SkillsFuture Credit
    (Individual Singaporean aged 25 and above)
    Pre-approved SkillsFuture funding of S$500.00

Click HERE for more info on SkillsFuture.

Microsoft Excel Course


Microsoft’s Excel is more than just an online spreadsheet. From its humble beginnings, the Excel program is now the main online spreadsheet employed by everyone. Be it simple home accounting to modular solutions in major corporations, Excel is used by everyone everywhere on an everyday basis. For anyone who works with numbers and are seeking to present them in a coherent, tabulated format for analysis, this Excel course is for you. After attending our Excel course physically or online, participants will be familiar with the workings of Excel and confidently produce spreadsheets and calculated totals.

No prior knowledge of Microsoft Excel is required for this course here in Singapore. However, participants will need to be familiar with basic operations of a PC, such as using a mouse and managing of program files and folders. A combination of lectures, explicit teaching, practical demonstrations, and peer teaching are applied to deliver this Excel course.

Key Takeaways

Upon completion of this workshop, participants will be able to;

  • Forms an excellent formal introduction to Microsoft Excel
  • Learn the art of number crunching in a spreadsheet
  • Be familiar with the workings of Excel
  • Be able to confidently produce spreadsheets and calculated totals

Who Should Attend

Anyone who works with numbers and are seeking to present them in a coherent, tabulated format for analysis.

Programme Outline

Module 1: Excel Basics

  • Interface, Ribbon & Quick Access Toolbar
  • Using the File Tab
  • Opening & Saving Excel Files
  • Spreadsheet Layout & Navigation
  • Getting Help

Module 2: Data Entry

  • Selecting Cells
  • Entering, Editing & Deleting Data
  • Data Entry Shortcuts
  • Moving & Copying Data
  • Using Paste Options

Module 3: Worksheets & Workbooks

  • Workbook Organisation
  • Worksheet Organisation

Module 4: Formatting

  • Columns & Rows
  • Text Formatting
  • Alignment, Wrapping and Indentation
  • Numbers
  • Borders & Shading
  • Clearing Formatting
  • Applying Cell Styles
  • Using the Format Painter
  • Working with Themes
  • Using Conditional Formatting
  • Formatting & Applying Table Styles
  • Formulas & Functions
  • Formulas in Excel
  • Functions

Module 5: Charts

  • Introduction to Charts in Excel
  • Building Basic Charts
  • Chart Editing & Formatting
  • Working with Quick Analysis
  • Inserting Sparklines

Module 6: Printing

  • Print Options
  • Print Preview
  • Printing Charts

Module 7: Templates

  • Using Templates
  • Creating & Modifying Templates
  • Saving on Existing Workbook as a Template

Module 8: Protections

  • Overview of Data Protection
  • Locking & Hiding Cells
  • Setting Spreadsheet Passwords
  • Worksheet & Workbook Protection
  • File Protection


No foreknowledge of Excel is required. Participants need only be familiar with the operations of a PC, such as mouse handling and file management.

A combination of lectures, explicit teaching, practical demonstrations and peer teaching is applied to this course.


Course Enquiry

For more information on our Excel courses here in Singapore, please complete the enquiry form.

If you are interested in this corporate programme, please complete the following form and one of our representatives will get back to you as soon as possible.

I would like to receive marketing, advertising and promotional messages via:
(Please untick if you do not wish to receive)

MDIS values your privacy and we are committed to safeguarding your personal data in compliance with the Personal Data Protection Act 2012. By providing your personal details, you have authorised MDIS to share with you our marketing, advertising and promotional materials.

Quick Information

Excel is very much more than just a spreadsheet. In the very real sense of the word, Excel is a "number-cruncher", the likes of which have only been equalled by Lotus 1-2-3 and which it has now surpassed.

Contact Details

  +65 6842 6666