Microsoft Excel Intermediate

Share With Your Friends

This class is intended for users who have basic Excel skills.  Please be sure to review the topics covered to better assess if this class is for you.  However, feel free to call us if there is any question about whether you should register for this class.  We find Excel Intermediate one of the hardest classes to properly assess who it is appropriate for since there is such a wide range of Excel Basic experience or skill. 

Although this course is designed for Intermediate Excel 2013, many participants find the content transferrable to Office 2007 through Office 2013.  Please check with the Instructor or BTC office before registering if you have any questions since it easier to answer your concerns before the class begins than finding out the class content is not what you are looking for.  Designed for PC based computers (sorry not for Mac/Apple).

  • Working with large worksheets
  • Viewing options.
  • Hiding, displaying, and formatting data
  • Printing large worksheets
  • Using multiple worksheets and workbooks
  • Using multiple worksheets
  • Linking worksheets by using 3-D formulas
  • Consolidating data
  • Linking workbooks
  • Managing workbooks
  • Using the Options dialog box
  • Customizing toolbars and menus
  • Advanced formatting
  • Borders and shading
  • Using special number formats
  • Working with dates
  • Working with styles
  • Other advanced formatting
  • List management
  • Examining lists
  • Sorting & filtering lists
  • Advanced filtering
  • Intermediate charting
  • Chart formatting options
  • Using combination charts
  • Using graphic elements
  • Documenting, auditing and options
  • Auditing and option features
  • Comments and text boxes
  • Protection
  • Workgroup collaboration
  • Using templates
  • Built-in templates
  • Creating and managing templates

Prerequisites:  MS Excel Basic or equivalent experience.

Dates:

  • November 9 & 12, 1:00 – 4:00 pm
  • December 1 & 8, 5:30 – 8:30 pm

Price: $125

Register Today!

Business & Industry Training
31 College Drive
Concord, NH 03301-7412
(603) 230-4022
Fax: (603) 230-9304
nhtibtc@ccsnh.edu
Office of Workforce Development