ICDL - Perform Spreadsheet Functions (Excel 2019)
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