Duration: 2 days / 17 hours
Time: 9am to 6pm
Course Code: CRS-Q-0030153-ES
TPGateway Course Code: TGS-2016500758

Funding available for this course:

Enhanced Training Support for SMEs  Post-Secondary Education Scheme (PSEA) Skills Development Fund (SDF) SkillsFuture Credit SkillsFuture Mid-Career Enhanced Subsidy

What Will Be Taught For This MS Excel Perform Spreadsheet Functions Course?

The Spreadsheets module allows candidates to understand the concept of spreadsheets and to demonstrate an ability to use a spreadsheet to produce accurate work outputs.

On completion of this module the candidate will be able to:

  • Work with spreadsheets and save them in different file formats, locally or in the cloud
  • Use available help resources, shortcuts and the go to tool to enhance productivity.
  • Create mathematical and logical formulas using standard spreadsheet functions. Use good practice in formula creation and recognize error values in formulas.
  • Format numbers and text content in a spreadsheet and use available autoformat/table styles.
  • Choose suitable charts, and create and format charts to communicate information meaningfully.
  • Adjust spreadsheet page settings and check and correct spreadsheet content before printing.
Module 1. Exploring Excel
  • Working with Excel
  • Starting Excel
  • Using the Office Button
  • Exploring Excel Options
  • Using the Ribbon
  • Hiding the Ribbon
  • Customizing the Quick Access Toolbar
  • Using the Mini Toolbar
  • Customizing the Status Bar
  • Exiting Excel
  • Labs
Module 2. Getting help
  • Using Microsoft Excel Help and Resources
  • Working with Excel Help
  • Looking Further for Answers
  • Labs
Module 3. Using Basic Workbook Skills
  • Selecting a Cell using the Keyboard
  • Using Key Tips
  • Scrolling using the Mouse
  • Using the Go To dialog box
  • Entering Text into Cells
  • Entering Numbers into Cells
  • Saving a New Workbook
  • Closing a Workbook
  • Creating a New Workbook
  • Using a Template
  • Opening an Existing Workbook
  • Using Data Entry Shortcuts
  • Editing Cell Entries
  • Checking Worksheet Spelling
  • Creating a New Folder
  • Renaming an Existing Workbook
  • Labs
Module 4. Working with Ranges
  • Working with Ranges
  • Selecting Ranges with the Mouse
  • Selecting Ranges with the Keyboard
  • Selecting Non-adjacent Ranges
  • Entering Values into a Range
  • Using the Auto Fill Feature
  • Labs
Module 5. Working with Columns and Rows
  • Selecting Columns and Rows
  • Using Narrow Columns Tooltips
  • Changing the Width of Columns
  • Changing the Height of Rows
  • Adjusting Columns Automatically
  • Hiding Columns and Rows
  • Unhiding Columns and Rows
  • Inserting a Column
  • Insert a Row
  • Deleting a Column
  • Deleting a Row
  • Labs
Module 6. Formatting Numbers
  • Using Number Formats
  • Using the Accounting Number Style
  • Using the Percent Style
  • Using the Comma Style
  • Changing Decimal Places
  • Labs
Module 7. Formatting Text
  • Changing an Existing Font
  • Modifying the Font Size
  • Using Bold and Italics
  • Underlining Text
  • Changing the Font Color
  • Rotating Text in a Cell
  • Wrapping Text in a Cell
  • Shrinking Text in a Cell
  • Changing Cell Alignment
  • Changing Text Indentation
  • Labs
Module 8. Formatting Cells
  • Using the Merge and Center Button
  • Changing the Vertical Alignment
  • Splitting Cells
  • Using the Borders Button
  • Drawing Cell Borders
  • Using the Fill Color Button
  • Pasting Formats
  • Using the Format Painter Button
  • Copying Formats to Non-Adjacent Cells
  • Clearing Formats
  • Inserting Selected Cells
  • Inserting Cut or Copied Cells
  • Deleting Selected Cells
  • Labs - Formatting Cells
Module 9. Creating Simple Formulas
  • Using Formulas
  • Entering Formulas
  • Using the AutoSum button
  • Using the AutoSum List
  • Inserting Functions in Formulas
  • Editing Functions
  • Using the AutoCalculate Feature
  • Using Range Borders to Modify Formulas
  • Checking Formula Errors
  • Using IF Function
  • Labs
Module 10. Copying and Moving Data
  • Copying/Cutting and Pasting Data
  • Copying and Pasting Formulas
  • Using the Paste Options Button
  • Using the Paste List
  • Using the Clipboard Task Pane
  • Creating an Absolute Reference
  • Filling Cells
  • Using Drag-and-Drop Editing
  • Using Undo and Redo
  • Labs
Module 11. Creating Charts
  • Using Charts
  • Creating Charts
  • Moving and Resizing Charts
  • Identifying Chart Elements
  • Changing the Chart Type
  • Swtich Row/Column
  • Removing/Adding a Legend
  • Moving the Legend
  • Charting Non-adjacent Ranges
  • Changing the Chart Range
  • Changing the Data Source
  • Changing the Chart Location
  • Printing a Chart
  • Labs
Module 12. Formatting Charts
  • Adding Chart Titles
  • Formatting Chart Title
  • Formatting Chart Elements
  • Changing the Text Orientation
  • Adding a Data Table
  • Creating an Exploded Pie Chart
  • Adjusting the 3D View
  • Deleting a Chart
  • Labs
Module 13. Managing Data
  • Sorting in Ascending/Descending Order
  • Finding Data
  • Replacing Data
  • Finding and Replacing Cell Formats
  • Labs
Module 14. Using Page Setup
  • Setting Margin and Centering Options
  • Changing the Page Orientation and Paper Size
  • Repeating Row and Column Labels
  • Scaling a Worksheet
  • Changing Page Breaks
  • Setting/Removing a Print Area
  • Changing Headers and Footers
  • Using Built-in Headers and Footers
  • Labs
Module 15. Printing
  • Previewing a Worksheet
  • Printing the Current Worksheet
  • Printing a Selected Range
  • Printing a Page Range
  • Printing Multiple Copies
  • Labs - Printing

Who Should Attend This MS Excel Perform Spreadsheet Functions Course Training?

Ideal for beginners in Microsoft Office Excel to develop a solid foundational understanding of spreadsheet concepts and applications.


An understanding of Windows / MS Excel 2003 will be an added advantage.

  w/o GST w GST
Course Fee $380 $406.60
Singapore Citizen & PR aged ≥ 21 years $91 $117.60
Singapore Citizen aged ≥ 40 years
(SkillsFuture Mid-Career Enhancement Funding)
$38 $64.60


  w/o GST w GST
Course Fee $380 $406.60
Singapore Citizen & PR aged ≥ 21 years $91 $117.60
Singapore Citizen aged ≥ 40 years
(SkillsFuture Mid-Career Enhancement Funding)
$38 $64.60


  w/o GST w GST
Course Fee $380 $406.60
Singapore Citizen & PR aged ≥ 21 years $38 $64.60
Singapore Citizen aged ≥ 40 years
(SkillsFuture Mid-Career Enhancement Funding)
$38 $64.60


Trainee shall be bound by the Terms and Conditions of any applicable funding scheme.

Please ensure that you have read our Terms and Conditions before submitting the enrolment form.

Please click on the course date to enrol.

  • CL: Classroom Learning
  • VILT: Virtual Instructor-Led Training
  • GTR: Guaranteed To Run
  • Sat: Saturday
  • Wkn: Weekend
Note: Courses are conducted via classroom unless stated otherwise beside the course dates.