Loading Events

« All Events

  • This event has passed.

Excel Level 3 (4/21)

April 21 @ 9:00 am - 5:00 pm

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

CLASS REGISTRATION MASTER

  • All self pays must be paid in advance of attendance.

 

Details

Date:
April 21
Time:
9:00 am - 5:00 pm
Event Categories:
,