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

New Horizons Singapore Logo

Microsoft Access

Demonstrate that you have the skills needed to get the most out of Access by earning the Microsoft Office Specialist: Access Associate or Expert Certification. This certification demonstrates competency in database design principles.

by New Horizons Singapore [Claim Listing ]
SSDN Innovations Logo

Microsoft Excel

Microsoft Excel also can automate repetitive and labor intensive data management tasks using macros. SSDN Innovations provide Basic and Advanced Microsoft Excel Courses in an interactive and fun way with lots of Hands on practice.

by SSDN Innovations [Claim Listing ]
MYOB Training Centre Logo

Microsoft Excel

Excel remains as one of the most appealing software applications that the community around the world relies on till this day.

by MYOB Training Centre [Claim Listing ]
Intuition International Logo

Microsoft MS PowerPoint and MS Word (2013, 2016, 2019 and 365) for Office and Business Presentation

Our instructors are exclusive to us and we only engage excellent instructors to ensure all learners meet their individual needs and receive quality teaching. Our curriculum is unique and they include exercises to help participants retain knowledge for long-term use.

by Intuition International [Claim Listing ]
Ask Training Logo

Microsoft Excel Power Query, Data Model, Power Pivot & DAX (Intro)

This course introduces Microsoft Excel’s powerful data modeling and business intelligence tools: Power Query, Power Pivot, and Data Analysis Expressions (DAX). 

by Ask Training [Claim Listing ]

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