Microsoft Excel Course

by Coursemology Claim Listing

Microsoft Excel Course in Singapore trains learners in the basic concept of spreadsheets and demonstrates the ability to use a spreadsheet application.

$457.8

Contact the Institutes

Fill this form

Advertisement

Coursemology Logo

img Duration

2 Days

Course Details

Microsoft Excel Course in Singapore trains learners in the basic concept of spreadsheets and demonstrates the ability to use a spreadsheet application.

Through this Microsoft office training, learners will understand and be able to accomplish tasks associated with developing, formatting, modifying, and using a spreadsheet and standard formulas and functions, and demonstrate competence in creating and formatting graphs or charts. Microsoft Excel will be used in this training.

 

Course Objectives

  • On completion of this Microsoft office Excel course,  each learner will be able to:

  • Work with spreadsheets and save them in different file formats;

  • Choose built-in options such as the Help function within the application to enhance productivity;

  • Enter data into cells and use good practice in creating lists. Select, sort and copy, move and delete data;

  • Edit rows and columns in a worksheet. Copy, move, delete and appropriately rename worksheets;

  • Create mathematical and logical formulas using standard spreadsheet functions. Use good practice in formula creation and recognise error values in formulas;

  • Format numbers and text content in a spreadsheet;

  • Choose, create and format charts to communicate information meaningfully;

  • Adjust spreadsheet page settings and check and correct spreadsheet content before finally printing spreadsheets;

 

Course Outline

Overview of Module

Getting Started

  • Features and uses of a spreadsheet application

  • Start and exit spreadsheet application

  • Create a workbook

  • Open and close a workbook

  • Switch between workbooks

  • Save a workbook

  • The Excel Screen

  • Display Toolbar/Ribbons

  • Use magnification/zoom

  • Set basic options and preferences

  • Use Help function

 

Insert Data and Select Cells

  • Enter text, numbers and date

  • Move around a worksheet

  • Cell selection techniques

 

Edit and Sort Data

  • Edit cell contents

  • Use Undo and Redo commands

  • Use Find and Replace commands

  • Sort data

 

Copy, Move and Delete Cell Contents

  • Use copy, cut and paste

  • Using Clipboard

  • Paste Special

Rows and Columns

  • Insert and delete rows and columns

  • Insert and delete cells

  • Modify column width and row heights

  • Freeze and unfreeze rows and columns

Worksheets

  • Turn on/off display of gridlines

  • Switching between worksheets

  • Select worksheets

  • Insert and delete worksheets

  • Copy, move and rename worksheets

 

Formulas

  • Create formula (Add, Subtract, Multiply, and divide)

  • Using mathematical operators (=, -, *, /)

  • Enter a formula

  • Use cell references in formula

  • East Branch

    300 Tampines Avenue 5, East
  • Central Branch

    Blk 190 Toa Payoh Lorong 6, Central
  • West Branch

    2 Venture Drive Vision Exchange,, West

© 2025 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy