MS Excel 2007 Advanced (1 day)

Designed for those already familiar with basic Excel concepts and spreadsheet use.

Data manipulation
	Automatic outlining Group and ungroup Filtering data Advanced filtering Sorting data Inserting Subtotals Creating an Advanced Filter Single input data tables Double input data tables

Formulas and functions
	Complex If statements Using nested functions Using named regions Using lookup functions Using database functions The DSUM Function The DAVERAGE Function The DCOUNT Function The DGET Function The DMIN Function The DMAX Function

Tools
	Creating scenarios Scenario summary reports Protecting scenarios Using Goal Seek Using the Solver Working with views

What-if analysis
	Overview of PivotTables The PivotTable Wizard Formatting PivotTables Rearranging PivotTables Sorting data Grouping data Using AutoShow Overview of PivotCharts The PivotChart Wizard

Macros
	Recording a Macro Running a Macro Macro buttons

Collaboration
	Working with Shared Workbooks Reviewing Workbooks Sending Workbooks Tracking changes Resolving conflicts Merging Workbooks