1 / 26

Microsoft Excel 2007

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

halle
Download Presentation

Microsoft Excel 2007

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. Office 2003 to Office 2007 Transition Microsoft Excel 2007

  2. 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

  3. 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

  4. Home

  5. Insert

  6. Page Layout

  7. Formulas

  8. Data

  9. Review

  10. View

  11. Chart Tools: Design

  12. Chart Tools: Layout

  13. Chart Tools: Format

  14. Picture Tools: Format

  15. Drawing Tools: Format

  16. PivotTable Tools: Options

  17. PivotTable Tools: Design

  18. Table Tools: Design

  19. 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

  20. Add-Ins • Only visible if applications are added that enhance application, for example, Adobe Acrobat

  21. 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

  22. Status Bar (left) Sheet: First Previous Next Last Select SheetX New Sheet Mode Macro Recording Shortcut to Macros

  23. 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

  24. Task Panes

  25. Notes • Excel rocks.

More Related