Excel 2007 Basic

Target student

Students taking this course should be comfortable using a personal computer and
Microsoft Windows XP, Windows Vista, or preferably Windows 7. They should have
little or no experience using Microsoft Excel or any other spreadsheet program.
Students will get the most out of this course if their goal is to become proficient in using
Microsoft Excel to create basic worksheets and charts for data tracking and reporting.

After completing this course, students will know how to:

• Start Microsoft Excel; identify the main components of the Excel window and
  an Excel workbook; use the Help feature; and navigate worksheets.
• Enter and edit text, values, formulas; insert pictures in a worksheet; use
  AutoFill; and save and update a workbook.
• Move and copy data; insert and delete ranges; and work with relative and
  absolute references when creating and copying formulas.
• Use the SUM function, the AutoSum button, and the AVERAGE, MIN, MAX,
  COUNT, and COUNTA functions to perform calculations in a worksheet.
• Format text, numbers, rows, and columns in a worksheet; use conditional
  formatting; copy formats; and use table formats.
• Preview and control Page Setup options for a worksheet; check spelling; find
  and replace data; print a worksheet; and set and clear a print area.
• Create, format, modify, and print charts based on worksheet data.
• Manage large worksheets and multiple worksheets.