Excel – PivotTables & Data Analysis

excel-logoTraining Level: Intermediate/Advanced

 Prerequisites: Excel Foundation or equivalent experience

 Course Length: 2 hours

 Price: $75.00

Excel 2013  — View Course Outline
Excel 2010  — View Course Outline
Excel 2007  — View Course Outline
Excel 2003  — View Course Outline

Course Objectives:

  • Understand PivotTable data analysis
  • Create and modify PivotTables
  • Use page fields
  • Group PivotTable data
  • Use PivotTable update
  • Use subtotals in PivotTables
  • Understand database functions
  • Use database functions
  • Use data group and outline tools

Training Includes:

  • Hands-on instruction
  • Personal instructor
  • Flexible schedule
  • Quick Reference
  • Quick Quiz
  • Practice exercises
  • Practice files on CD/DVD
  • Certificate of Achievement

Excel – Functions & Formulas

excel-logoTraining Level: Intermediate/Advanced

 Prerequisites: Excel Foundation or equivalent experience

 Course Length: 2 hours

 Price: $75.00

Excel 2013  — View Course Outline
Excel 2010  — View Course Outline
Excel 2007  — View Course Outline
Excel 2003  — View Course Outline

Course Objectives:

  • Understand formulas and functions in Excel
  • Use multiple operators in formulas
  • Use the Function Palette
  • Use named ranges in formulas
  • Use non-adjacent ranges in formulas
  • Use conditional formulas
  • Display and print formulas
  • Fix errors in formulas
  • Understand function types

Training Includes:

  • Hands-on instruction
  • Personal instructor
  • Flexible schedule
  • Quick Reference
  • Quick Quiz
  • Practice exercises
  • Practice files on CD/DVD
  • Certificate of Achievement

Excel – What-If Analysis

excel-logoTraining Level: Intermediate/Advanced

 Prerequisites: Excel Foundation or equivalent experience

 Course Length: 2 hours

 Price: $75.00

Excel 2013  — View Course Outline
Excel 2010  — View Course Outline
Excel 2007  — View Course Outline
Excel 2003  — View Course Outline

Course Objectives:

  • Understand and define data scenarios
  • Create a scenario summary report
  • Understand and use one and two-input data tables
  • Understand and use the Goal Seek tool
  • Understand and use the Solver tool

Training Includes:

  • Hands-on instruction
  • Personal instructor
  • Flexible schedule
  • Quick Reference
  • Quick Quiz
  • Practice exercises
  • Practice files on CD/DVD
  • Certificate of Achievement

Excel – Tables (Lists)

excel-logoTraining Level: Intermediate/Advanced

 Prerequisites: Excel Foundation or equivalent experience

 Course Length: 2 hours

 Price: $75.00

Excel 2013  — View Course Outline
Excel 2010  — View Course Outline
Excel 2007  — View Course Outline
Excel 2003  — View Course Outline

Course Objectives:

  • Understand and create lists of data
  • Use the data form
  • Create and modify data records
  • Sort data in lists
  • Use Auto-Filters to sort data
  • Understand and use advanced filters
  • Work with filtered records
  • Understand and use data validation

Training Includes:

  • Hands-on instruction
  • Personal instructor
  • Flexible schedule
  • Quick Reference
  • Quick Quiz
  • Practice exercises
  • Practice files on CD/DVD
  • Certificate of Achievement

Excel – Charts

excel-logoTraining Level: Intermediate/Advanced

 Prerequisites: Excel Foundation or equivalent experience

 Course Length: 2 hours

 Price: $75.00

Excel 2013  — View Course Outline
Excel 2010  — View Course Outline
Excel 2007  — View Course Outline
Excel 2003  — View Course Outline

Course Objectives:

  • Create charts from spreadsheet data
  • Understand and use chart types
  • Position charts in worksheets
  • Use chart layouts and styles
  • Understand and use layout options
  • Format chart elements
  • Understand and modify chart source data
  • Use annotation on charts
  • Create 3D charts
  • Create and use chart templates

Training Includes:

  • Hands-on instruction
  • Personal instructor
  • Flexible schedule
  • Quick Reference
  • Quick Quiz
  • Practice exercises
  • Practice files on CD/DVD
  • Certificate of Achievement

Excel Foundation

excel-logoTraining Level:     Beginner/Intermediate

Prerequisites:     Windows Foundation or equivalent experience

Course Length:     12 hours

Price:     $350.00

Excel 2013  — View Course Outline
Excel 2010  — View Course Outline
Excel 2007  — View Course Outline
Excel 2003  — View Course Outline

Course Objectives:

  • Understand the Excel screen layout
  • Create and save a spreadsheet
  • View and navigate spreadsheets
  • Understand and use formulas and ranges
  • Edit spreadsheet contents
  • Use formatting for spreadsheet layout
  • Manage multiple worksheets and workbooks
  • Print and send Excel spreadsheets

Training Includes:

  • Hands-on instruction
  • Personal instructor
  • Flexible schedule
  • Quick Reference
  • Quick Quiz
  • Practice exercises
  • Practice files on CD/DVD
  • Binder for training materials
  • Certificate of Achievement