Friday, July 11, 2008

Working with Formulas and Functions: Developing a Family Budget

Excel techniques used:
  • Copy and paste formulas
  • Copy formulas using Auto Fill option
  • Change the zoom magnification of the workbook window
  • Use relative and absolute references
  • Use the Sum function
  • Use the Average function
  • Use the Date function
  • Use the PMT function
  • Apply what-if analysis
  • Use the IF function






(Zoom in by clicking the pictures)

No comments: