Excel 2007/2010 - Mastering II

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

Use advanced Excel features to automate and improve the presentation of your workbooks.

Mastering Excel II enables you to increase productivity by customizing and automating repetitive tasks. This course takes you through the creation and management of PivotTables, data maps, the consolidation and sharing of worksheets and other important tools you need to complete once time-consuming and tedious tasks.
 

Course content
 

Note:  This course specifically covers only the 2007 version of this application. 
 

Managing Large Workbooks

  • Import and export data
  • Create and revise PivotTables
  • Use multiple workbooks
  • Create and use templates and styles
  • Share and consolidate workbooks

Automating and Improving Workbooks
 

  • Record and edit macros
  • Customize toolbars
  • Share workbooks and track changes
  • Create custom views
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
C1825
8:30 a.m. - 4:30 p.m.
Kaplan Professional Schools - Bloomington 		Kaplan Professional Schools Instructor 5/24 and earlier $245 5/25 and after $245 $0 Register »For this Session
C1181
8:30 a.m. - 4:30 p.m.
Trusight Headquarters 		Kaplan Professional Schools Instructor 7/21 and earlier $245 7/22 and after $245 $0 Register »For this Session