This course is being held online with a live instructor. Students will have access to training labs after the course as well.
Contact us for additional dates held monthly!
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
Date: April 21
Times: 9 am – 5 pm
Cost (member): $265
Cost (non-member):$325