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

NobleProg Training Institute Logo

Excel Advanced

The course participants will be able to efficiently use primarily data analysis tools such as scenarios and pivot tables, use the features to perform calculations on dates and text-processing functions, and create and adapt to the needs of macros to automate work with spreadsheets.

by NobleProg Training Institute [Claim Listing ]
Ccisg Logo

Microsoft Office 2016/2019/365 Timesaving Quick Tips

This course aims at equipping participants with timesaving tips and tricks in Microsoft Excel, Microsoft Word and Microsoft PowerPoint that will boost up their work productivity.

by Ccisg [Claim Listing ]
VTeach Logo

Microsoft PowerPoint (Advanced)

Upon completing this course, you will be able to customize the PowerPoint application, and effectively create, collaborate on, secure, and distribute complex multimedia presentations for a variety of situations.

by VTeach [Claim Listing ]
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 ]
New Horizons Singapore Logo

PowerPoint Training In Singapore

New Horizons has PowerPoint classes for any experience level. Learn the basics like template use and content placement, or up your skills by learning how to create custom slides with advanced transitions and animations.

by New Horizons Singapore [Claim Listing ]

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