A three hour course in Spreadsheets

 

 


Introduction 10

Assessment of students 10

Health and safety 10


Spread sheets their main usage

Numbers 10

Brainstorming 10

Basic Design 10


BREAK 1 10

The importance of Design and getting it right

The focus of using Excel is accuracy and understanding coupled with the layout of results.


Opening the program 10

Adding shortcuts to the start menu 10

Creating a new document

Give it a name immediately

F12 and CTRL S

Save regularly

Make different versions as you work 10


A description of the layout of the program

TOOLBARS

Controlling the program layout. 10

Cells

Columns and Rows

Labelling / Naming 10

BREAK 2 10

Entering Text and numbers in to cells

Formatting data types
Numbers, Currency, Date and TEXT 10

Formulas

Entering RELATIVE cell references 10

Entering ABSOLUTE cell references 10

The SUM and AUTO SUM functions 10

Formatting results 10


END

http://www.usd.edu/trio/tut/excel/quiz.html