ICDL – Perform Spreadsheet Functions (Microsoft Excel) Core Level 3-days

COURSE synopsis

Course Details

Course Duration

24 HRS

Course Reference Number

N.A

Funding Validity Period

Mode of Training

Classroom

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
Course Outline

Download the PDF below for a summary of the course outline.

COURSE FEES

Company Sponsored / Self Sponsored

Full Fee GST Nett Fee Payable (incl. GST)
$500 $45 $545

REGISTER TODAY

Looking at in-house training or have an enquiry? Contact us!

Related Courses

IT

8 HRS

Non-Certifiable

IT

24 HRS

WSQ

IT

24 HRS

WSQ

GET IN TOUCH WITH US

Have an enquiry? Feel free to connect via any of the channels below.

enquiry form

Leave a message

WhatSAPP

Chat on WhatsApp at
+65 8776 7397

Training hotline

Give us a call at
+65 6737 5761

SHARE THIS COURSE