Excel


 * Using Excel**

Can you produce a simple spread sheet like this one below. If you can that's great - if not let me know and I'll show you how.



1.To add a column up e.g. Test 1 click in the cell at the bottom of the figures and use the symbol that looks a bit like > or type in =sum(click on first cell) and the type a : and then click on last cell in row and finish with a ). So it looks like this =sum(B3:B10) and then just press enter.
 * Simple Formula:**

2.To subtract use - so it looks like this =B3-B10

3.To divide use / so it looks like this =B3/B10

4. To multiple use * so it looks like this =B3*B10

5.To average use average e.g. =average(B3:B10)

6. To find a maximum e.g. =mas(B3:B10)

7. To find the minimum e.g. =min(B3:B10)

These are seven of the most basic formula so have a go with these first. Remember always click on the cell rather than type the cell number as it leaves less room for error.


 * NOW** here's a little trick. Once you have completed a formula e.g. adding up a row of numbers say under Test 1 of this example you can click on the cell that had completed the adding which shows at 511. If you put the mouse to the bottom right hand corner of the cell you will get a little black + - click on that and drag across the row and all your formulas will copy across which saves a bit of time and ensures accuracy.

To make a graph highlight what you want to graph (don't include totals!) and then choose insert on the tool bar. The graph option wil come up. Stick to a column graph or pie graph until you get used to working with the programme.

This in a nutshell are some simple instructions - you just need to try then and ask questions if you get stuck.

Good luck!