Site MapHelpFeedbackManaging and Analyzing a Workbook
Managing and Analyzing a Workbook


By the end of this lab students should know how to:

  • Correct worksheet errors.
  • Use absolute references.
  • Copy, move, name, and delete sheets.
  • Use AutoFill.
  • Reference multiple sheets.
  • Use Find and Replace.
  • Zoom the worksheet.
  • Split windows and freeze panes.
  • Use what-if analysis and Goal Seek.
  • Control page breaks.
  • Change page orientation.
  • Add custom headers and footers.
  • Print selected sheets and areas.










Microsoft Office 2007 SeriesOnline Learning Center

Home > Excel > Lab 3