The University of Waikato - Te Whare Wānanga o Waikato
Student Learning
Waikato Home Waikato Home > Student Life > Student Learning  > Help with technology
Staff + Student Login

Student Learning: Technology

Spreadsheets 5 - Excel

Here is a video by Phil from CompuCrackers from Youtube.

Video source: Microsoft Excel Tutorial 8 - using Min, Max, and Avg formulas.

This video includes:
  1. Dragging and dropping a row of sums
  2. Formula for finding the minimum value over a range of cell data
  1. Revision: autofill the formula over a whole row
  1. Formula for finding the maximum value over a range of cell data
  2. Formula for finding the average value over a range of cell data
  3. Changing the appearance of the figures in the cells using the Number feature on the Excel ribbon
  4. Quickkeys: the demonstrator uses Ctrl+~ (tilde) (to view all formulae in the spreadsheet), and Ctrl+↵ (enter) (to render a sum while still remaining in the current working cell)