Spreadsheets Lecture: Microsoft Excel

What are Spreadsheets?

Main reasons to use a spreadsheet

  1. MASTER RULE #1: Easy to change figures and recalculate automatically
  2. Easy to perform calculations on large number of items
  3. Can perform simple or complex mathematical functions (eg. average, standard deviation, sum)

Workbook Layout

A document in Excel is called a workbook.

Getting Help

Entering Info

Editing Worksheets

Cell Addressing



  1. Select area to sort
  2. Choose Sort from the Data menu
  3. Select 1st key to sort on
  4. Choose ascending (A-Z) or descending (Z-A) order

What-if? Scenarios

Charts (Graphs)

Back to Table of Contents