Upgrading to Excel 2007

Course Length: 1 day

Objective:Learn the changes and enhancements in Excel 2007
Prerequisites:Knowledge of advanced features of Excel 2003

New Excel Interface Improved Database Features
Why did Microsoft make the changes? Sorting
What's in?  Filtering
 Ribbon  Automatic AutoFiltering
 Quick Access Toolbar Table Enhancements
 Dialog Box Launcher Calculated columns
 Microsoft Office Button Total rows
 New Status Bar Tables styles
What's Out? Chart Enhancements
 Menu Bar Visual chart pickers
 Toolbars Chart templates
New File Formats and Layouts Using OfficeArt shapes
New formats Sharing charts with other applications
Working with documents from previous versions of Excel Pivot Tables
Saving a document as PDF or  XPS New easier interface
New Page Layout view Plus and Minus indicators
Conditional Formatting Pivot charts
Creating conditional formatting PivotTable style and layout
Applying conditional formatting   
Formula Writing Enhancements   
Resizable formula bar   
Function AutoComplete   
Named ranges   

Course Inquiry Classes Available

Webinar Schedule    Training Services    CLE Classes    Floor Support    Help Desk