Excel 2003 - Mastering I

View Availability
& Register »
Course #: CPU0500 Experience Level: Advanced HRCI: N/A Available Sessions: 2

Manage large amounts of data utilizing Excel's database features

Learn how to customize the data search, refine your data selection and construct reports to meet the job’s exact needs. With Mastering Excel I, you'll know how to structure and apply financial formulas for examining multiple scenarios and how to build a powerful database management program.
 

Course content
 

Note:  This course covers Versions 2000, 2002, XP and 2003. 
Databases, Filters and Functions
  • Create an Excel database
  • Manipulate database records
  • Add comparison criteria
  • Enable AutoFilter
  • Create a criteria range
  • Logical, Paste and Round functions
  • Use the series command
Scenarios, Goal Seeking and Worksheet Protection
  • Create and display a scenario
  • Use Goal Seek
  • Place formulas in data tables
  • Save a solution as a scenario
  • Use Report manager
  • Protect workbooks, worksheets and cells

Prerequisite:Due to the highly technical nature of this course it is critical to first take Intermediate Excel.

 

Related

No Related products

Available Course Sessions

Session Code
Date/Time/Location
Instructor
Member Price
Non-Member Price
C1822
8:30 a.m. - 4:30 p.m.
Kaplan Professional Schools - Bloomington 		Kaplan Professional Schools Instructor 5/11 and earlier $245 5/12 and after $245 $0 Register »For this Session
C1178
8:30 a.m. - 4:30 p.m.
Trusight Headquarters 		Kaplan Professional Schools Instructor 7/11 and earlier $245 7/12 and after $245 $0 Register »For this Session