• Home
  • Excel Course - Advanced Excel

Excel Course - Advanced Excel

  • 11 Sep 2019
  • 8:00 AM - 4:00 PM
  • New Horizons Computer Learning Centers, 1500 NW Bethany Blvd, Beaverton, OR 97006



We are excited to partner with New Horizons to offer a series of all-day Excel courses at a discounted rate. This is an advanced excel course; please see the course outline below for details on what this course will offer.  

Please click here to be taken to the registration site for this $150, all-day course. Use discount code TRPDX to receive the $150 discount (originally $300 value).

Registrants do not need to bring their own computer. 

There must be a minimum of 8 registrants in order to hold a class, with a maximum of 20 registrants per class, so sign up before all of the spots are filled! 

COURSE OUTLINE

  1. WORKING WITH MULTIPLE WORKSHEETS & WORKBOOKS
    • Use Links and External References
    • Use 3-D References 
    • Consolidate Data
  2. USING LOOKUP FORMULAS AND FORMULA AUDITING
    • Use Lookup Functions
    • Trace Cells
    • Watch and Evaluate Formulas
  3. SHARING AND PROTECTING WORKBOOKS
    • Collaborate on a Workbook
    • Protect Worksheets and Workbooks
  4. AUTOMATING WORKBOOK FUNCTIONALITY
    • Apply Data Validation
    • Search for Invalid Data and Formulas with Errors
    • Work with Macros
  5. CREATING SPARKLINES AND MAPPING DATA
    • Create Sparklines
    • Map Data
  6. FORECASTING DATA
    • Determine Potential Outcomes Using Data Tables
    • Determine Potential Outcomes Using Scenarios
    • Use the Goal Seek Feature
    • Forecasting Data Trends



(c) 2016 Columbia-Willamette Compensation Group.
Formed in 1990 to support area professionals, Columbia-Willamette Compensation Group is a Local Network affiliate of WorldatWork.

Membership website development by Webbright