Excel 2007 (Intermediate)

Description:

Outline:

• Unit 1: Using multiple worksheets and workbooks
  • Topic A: Using multiple workbooks
  • Topic B: Linking worksheets with 3-D formulas
  • Topic C: Linking workbooks
  • Topic D: Managing workbooks

• Unit 2: Advanced formatting
  • Topic A: Using special number formats
  • Topic B: Using functions to format text
  • Topic C: Working with styles
  • Topic D: Working with themes
  • Topic E: Other advanced formatting

• Unit 3: Outlining and subtotals
  • Topic A: Outlining and consolidating data
  • Topic B: Creating subtotals

• Unit 4: Cell and range names
  • Topic A: Creating and using names
  • Topic B: Managing names

• Unit 5: Lists and tables
  • Topic A: Examining lists
  • Topic B: Sorting and filtering lists
  • Topic C: Advanced filtering
  • Topic D: Working with tables

• Unit 6: Web and Internet features
  • Topic A: Saving workbooks as Web pages
  • Topic B: Using hyperlinks
  • Topic C: Distributing workbooks

• Unit 7: Advanced charting
  • Topic A: Chart formatting options
  • Topic B: Combination charts
  • Topic C: Graphic elements

• Unit 8: Documenting and auditing
  • Topic A: Auditing features
  • Topic B: Comments in cells and workbooks
  • Topic C: Protection
  • Topic D: Workgroup collaboration

• Unit 9: Templates and settings
  • Topic A: Application settings
  • Topic B: Built-in templates
  • Topic C: Creating and managing templates

--------------

Please note that the material taught at some locations may differ slightly from the outline shown above. Please contact your local ExecuTrain office if you have any questions about specific course content.