Excel 2007 Intermediate

Target student

Before taking this course, students should be comfortable using a personal computer
and Microsoft Windows (preferably Windows 7). Students should have some
experience using Microsoft Excel. Students will get the most out of this course if their
goal is to become proficient in such tasks as consolidating data, using advanced chart
formatting options, sorting and filtering data, using special formatting options, using
templates, using error tracing features, protecting worksheets, and linking worksheets and
workbooks.

After completing this course, students will know how to:

• Link worksheets by using 3-D formulas; add a Watch window; create and
  manage links between workbooks; and create a workspace.
• Apply special and custom number formats; control the display of zero values;
  use functions to format text; create, apply, and modify styles; apply and modify
  themes; merge and split cells; change the orientation of data in cells; transpose
  data; and add background color and a watermark.
• Create an outline and consolidate data; create subtotals in a list; and use multiple
  subtotal functions.
• Define and apply cell and range names; use names in formulas; and define and
  apply 3-D names.
• Sort lists by columns; filter lists based on complex criteria and copy filtered
  results to another range; create and format a table and add rows and columns;
  apply structured referencing; name tables; and create functions with [#This row].
• Save and publish a worksheet as a Web page; insert and edit hyperlinks; publish
  a worksheet as a PDF file, and send a worksheet as an e-mail attachment.
• Format data points; create combination charts and trendlines; and add and
  format graphic elements.
• Use auditing features; add comments to cells and workbooks; protect a
  worksheet or part of a worksheet; share, merge, and track changes in a
  workbook; find and remove hidden and personal data from a workbook; and
  mark a workbook as final.
• Change Excel’s default application settings; work with Excel templates; and
  create and manage templates.