Lesson 1: Streamlining Workflow
     Update Workbook Properties
     Create a Macro
     Edit a Macro
     Apply Conditional Formatting
     Add Data Validation Criteria

Lesson 2: Collaborating with Other Users
     Protect Files
     Share a Workbook
     Set Revision Tracking
     Review Tracked Revisions
     Merge Workbooks
     Administer Digital Signatures
     Restrict Document Access

Lesson 3: Auditing Worksheets
     Trace Cells
     Troubleshoot Invalid Data and Formula Errors
     Watch and Evaluate Formulas
     Create a Data List Outline

Lesson 4: Analyzing Data
     Create a Trendline
     Create Sparklines
     Create Scenarios
     Perform a What-If Analysis
     Perform a 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 Excel Data
     Import a Delimited Text File
     Import and Export XML Data

Lesson 7: Integrating Excel Data with the Web
     Publish a Worksheet to the Web
     Import Data from the Web
     Create a Web Query

Appendix A: Creating Excel Forms
Appendix B: Microsoft Office Excel 2010 Exam 77–882
Appendix C: Microsoft Office Excel 2010 Expert Exam 77–888