• Home
  • Excel Course - Advanced workbooks and worksheets

Excel Course - Advanced workbooks and worksheets

  • 14 Aug 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 intermediate 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 FUNCTIONS
    • Work with Ranges 
    • Use Specialized Functions
    • Work with Logical Functions 
    • Work with Date & Time Functions 
    • Work with Text Functions
  2. WORKING WITH LISTS
    • Sort Data 
    • Filter Data
    • Query Data with Database Functions 
    • Outline and Subtotal Data
  3. ANALYZING DATA
    • Create and Modify Tables
    • Apply Intermediate Conditional Formatting 
    • Apply Advanced Conditional Formatting
  4. VISUALIZING DATA WITH CHARTS
    • Create Charts
    • Modify and Format Charts
    • Use Advanced Chart Features
  5. ANALYZING DATA WITH PIVOTTABLES AND PIVOTCHARTS
    • Create a PivotTable
    • Analyze PivotTable Data
    • Present Data with PivotCharts
    • Filter Data by Using Timelines and Slicers



(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