Excel Advanced

Learn VLOOKUP, data validation, forecasting data and potential outcomes, linking multiple worksheets and workbooks, macros, & more!

Course Outline:

Lesson 1: Working with Multiple Worksheets and Workbooks

• Topic A: Use Links and External References
• Topic B: Use 3-D References
• Topic C: Consolidate Data

Lesson 2: Using Lookup Functions and Formula Auditing

• Topic A: Use Lookup Functions
• Topic B: Trace Cells
• Topic C: Watch and Evaluate Formulas

Lesson 3: Sharing and Protecting Workbooks

• Topic A: Collaborate on a Workbook
• Topic B: Protect Worksheets and Workbooks

Lesson 4: Automating Workbook Functionality

• Topic A: Apply Data Validation
• Topic B: Search for Invalid Data and Formulas with Errors
• Topic C: Work with Macros

Lesson 5: Creating Sparklines and Mapping Data

• Topic A: Create Sparklines
• Topic B: Map Data

Lesson 6: Forecasting 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