YCEN and BNC Excel Basics

This program will cover the following
  1. Reviewing where you are currently at with Excel
  2. Performing basic calculations such as adding up columns of data, average, maximum, minimum
  3. Formatting worksheets and data to suit a range of needs
  4. Functions - strategies to learn how to use this powerful component of Excel
  5. Downloading and analysis from online data repositories such as Bureau of Meteorology and Australian Bureau of Statistics
  6. Inserting graphics objects using the drawing toolbar
  7. Creating hyperlinks to web based resources

The Range of Uses of Excel

Excel as a decision support tool -
Excel for fun! - pascals triangle activity - tutor will supply necessary files

Week 1 Some Review Activities

Week 2

Week 2 notes

Entering a Formula

· Click the cell where you want the result to be displayed
· Type = and then type the rest of the formula
· When entering a cell reference in a formula use the mouse to select the cell or range
· When the formula is complete, press the enter key.

An example of how to enter the SUM function

Type = to begin the function
Type SUM in either uppercase or lowercase letters, followed by an opening bracket. Do not put a space between SUM and the bracket
Drag the mouse to outline the cells you want to sum
Press enter key
Eg =SUM(A4:D4) will add up the cells A4, B4, C4 and D4

Excel exercise 2
Excel exercise 3
Excel exercise 4
Excel exercise 5
Excel exercise 6

Weeks 3 and 4

Excel exercise 7
Excel exercise 8
Excel exercise 9
Excel exercise 10
Excel exercise 11
Excel exercise 12
Excel exercise 13
Excel exercise 14

and here are the answers

Some useful web resources

Excel intermediate online tutorials by Atomic learning

Microsoft Excel modules by Internet for classrooms

Extension: Beechworth Climatic Data

Access the Bureau of Meteorology website and see if you can download the comma separated values (.csv) data for the climate station at Beechworth

There is a wealth of information here from which to construct charts
Start by drawing a line graph of highest, lowest and mean maximum temperatures