Bill Rosener, Ph.D.
Home CV Teaching Portfolio Woodturning Contact

Microsoft Excel 2007: Working with Formulas (Grades)

In this video, you will learn how to write Microsoft Excel formulas to compute the data shown in the red circled area above. Skills covered in this video include:

  1. Freezing panes
  2. Copying and pasting formulas
  3. Modifying borders
  4. Creating the following Microsoft Excel formulas:
    • Sum - adds all the numbers in a range of cells
    • If - returns one value if a condition you specify evaluates to TRUE and another value if it evaluates to FALSE.