Excel 2007 and 2010 (level 3) [Course 5]

Four 2-hour classes for $20

Stream#396: Sue La Roche, Seminar Room, 2pm - 4pm, 3 places left

Mon/Thu, May 28, 31, Jun 07, 11, 2012

Outline

This course is intended to give the student an understanding of the basic skills required to create, edit, save and print spreadsheets using the MS Excel program which is in wide use in the commercial sector.

Background

Spreadsheets are mostly used for working financial data and making lists. Data is entered into the "cells" and using formulae it is possible to quickly sum, multiply, subtract, divide or apply a host of other functions to it. If new data is entered, or data is removed or altered, the spreadsheet automatically updates the results in the blinking of an eye.

Uses for This

• Household expenditure records
• Budgets
• Tracking investments
• Tax calculations
• Address lists
• Financial statements
• Analysing numerical data

Topics Covered Include

• The Excel interface,
• Excel terminology,
• Properties of cells,
• Manipulation of Windows
• Opening, saving and closing a spreadsheet
• Basic arithmetic functions demonstrated in a shopping list
• Print Preview and printing a spreadsheet

Skills Required

Students must have a good understanding of their Windows operating system and be competent with the mouse and keyboard. They should also be competent in basic formatting skills and the copy/paste routine.

Software Required

Students must have MS Excel 2007 or 2010 installed on their computers.

Notes

An advanced Excel course can be arranged following this course.