Topic A: Use Links and External References

Topic B: Use 3-D References

Topic C: Consolidate Data

Topic A: Use Lookup Functions

Topic B: Trace Cells

Topic C: Watch and Evaluate Formulas

Topic A: Collaborate on a Workbook

Topic B: Protect Worksheets and Workbooks

Topic A: Apply Data Validation

Topic B: Search for Invalid Data and Formulas with Errors

Topic C: Work with Macros

Topic A: Create Sparklines

Topic B: Map Data

Topic A: Determine Potential Outcomes Using Data Tables

Topic B: Determine Potential Outcomes Using Scenarios

Topic C: Use the Goal Seek Feature

Topic D: Forecasting Data Trends