Manage Data
Microsoft Excel
Manipulation of data into a spreadsheet is a SURVIVAL tool for life - making calculations via formula then extracting certain information to produce correctly labelled graphs.
SELF-PACED LESSONS
GRAPHS
Line Graph use this to show a trend within the data.
Column Graph use these when the counting of different things is involved – comparisons.
Pie Graph use this to show % figures (proportions).
REVIEW
All formulae start with the = sign.
When using spreadsheets we use formulae to make calculations. The basic formulae are: addition, subtraction, multiplication and division.
The symbols used are +, -, *, /.
If applying formula to a cell range (3 or more) ensure you show this: (for example)
=SUM(B5:D5) NOT =SUM(B5+C5+D5)
Only use + when adding TWO cells together. Example: =C6+C7
When calculating AVERAGES, MAXIMUMS OR MINIMUMS you write in: =AVERAGE(B2:F2), =MIN(B2:F2) Or you can use the Autosum feature.
How to SHOW FORMULAS for printing use <CTRL> + ~
Another great tip is Wrapping Text in a cell
EXEMPLARS
Icey Slicey Parlour
Babysitting
Beach Spreadsheet