Excel Spreadsheet Index Page
Excel is a very powerful and useful tool. It will allow you to
- enter data
- do multiple calculations with that data
- plot graphs to show relationships between your data items
- sort your data into order
Here is a useful summary of the commonest formulae you will use and here is a list of some useful 'shortcuts'
| Lesson 1 |
- The Spreadsheet Layout - Cells, columns and rows |
| Lesson 2 |
- Column headings - adjusting the width of columns and height of rows - sorting data alphabetically . |
| Lesson 3 |
- Using simple formulae and formatting numbers.
|
Lesson 4
The number square |
- Using absolute cell references and filling down formulae - protection |
Lesson 5
A Kiddie table calculator |
- Using absolute cell references and filling down formulae - protection - merging cells |
| Lesson 6 |
- Displaying your data in charts |
