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