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

Excel - Lesson 1

Lesson 1: Intro/Explore

Excel - Lesson 2

Lesson 2: More Exploration

Excel - Lesson 3

Lesson 3: Printing

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

Icey Slicey Parlour.pdf

Babysitting

Babysitting Memo.pdf

Beach Spreadsheet

Beach Memo.pdf