ICDL - Perform Spreadsheet Functions (Excel 2019) - SkillsPortal.sg

ICDL - Perform Spreadsheet Functions (Excel 2019)

Eagle Infotech Consultants Pte Ltd

  • $588.50
    Unit price per 


On completion of this unit, the learner will have the knowledge and application skills in using a spreadsheet application. The skills include understanding fundamental spreadsheet concepts, designing a spreadsheet and using basic functions within a spreadsheet.

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

Training Delivery Methodology

The training delivery approaches used in this unit include the following:

Mini lectures - to succinctly explain the concepts and theories supporting the Deliver Service Excellence module.

Individual exercises for practical activities.

Assumed Skills And Knowledge

Be able to operate a personal desktop computer.

Be able to listen and speak English at a proficiency level equivalent to the Employability Skills Workforce Skills Qualifications (“ES WSQ”) Workplace Literacy (“WPL”) level 4.

Be able to read and write English at a proficiency level equivalent to ES WSQ WPL level 4.

Be able to manipulate numbers at a proficiency level equivalent to ES WSQ Workplace Numeracy (“WPN”) level 4.

 

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/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 cell

Modify column width and row heights

Freeze and unfreeze rows and column

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, Divide)

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

Enter a formula

Use cell references in formula

Functions

Using Functions

Use AutoSum

Use AVERAGE, COUNT, MAX, MIN, COUNTA and ROUND functions

Use Logical function

Relative and absolute referencing

Display and print formulas

Common error messages in formula

Formatting

Format number and text

Format number and text

Using Format Painter

Charts

Create a chart

Move, re-size and delete a chart

Edit a chart

Worksheet Setup

Use the Spell-check command

Adjust page options

Add Header and Footer

Change sheet display options

Printing

Preview a worksheet

Use basic print options

Set print area

Funding


Additional Info

Course Funding Period : 12 Oct 2020 To 30 Jan 2022

Course Code : TGS-2020503519

Customer Reviews

No reviews yet
0%
(0)
0%
(0)
0%
(0)
0%
(0)
0%
(0)