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.

S$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

Check out more MS Excel courses in Singapore

Intuition International Logo

Microsoft MS Excel 2013, 2016, 2019 and 365 (Basic to Intermediate)

The reasons why our courses MS Office,is  the most popular course.

by Intuition International [Claim Listing ]
Koenig-Solutions Logo

Intermediate Microsoft Excel

The Intermediate Microsoft Excel Certification is an accreditation that underlines proficiency in utilizing Microsoft Excel at an intermediate level.

by Koenig-Solutions [Claim Listing ]
Intellisoft Logo

Microsoft Word 2016 Course (Basic)

At Intellisoft Training, an Approved Training Provides by SSG (formerly WDA Singapore), and a premium partner of ICDL Asia, we take pride in providing you with Quality WSQ Certifications in Microsoft Office – Word, Excel, PowerPoint Training Courses in Singapore.

by Intellisoft
St.Hua Private School Logo

Microsoft Excel Essentials

Microsoft Excel is a powerful yet user-friendly spreadsheet software. In this course, you will learn how to input and organize data, use functions to perform calculations, format the appearance of your data and cells, and build stunning charts and PivotTables.

by St.Hua Private School [Claim Listing ]
Ccisg Logo

MS Word Tips & Techniques

Despite the many alternatives that are out there, Microsoft Word remains one of the most popular word processors available. Such a popular tool should be easy to master, right?

by Ccisg [Claim Listing ]

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