This course provides an overview of the redesigned user interface and interactive features of Microsoft Office Excel 2007. This course is designed for experienced Excel users who have worked with earlier versions of Microsoft Excel, ideally Microsoft Excel 2003, and who have or are planning to upgrade to Microsoft Excel 2007.

Module 1: The new look & Feel of Microsoft Excel 2007

• Changes to the interface
• Using the Office button
• Working with the ribbon
• Understanding tabs, groups and commands
• Using contextual tabs
• Using the quick access toolbar
• Using the mini toolbar
• Customising the environment
• Using zoom
• Creating new worksheets
• New page layout view

Module 2: Working with Data

• Increased capacity
• Improved formula creation
• Using tables
• Improved sorting and filtering
• Enhancements to PivotTables

Module 3: Formatting Spreadsheets

• Live previews of formatting
• Using themes
• New conditional formatting

Module 4: Using the Enhanced Drawing Tools

• Using SmartArt graphics
• Using the new charts

Module 5: Saving Spreadsheets in Excel 2007

• Different Excel file formats
• Understanding compatibility between different versions
• Using the document inspector to remove 'metadata'

Module 6: SharePoint Integration

• Discussion of how Excel 2007 integrates with SharePoint

4 Ravey Street
London EC2A 4QP
t: +44(0)20 7729 1811
f:+44(0)20 7729 9412
information@premiercs.co.uk