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



This year, we’re proud to partner with the Oregon CASA Network, an organization whose mission is to support and promote court-appointed volunteers who work with children that have experienced abuse or neglect.  These volunteers support each child’s case until it is closed, and the child is in a safe, permanent home. 

The CEO herself, Debra Gilmore, will be presenting to share a little about the organization and how Total Rewards PDX and you can help. You can help contribute to this organization by shopping at the Columbia Sportswear Employee Store (passes will be available for every attendee!).  While their focus is on helping children through tough times in their lives through CASAs and not about gifts, you may also bring clothing or toy donations.  Debra will ensure they get delivered to children in the network that are in need this holiday season.