Master VLOOKUP, implement data validation, perform forecasting analysis to evaluate multiple data scenarios, connect and coordinate multiple worksheets and workbooks, develop and use macros for automation, and learn many additional capabilities for spreadsheet excellence.
Complete Course Outline:
Lesson 1: Working with Multiple Worksheets and Workbooks
- Topic A: Establish Links and External References
- Topic B: Execute 3-D References
- Topic C: Consolidate Data From Varied Sources
Lesson 2: Using Lookup Functions and Formula Auditing
- Topic A: Deploy Lookup Functions
- Topic B: Trace Cell References
- Topic C: Monitor and Evaluate Formula Performance
Lesson 3: Sharing and Protecting Workbooks
- Topic A: Support Workbook Collaboration
- Topic B: Secure Worksheets and Workbooks
Lesson 4: Automating Workbook Functionality
- Topic A: Implement Data Validation
- Topic B: Find Invalid Data and Errors in Formulas
- Topic C: Create and Use Macros
Lesson 5: Creating Sparklines and Mapping Data
- Topic A: Build Sparkline Visualizations
- Topic B: Map and Display 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: Forecast Data Trends
