Course Name

ICDL Module 4 - Spreadsheets

Overview

This course will ensure learners gain International recognition for their computer skills.

Course Objectives

► Using the application
♦ First steps with Spreadsheets
♦ Open (and close) a spreadsheets application
♦ Open one, several spreadsheets
♦ Create a new spreadsheet (default template)
♦ Save a spreadsheet to a location on a drive
♦ Save a spreadsheet under another name
♦ Save a spreadsheet in another file type such as: text file, HTML, template, software specific file extension, version number
♦ Switch between worksheets, open spreadsheets
♦ Use available Help functions
♦ Close a spreadsheet

♦ Adjust Settings
♦ Use magnification/zoom tools
♦ Display, hide built-in toolbars
♦ Freeze, unfreeze row and/or column titles
♦ Modify basic options/preferences in the application: user name, default directory/folder to open, save spreadsheets

► Cells
♦ Insert data
♦ Select Cells
♦ Enter a number, date, text in a cell
♦ Select a cell, range of adjacent cells, range of non-adjacent cells, entire worksheet
♦ Select a row, range of adjacent rows, range of non-adjacent rows
♦ Select a column, range of adjacent column, range of non-adjacent columns

♦ Rows and Columns
♦ Insert rows, columns in a worksheet
♦ Delete rows, columns in a worksheet
♦ Modify column widths, row heights

♦ Edit data
♦ Insert additional cell content, replace existing cell content
♦ Use the undo, redo command

♦ Duplicate, Move, Delete
♦ Duplicate the content of a cell, cell range within a worksheet, between worksheets, between open spreadsheets
♦ Use the autofill tool/copy handle tool to copy, increment data entries
♦ Move the contents of a cell, cell range within a worksheet, between worksheets, between open spreadsheets
♦ Delete cell contents

♦ Search and Replace
♦ Use the search command for specific content in a worksheet
♦ Use the replace command for specific content in a worksheet

♦ Sort Data
♦ Sort a cell range by one criterion in ascending, descending numeric order, ascending, descending alphabetical order

► Worksheets
♦ Handling Worksheets
♦ Insert a new worksheet
♦ Rename a worksheet
♦ Delete a worksheet
♦ Duplicate a worksheet within a spreadsheet, between open spreadsheets
♦ Move a worksheet within a spreadsheet, between open spreadsheets

► Formulas and Functions
♦ Arithmetic Formulas
♦ Generate formulas using cell references and arithmetic operators (addition, subtraction, multiplication, division)
♦ Recognize and understand standard error values associated with using formulas

♦ Cell Referencing
♦ Understand and use relative, mixed, absolute cell referencing in formulas
♦ Working with Functions
♦ Generate formulas using sum, average, minimum, maximum, count, functions
♦ Generate formulas using the logical function IF (yielding one of two values)

► Formatting
♦ Numbers/Dates
♦ Format cells to display numbers to a specific number of decimal places, to display numbers with, without commas to indicate thousands
♦ Format cells to display a date style
♦ Format cells to display a currency symbol
♦ Format cells to display numbers as percentages

♦ Contents
♦ Change cell content appearance: Font sizes, font types
♦ Apply formatting to cell contents such as: bold, italic, underline, double underline
♦ Apply different colours to cell content, cell background
♦ Copy the formatting from a cell, cell range to another cell, cell range
♦ Apply text wrapping to contents within a cell

♦ Alignment, Border Effects
♦ Align contents in a cell, cell range: left, centre, right, top, bottom
♦ Centre a title over a cell range
♦ Adjust cell content orientation
♦ Add border effects to a cell, cell range

► Charts/Graphs
♦ Using Charts/Graphs
♦ Create different types of charts/graphs from spreadsheet data: column chart, bar chart, line chart, pie chart
♦ Add a title, label to the chart/graph. Remove the title, label from the chart/graph
♦ Change the background colour in a chart/graph
♦ Change the column, bar, line, pie slice colours in the chart/graph ♦ Change the chart/graph type
♦ Duplicate, move charts/graphs within a worksheet, between open spreadsheets ♦ Resize, delete charts/graphs

► Prepare Outputs
♦ Worksheet Setup
♦ Change worksheet margins: top, bottom, left, right
♦ Change worksheet orientation: Portrait, landscape.
♦ Change paper size
♦ Adjust page setup t fit worksheet contents on one page, on a specific number of pages
♦ Add, modify text in Headers, Footers in a worksheet
♦ Insert fields: page numbering information, date, time, file name, worksheet name into Headers, Footers

♦ Preparation
♦ Understand the importance of checking spreadsheet calculations and text before distribution
♦ Preview a worksheet
♦ Turn on, off display of gridlines, display of row and column headings for printing purposes
♦ Apply automatic title row(s) printing on every page of a printed worksheet

♦ Printing
♦ Print a cell range from a worksheet, an entire worksheet, number of copies of a worksheet, the entire spreadsheet, a selected chart

Target Group

This course targets all learners who wish to gain International recognition for their computer skills.

Minimum Delegates

8 Delegates

Maximum Delegates

12 Delegates

Accreditation

Number of Days

1 Day

Learning Approach

Practical - Computer will be provided if delegates do not have laptops.

Cost per Delegate

R500 (Fees Exclude Manuals and Exam Fees)

Send an Enquiry Form

Click here to close Window