Upgrading to Microsoft Excel 2007
Learn how to use the rich new features and striking enhancements that will maximise your Excel 2007 potential.
Course Duration: 1/2 Day
Who Should Attend: Experienced Excel users who wish to learn about the changes and new features in Excel 2007.
Prerequisites: Attendees should have previous experience of using Excel 2003 or earlier, running under a Windows environment.
At course completion you will be able to:
- Understand the changes to Excel's interface and functionality
- Successfully use the key new features and the changes to existing features within Excel
- Understand, at a high level, Excel's integration with Microsoft SharePoint
Topics covered in the course include:
The new look and feel:
- 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
Working with data:
- Increased capacity
- Improved formula creation
- Using tables
- Improved sorting and filtering
- Enhancements to PivotTables
Formatting spreadsheets:
- Live previews of formatting
- Using themes
- Amazing conditional formatting
Using the enhanced drawing tools:
- Using SmartArt graphics
- Using the new charts
Saving spreadsheets:
- Different Excel file formats
- Understanding compatibility between different versions
- Using the document inspector to remove 'metadata'
SharePoint integration:
- Examples of how Excel 2007 integrates with SharePoint
(Please note the content of any particular course may vary slightly)