Course Outline
1 - Working with Multiple Worksheets & Workbooks
- Reference Cells and Groups of Cells Across Worksheets
- Link Cells to External Worksheets
- Consolidate Data Across Worksheets
2 - Using Lookup Formulas and Formula Auditing
- Search Rows or Columns Using LOOKUP Functions
- Display Relationships Between Cells and Formulas with the Trace Command
- Watch Cells and Formulas From the Watch Tool
3 - Sharing and Protecting Workbooks
- Collaborate on Workbooks
- Apply Varying Levels of Workbook Access and Protections
4 - Automating Workbook Functionality
- Create and Manage Validation Rules and Lists
- Search for Invalid Data and Formulas with Errors
- Record Macros to Automate Tasks
5 - Creating Sparklines and Mapping Data
- Create Sparklines to Show Trends
- Map Data
6 - Forecasting Data
- Determine Potential Outcomes Using Data Tables and Scenarios
- Solve for Desired Outputs with the Goal Seek Feature
- Forecast Data Trends
Target Audience
If you’re proficient in Excel 2016 and looking to master more advanced features, this course is for you.