Formulas and functions

[23 minutes total]

These eight tutorials show how to work with Excel's various formulas and functions, which are used to calculate totals, averages, etc. While the mathematical aspects of Excel often intimidate users, some basic knowledge in this area is often necessary to work with school and student data.

After viewing the tutorial(s), use the back key in your browser to return to this web site.

• Adding, subtracting, multiplying, and dividing numbers in cells (1:38)
• Using sum, count, countblank, counta, countif functions (6:21)
• Using AutoSum and calculating and copying cells with relative cell references (2:47)
• Calculating and copying cells with absolute cell references (1:23)
• Using average, median, mode, minimum and maximum functions and copying to other ranges (3:54)
• Using standard deviation, variance, and correlation functions (2:10)
• Calculating weighted averages(2:47)
• Graphing results(2:03)

You may need to turn off your browser's pop-up blocker or install the latest Flash plug-in to view these tutorials.