Course Description:
Manipulate data faster with AutoFilter, Subtotal, outlines and importing. Use names, styles, templates and View and Report Manager to accelerate worksheet management.
Audience: Persons with mastery of basic Excel data entry, formatting, copying, and windowing skills who want to further enhance their ability to use Excel efficiently.
Prerequisite: Introduction to Excel or equivalent course.

Objectives
	Use styles and templates to easily and consistently format your worksheets
	Use filters to find information meeting specified criteria
	Import text files and copy to/from Microsoft Word
	Create and use range names in formulas and in commands which specify ranges
	Sort, outline and automatically subtotal worksheets data
	Use View Manager to automate different views of a workbook
	Use Scenario Manager to test results of different input values
	Use Print Manager to print a sequence of ranges, views and scenarios