• 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 more elaborate
calculations and how to utilize the built-in calculation functions.  
Creating charts is also covered.

Pre-requisite: Excel Basics or equivalent experience

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

COURSE HIGHLIGHTS

• Viewing, Renaming and Color-Coding Worksheets
  
• Manipulating Worksheets
  
• Creating Linked Formulas
  
• Protecting Workbooks and Worksheets
  
• Creating and Using Named Ranges
  
• Working with Insert Function
  
• Using Financial and Date Functions
  
• Using Data Validation
  
• Creating and Using Custom Formats
  
• Using the Chart Wizard
  
• Modifying Charts
  
• Changing the Chart Type, Size and Location
  
• Adding and Removing Data Series
  
• Using the Range Finder with Charts
  
• Using Text Boxes
  
• Formatting Chart Elements, Chart Text, and Chart Objects
  
• Working with Three-Dimensional Charts
  
• Creating a Combination Chart
  
• Creating a List
  
• Using AutoComplete
  
• Sorting a List
  
• Filtering a List
  
• Creating and Using Styles
  
• Merging Styles
  
• Using Templates
  
• Creating Templates