Lesson 1: Streamlining Workflow

Topic 1A: Create a Macro
Topic 1B: Edit a Macro
Topic 1C: Combine Macros
Topic 1D: Intro to VBA Code
Topic 1E: Options to Run a Macro

Lesson 2: Collaborating with Others

Topic 2A: Protect Sheets and Workbooks
Topic 2B: Restrict Document Access
Topic 2C: Share a Workbook
Topic 2D: Track Changes - Apply and Review
Topic 2E: Merge Workbooks

Lesson 3: Auditing Worksheets

Topic 3A: Trace Cells
Topic 3B: Troubleshoot Errors in Formulas
Topic 3C: Evaluate Formulas and Error Options
Topic 3D: Create a Watch Window
Topic 3E: Remove Duplicates

Lesson 4: Analysis Tools and Add-Ins

Topic 4A: Conditional Formatting
Topic 4B: Find Solutions with Goal Seek
Topic 4C: Create Scenarios
Topic 4D: Solver Add-In

Lesson 5: Managing Data

Topic 5A: Create a Data List Outline
Topic 5B: Consolidate Data
Topic 5C: Data Validation
Topic 5D: Convert Text to Columns
Topic 5E: Link Cells in Different Workbooks

Lesson 6: Importing and Exporting Data

Topic 6A: Export Excel Data
Topic 6B: Import a Delimited Text File
Topic 6C: Import Data from the Web
Topic 6D: Publish a Workbook to the Web
Topic 6E: User Created Templates