What’s new for Excel 2007

• An overview of the new features in Excel 2007

Custom Formatting

• Using number, currency and date placeholders
• Creating custom formats

Advanced Functions

• Advanced date and time functions
• Text functions
• Lookup functions
• Financial functions
• Database functions

PivotTables

• Creating a pivot table using the new 2007 interface
• Exploring pivot-table components
• Filtering data using report, column and row fields
• Moving, adding and removing data from the pivot table.
• Updating the original data and refreshing the pivot-table
• Changing the data function
• Renaming a field
• Using the Show Pages tool
• Showing how a data total was generated
• Formatting a pivot-table
• Exploring the pivot-table options
• Collapsing and expanding data
• Using calculated fields and calculated items
• Grouping text items.
• Grouping data into date or numerical bins
• Sorting data manually and automatically
• Creating and customising a PivotChart Report

Consolidating worksheets

• Consolidating data by position
• Consolidating data by category

Macros

• Record a macro
• Running a macro from the Quick Access toolbar or a graphic
• Exploring macro code using VBA

Arrays (if time)

• Creating an array formula
• Understanding array rules and characteristics
• Locating and editing an array formula
• Using logic functions with arrays
• Creating a Frequency Distribution
• Creating a Histogram

The “What If?” tools (if time)

• Scenarios, Goal Seek, Solver and Data Tables
• How to set the answer and work backwards to one or more source values
• Adding constraints
• Keeping a solution or restoring original data
• Save a Solver solution as a scenario
• ‘Creating a Solver Report