Course Description:
Get to the bottom line faster using pivot tables, consolidation, functions, absolute and mixed cell addresses and multi-sheet calculations. Improve decision making with goal seeking and Scenario Manager.
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.

Objectives
	Combine sheets into a single workbook
	Use group editing to make consistent changes to all sheets in a workbook
	Use linking, 3-D formulas, consolidation and Paste Special to work with multiple related sheets or workbooks
	Use absolute and mixed cell addressing in formulas
	Use goal seeking and scenarios to explore "what-if" scenarios with your data
	Be aware of the statistical, financial, mathematical, lookup, logical, text, and date & time functions in Excel, and use at least one example of each
	Use pivot tables to reorganize a list of data into a table of data