270 likes | 433 Views
Office 2003 to Office 2007 Transition. Microsoft Excel 2007. What’s New?. Improved GUI Bigger spreadsheets 1,048,576 rows x 16,384 columns Improved memory and multi processor usage Themes and styles consistent with other Office applications Improved conditional formatting
E N D
Office 2003 to Office 2007 Transition Microsoft Excel 2007
What’s New? • Improved GUI • Bigger spreadsheets • 1,048,576 rows x 16,384 columns • Improved memory and multi processor usage • Themes and styles consistent with other Office applications • Improved conditional formatting • Easier formula writing • Improved sorting and filtering
What’s New? • Improved color schemes across all formatting including charts • All Office applications now use the Excel charting • Improved PivotTables • XML storage to improve file size and recoverability • Improved printing • Save to PDF (with download) and XPS • More templates
Developer • Needed to run macros, design forms, protect documents and do extensive work with templates • Activate via Office button, Excel Options, Popular, Show Developer tab in the Ribbon
Add-Ins • Only visible if applications are added that enhance application, for example, Adobe Acrobat
Formula Bar and Scroll Bar (top) Formula Bar Expand / collapse formula bar Cancel Enter Insert Function Split screen Name box Scroll bar – up one line
Status Bar (left) Sheet: First Previous Next Last Select SheetX New Sheet Mode Macro Recording Shortcut to Macros
Status Bar (right) Views: Normal Page Layout Page Break Preview Resize scroll bar Split window Zoom % Shortcut to Zoom Window corner for resizing Zoom buttons and slider
Notes • Excel rocks.