Excel Resources

Introduction and Basic Formatting

  • simple formatting of cells
  • dates (helpful for compound interest!)

Cells and Sheets

  • copy/paste, sorting data, freeze panes

Formulas and Cell References

  • absolute and relative cell references in formulas

Analyzing Data

  • importing data into Excel
  • boxplots, histograms
  • scatterplots and best fits

 

Course Specific Materials