• April 13, 2012
  
• May 10, 2012
• June 13, 2012
  
• July 10, 2012

COURSE DESCRIPTION
Excel Intermediate further explores manipulating multiple
spreadsheets, including global formatting and linking.  You will learn
how to utilize the built-in calculation, outlining, and subtotal functions.  
Excel's filtering and auditing features are explored, as well as working
with templates, graphics, and advanced charting techniques.

Pre-requisite: Excel 2007/2010 Basics or equivalent experience

Full Day Class Only $175.00 (Unless otherwise specified full-day
classes are weekdays from 9am to 4pm)

COURSE HIGHLIGHTS

• Using multiple workbooks
  
• Linking worksheets with 3-D formulas
  
• Linking workbooks
  
• Managing workbooks
  
• Using special number formats
  
• Using functions to format text
  
• Working with styles
  
• Working with themes
  
• Other advanced formatting
  
• Outlining and consolidating data
  
• Creating subtotals
  
• Creating and using names
  
• Managing names
  
• Examining lists
  
• Sorting and filtering lists
  
• Advanced filtering
  
• Working with tables
  
• Saving workbooks as Web pages
  
• Using hyperlinks
  
• Distributing workbooks
  
• Chart formatting options
  
• Combination charts
  
• Graphic elements
  
• Auditing features
  
• Comments in cells and workbooks
  
• Protection
  
• Workgroup collaboration
  
• Application settings
  
• Built-in templates
  
• Creating and managing templates