Outline subject to change without notice.
Please contact us with any questions.

EXCEL 2007/2010 ADVANCED  

Upcoming Classes
  • April 20, 2012
  • May 21, 2012
  • June 19, 2012
  • July 19, 2012

COURSE DESCRIPTION
Excel Advanced is intended for proficient users of Excel.  Topics covered
offer an in-depth view of advanced spreadsheet capabilities, including
advanced formulas, data validation, and database functions.  Excel's
PivotTables and macros are explored as well.

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

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

COURSE HIGHLIGHTS
  • Logical functions
  • Math and statistical functions
  • Financial functions
  • Displaying and printing formulas
  • Using lookup functions
  • Using MATCH and INDEX
  • Creating data tables
  • Validating cell entries
  • Exploring database functions
  • Working with PivotTables
  • Rearranging PivotTables
  • Formatting PivotTables
  • PivotCharts
  • Exporting and importing text files
  • Exporting and importing XML data
  • Querying external databases
  • Goal Seek and Solver
  • The Analysis ToolPak
  • Scenarios
  • Views
  • Running and recording a macro
  • Working with VBA code
  • Creating functions
  • Conditional formatting with graphics
  • SmartArt graphics
CALL
(330) 262-2343
or
CLICK HERE TO
REGISTER NOW!
Copyright 2012
Computer Sense, LLC