Excel 2010 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 and identify the components of the Excel interface; open
  an Excel workbook; use the Help window; and navigate worksheets.
• Enter and edit text, values, and formulas; examine the order of operations; insert
  pictures; use AutoFill; save and update a workbook; and save a workbook as a
  PDF file.
• Move and copy data and formulas; use the Office Clipboard; use Paste Link;
  work with relative and absolute references; and insert and delete ranges, rows,
  and columns.
• Use the SUM function, AutoSum, and the AVERAGE, MIN, MAX, COUNT,
  and COUNTA functions to perform calculations in a worksheet.
• Format cells, rows, and columns; merge cells; apply color and borders; format
  numbers; create conditional formats; copy formatting; apply table styles; sort
  data; and use Find and Replace to update the formatting for specific content.
• Check spelling; find and replace text and data; preview and print a worksheet;
  set page orientation and margins; create and format headers and footers; and
  print gridlines.
• Create, format, modify, and print charts based on worksheet data; work with
  various chart elements; and apply chart types and chart styles.
• Freeze panes and split a worksheet; open and arrange a new window with the
  current worksheet content; hide and unhide data; set print titles and page breaks
  to optimize print output; insert different even and odd headers; and manage
  multiple worksheets.
• Represent data graphically within cells by applying three forms of conditional
  formatting (data bars, color scales, and icon sets); insert and modify SmartArt
  graphics; and insert and modify screenshots.