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.

Excel Basics or equivalent experience
Software Version: 
Microsoft (Office) 365, 2021, 2019, 2016, 2013, 2010
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
  • Advanced Chart options
  • Graphic elements
  • Comments and Collaboration
  • Protection features
  • Application settings
  • Templates

Excel 2016 and later version 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 (appendix)
  • Array formulas (appendix)
Upcoming Classes: 
Tuesday, June 28, 2022 - 9:00am
Thursday, August 11, 2022 - 9:00am
Wednesday, September 14, 2022 - 9:00am
Full Day Class Only $200.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