Advanced
Microsoft Excel 2003

Course Content

• Lesson 1: 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
• Lesson 2: Collaborating with Others
  • Protect Files
  • Share a Workbook
  • Set Revision Tracking
  • Review Tracked Revisions
  • Merge Workbooks
  • Adjust Macro Settings
  • Administer Digital Signatures
• Lesson 3: 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
• Lesson 4: 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
• Lesson 5: Working with Multiple Workbooks
  • Create a Workspace
  • Consolidate Data
  • Link Cells in Different Workbooks
  • Edit Links
• Lesson 6: Importing and Exporting Data
  • Export to Microsoft Word
  • Import a Word Table
  • Import Text Files
• Lesson 7: Structuring XML Workbooks
  • Develop XML Maps
  • Import, Add, and Export XML Data
  • Manage XML Workbooks
  • Apply XML View Options

---

All Excel Courses

Excel 2010 Classes	Excel 2007 Classes	Excel 2003 Classes
What's New in Excel 2010 > Introduction > Intermediate > Advanced >	What's New in Excel 2007 > Introduction > Intermediate > Advanced > Expert >	Introduction > Intermediate > Advanced >
		About Excel >

---