Excel 3

Topics:

Lesson 1: Streamlining Workflow

• Topic 1A: Create a Macro
• Topic 1B: Edit a Macro
• Topic 1C: Customize Access to Excel Commands
• Topic 1D: Apply Conditional Formatting
• Topic 1E: Add Data Validation Criteria
• Topic 1F: Update a Workbook’s Properties
• Topic 1G: Modify Excel’s Default Settings

Lesson 2: Collaborating with Others

• Topic 2A: Protect Files
• Topic 2B: Share a Workbook
• Topic 2C: Set Revision Tracking
• Topic 2D: Review Tracked Revisions
• Topic 2E: Merge Workbooks
• Topic 2F: Adjust Macro Settings
• Topic 2G: Administer Digital Signatures

Lesson 3: Auditing Worksheets

• Topic 3A: Trace Cell Precedents
• Topic 3B: Trace Cell Dependents
• Topic 3C: Locate Errors in Formulas
• Topic 3D: Locate Invalid Data and Formulas
• Topic 3E: Watch and Evaluate Formulas
• Topic 3F: Group and Outline Data

Lesson 4: Analyzing Data

• Topic 4A: Create a Trendline
• Topic 4B: Create Scenarios
• Topic 4C: Perform What-If Analysis
• Topic 4D: Develop a PivotTable© Report
• Topic 4E: Develop a PivotChart© Report
• Topic 4F: Perform Statistical Analysis with the Analysis ToolPak

Lesson 5: Working with Multiple Workbooks

• Topic 5A: Create a Workspace
• Topic 5B: Consolidate Data
• Topic 5C: Link Cells in Different Workbooks
• Topic 5D: Edit Links

Lesson 6: Importing and Exporting Data

• Topic 6A: Export to Microsoft Word
• Topic 6B: Import a Word Table
• Topic 6C: Import Text Files

Lesson 7: Structuring XML Workbooks

• Topic 7A: Develop XML Maps
• Topic 7B: Import, Add, and Export XML Data
• Topic 7C: Manage XML Workbooks
• Topic 7D: Apply XML View Options