Simple Spreadsheets - SS01

General Description

Spreadsheets give you the power to make maths easy! Create your own spreadsheets and throw your calculator away forever.

Target Audience

This session is intended for participants with little or no knowledge of Microsoft Excel.

Pre-requisites

Participants should have a basic understanding of using a computer including working with Windows, using a mouse, accessing the menus and file management.

Duration

3 hours

Learning Outcomes

• Start and Exit a spreadsheet package
• Create a new workbook
• Add data to a spreadsheet
• Select ranges of cells
• Navigate around a spreadsheet
• Print and save the workbook
• Change column widths and row heights
• Insert columns, rows and cells in a spreadsheet
• Delete columns, rows and cells in a spreadsheet
• Move data around a spreadsheet
• Copy data to another spreadsheet
• Create addition and subtraction formulae
• Create multiplication and division formulae
• Use AutoSum to calculate totals
• Use AutoFill to enter data into cells