Lesson 1 – Streamlining Workflow

  • Create a Macro
  • Edit a Macro
  • Apply Conditional Formatting
  • Add Data Validation Criteria
  • Update a Workbooks 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 Cells
  • Troubleshoot  Errors in Formulas
  • Troubleshoot  Invalid Data and Formulas
  • Watch and Evaluate Formulas
  • Create a data list outline
  • Restrict Document Access

Lesson 4 – Analyzing Data

  • Create a Trendline
  • Create Scenarios
  • Perform What if Analysis
  • 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 delimited text File

Lesson 7 – Using Excel with the web

  • Publish a Workbook to the web
  • Import data from the web
  • Create a web query

Lesson 8 – Structuring XML Workbooks

  • Develop XML Maps
  • Import, add and Export XML Data