Excel Intermediate

Course Description: 

Excel Intermediate will take you deeper into the powers of the software. Training topics include how to utilize some of the built-in calculating functions, data list management (like sorting, filtering, and Subtotal functions), using cell names, charting and more. See below for more details on features taught based upon the Microsoft Office version.

Prerequisite: 
Excel Basics or equivalent experience
Software Version: 
2016, 2013, 2010, 2007
Course Highlights: 

Excel 2013 and prior version topics include:

  • Linking worksheets and workbooks
  • Advanced formatting
  • Outlining and consolidating data
  • Creating and using cell names
  • Managing names
  • Sorting and filtering data lists
  • Generating Subtotals
  • Table features
  • Formula Auditing features
  • Saving workbooks as Web pages
  • Hyperlinks
  • Chart options
  • Graphic elements
  • Comments and Collaboration
  • Protection features
  • Application settings
  • Templates

Excel 2016 topics include:

  • Creating and using cell names
  • Functions - Logical, Math/Trig, Statistical, Date, Text, Financial
  • Sorting and filtering data lists
  • Database Functions
  • Outlining Data
  • Generating Subtotals
  • Table features
  • Advanced Conditional Formatting
  • Charting
  • PivotTables and PivotCharts
  • Graphics and SmartArt
  • Array formulas
Upcoming Classes: 
Wednesday, March 14, 2018 - 9:00am
Thursday, April 12, 2018 - 9:00am
Friday, May 11, 2018 - 9:00am
Tuesday, June 12, 2018 - 9:00am
Monday, July 9, 2018 - 9:00am
Full Day Class Only $195.00
Full-day classes are weekdays from 9am to 4pm, unless otherwise specified. WE OFFER FLEXIBLE SCHEDULING, SO PLEASE REQUEST AN ALTERNATE CLASS DATE IF NEEDED!
Register Now