Course Outline for Microsoft Office Excel 2003, Level 3

  • Streamlining Workflow
    • Create a Macro
    • Edit a Macro
    • Customize Access to Excel Commands
    • Apply Conditional Formatting
    • Add Data Validation Criteria
    • Update a Workbook's Properties
    • Modify Excel's Default Settings
  • Collaborating with Others
    • Protect Files
    • Share a Workbook
    • Set Revision Tracking
    • Review Tracked Revisions
    • Merge Workbooks
    • Adjust Macro Settings
    • Administer Digital Signatures
  • Auditing Worksheets
    • Trace Cell Precedents
    • Trace Cell Dependents
    • Locate Errors in Formulas
    • Locate Invalid Data and Formulas
    • Watch and Evaluate Formulas
    • Group and Outline Data
  • Analyzing Data
    • Create a Trendline
    • Create Scenarios
    • Perform What-If Analysis
    • Develop a PivotTable© Report
    • Develop a PivotChart© Report
    • Perform Statistical Analysis with the Analysis ToolPak
  • Working with Multiple Workbooks
    • Create a Workspace
    • Consolidate Data
    • Link Cells in Different Workbooks
    • Edit Links
  • Importing and Exporting Data
    • Export to Microsoft Word
    • Import a Word Table
    • Import Text Files
  • Structuring XML Workbooks
    • Develop XML Maps
    • Import, Add, and Export XML Data
    • Manage XML Workbooks
    • Apply XML View Options