Excel Level 3
Professional Development
This course is for those who already have the level I & 2 basics.
WORKING WITH MULTIPLE WORKSHEETS & WORKBOOKS:
- Reference Cells and Groups of Cells Across Worksheets
- Link Cells to External Worksheets
- Consolidate Data Across Worksheets
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
SHARING AND PROTECTING WORKBOOKS
- Collaborate on Workbooks
- Apply Varying Levels of Workbook Access and Protections
AUTOMATING WORKBOOK FUNCTIONALITY
- Create and Manage Validation Rules and Lists
- Search for Invalid Data and Formulas with Errors
- Record Macros to Automate Tasks
CREATING SPARKLINES AND MAPPING DATA
- Create Sparklines to Show Trends
- Map Data
FORECASTING DATA
- Determine Potential Outcomes Using Data Tables and Scenarios
- Solve for Desired Outputs with the Goal Seek Feature
- Forecast Data Trends
Online live instructor 1 day classes are available several times a month.
Contact us to register, inquire on available dates or book a private in person class for your staff at your location or ours!
Cancellation Policy: All cancellations must be received at least 10 business working days prior to class start date. Substitutions will be accepted at any time. No shows and cancellations less than 10 business days prior to class start will be charged the advertised price for the class.
Email hidden; Javascript is required.
CLASS REGISTRATION