Download
slide1 n.
Skip this Video
Loading SlideShow in 5 Seconds..
EXCEL 2003 vs. 2007 PowerPoint Presentation
Download Presentation
EXCEL 2003 vs. 2007

EXCEL 2003 vs. 2007

269 Views Download Presentation
Download Presentation

EXCEL 2003 vs. 2007

- - - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

  1. What’s the Difference? EXCEL 2003 vs. 2007

  2. Excel 2007 • This tutorial will explain the differences between Excel 2003 and 2007 by comparing the Menus and toolbars in Excel 2003 with the MS Office Button and Ribbon in 2007. • There will also be an explanation of new features exclusive to Excel 2007

  3. The New Workbook Page • When you open either version of Excel, a new blank Workbook page appears. • Revisions in Office 2007 have created major changes in the layout of this display • The major differences between the two displays are seen here.

  4. New Workbook Page- 2003 and 2007 Excel 2007 Excel 2003

  5. MS Office Button, the Quick Access Toolbar, & The Ribbon • The MS Office Button, Quick Access Toolbar and the Ribbon replace the Menu, Standard and Formatting Toolbars in Excel 2003.

  6. The MS Office Button • The MS Office Button is a New Feature of Excel 2007. • This button is the access point for: • Creating New Excel Workbooks • Opening • Saving • Printing • Closing • This Button replaces the File Menu

  7. The MS Office Button • The MS Office Button also houses • Recently Openedpresentations • Convertconverts Excel files into the 2007 Format • Prepare to finalize presentations for distribution • Send which distributes presentations through facsimile or email • Publishto distribute a presentation to a server, blog, or shared workspace • Excel Options(previously located under the Tools Menu)

  8. Quick Access Toolbar Located next to the MS Office Button, the Quick Access Toolbar offers one-click access to the most widely used office functions. By default, there are 3 buttons Save,New, and Open. Click on the arrownext to the toolbar, to open the customize Menu Click the checkbox next to each feature to add and more options to the toolbar This is a New Feature

  9. Menus and Toolbars - 2003 In Excel 2003, different functions within Excel are accessed through the Menu Bar,StandardToolbar, the Formatting Toolbar, and the Formula Bar Menu Toolbar Formula Bar Standard Toolbar Formatting Toolbar

  10. Menus and Toolbars - 2007 Office 2007 is arranged differently. All Menus are located within tabs on a Menu bar called the Ribbon The three parts of the Ribbon are Tabs, Groups, & Commands.

  11. The Ribbon Groups: Sections containing Related items or tasks Tabs: 8 tabs representing common related activities Commands: Buttons, boxes or Menus relating to specific functions within Excel Formula Bar: Shows Excel Formulas

  12. Help • In Office 2007, there is not a Help Menu. Instead, each item on the ribbon has an expanded balloon that explains the feature or option. • In some cases, the F1 Button is also available. This opens a new window with an definition and an expanded explanation of how to use the feature or option

  13. The MS Office Button

  14. The MS Office Button replaces the File Menu

  15. Convert & Save • Convert - Converts older Excel files into the 2007 Format • Save– Saves presentations • Save As – Saves presentation with another name or presentation extension. • You MUST save presentations in Excel 97-2003 format to open them in older versions of Excel

  16. Print • Print– Prints Workbook and offers a Menu to make adjustments to the print function (i.e. # of copies) • Quick Print – Sends Workbook directly to printer • Print Preview - Shows you what the Workbook will look like prior to printing

  17. Prepare • Prepare– Prepares the Workbook for distribution. There are several functions within this Menu • Properties: Feature previously located in the File Menu in 2003 • Inspect Workbook:This is a New Feature • Encrypt Workbook: Feature previously located in the Security tab of the Options Menu in 2003

  18. Prepare • Restrict Permission: Feature previously located in the File Menu in 2003 • Add Digital Signature:Feature previously located in the Security tab of the Options Menu in 2003 • Mark as Final: This feature previously located in the Track Changes tab of the Options Menu in 2003

  19. Prepare • The Run Compatibility Checker checks to see if a feature used in the Excel 2007 Workbook is compatible with earlier versions of Excel in case the Workbook needs to be saved in an earlier format

  20. Send • Send: Transmits the Workbook to • MS Outlook • Internet Fax transmission

  21. Publish • Excel Services:This is a New Feature, saves workbook on an online browser • Workbook Management Server:This is a New Feature, and it replaces the File>Save as step, by sending the Workbook directly to Document Management server • Create Document Workspace: Creates a separate, online workspace for the a Excel Workbook and all related office (i.e. PowerPoint, Word) Documents related to that Workbook. This feature was originally located in the Shared Workspace Task Pane in Excel 2003

  22. Close Close:Closes a Workbook

  23. Excel Options • Excel Options – Opens the Options Menu previously located on the Tools Menu. These options have changed significantly in 2007, so take a minute to look over the changes

  24. Excel Options Excel 2007 Excel 2003

  25. Excel Options • There are 9 categories of Excel Options: • Popular • Formulas • Proofing • Save • Advanced • Customize • Add-Ins • Trust Center • Resources

  26. Popular • Top Options for Excel: This is a New Feature. Choose options by clicking the checkboxes • Options for Workbooks: Set default font and font size, number of sheets, and view • Personalize your copy of MS Office: Replaces the User Information tab on the Excel 2003 Options Menu • Language Settings replaces the Set Language option on the Excel 2003Tools Menu

  27. Formulas • Calculation Options: Set to Automatic by default, this menu replaces the Calculations tab in Excel 2003 • Working With Formulas: Replaces Formula Settings on the General tab • Error Checking & Error Checking Rules: Automatically checks for errors in formulas. Replaces the Error Checking tab

  28. Proofing • AutoCorrect Optionsreplaces the AutoCorrect tab on the Excel 2003Tools Menu • Spelling and Grammar Optionsreplace the Spelling and Grammar tab on the Excel 2003Options Menu

  29. Save • Save Workbooksreplaces the Save tab on the Excel 2003Options Menu • Click Save in this Format to change the file type to Excel 97-2003 Workbook. This way, all of your Workbooks can be edited in both Excel 2003 and 2007.

  30. Advanced • The Advanced Tab has several options, scroll down to view all of them • Editing OptionsandCut, Copy & Paste replace the Edit tab on the Excel 2003Options Menu

  31. Advanced • Show Workbook Contentreplaces the View tab on the Excel 2003Options Menu • Displayreplaces functions found under both the View and General tabs on the Excel 2003Options Menu

  32. Customize • Customizereplaces the Customize option on the Excel 2003Tools Menu

  33. Add-Ins • Add-Ins are customizable by user • There are lists of both active and inactive Add-In • To activate an Add-In, choose from the Manage drop down Menu at the bottom of the page • Click Go • Check the options that you want to Add-In and click Ok

  34. Trust Center • The Trust Center allows you to choose security settings for your Workbooks. • There are several tutorials that can be accessed by clicking on the links

  35. Resources • The Resources Page is a one-stop location for • Downloading updates, • Troubleshooting software problems • Help online

  36. The Ribbon

  37. Key Tips Key Tips are shortcuts to Tab and Menu options on the Ribbon. This is a New Feature Push the alt key to show the Key Tips, then push the corresponding letter on the keyboard to activate the Key Tip.

  38. The Ribbon As Noted earlier, the Ribbon is broken up into he three parts: Tabs, Groups, & Commands. Tabs: 8 tabs representing common related activities Groups: Sections containing Related items or tasks Commands: Buttons, boxes or Menus relating to specific functions within Excel

  39. The Ribbon Tabs • Home: Popular Excel options found on the Standard and Formatting Toolbars in Excel 2003 • Insert: Items associated with the Insert Menu • Page Layout: Items relating to how a Workbook is set up before any text is typed on the screen • Formulas: Functions found Insert/Formulas Menu. • Data: Database functions of Excel • Review: Options for Proofing, Comments, Tracking Changes and Workbook protection • View: Options for how you see Workbooks on the screen • Add-ins: Converts Workbook to Flash Paper format

  40. The Home Tab Clipboard Group: Options to cut, copy and paste text, plus the Format Painter. This group replaces the cut, copy and paste options on the Standard Toolbar and in the Edit Menu in Excel 2003 Additional Paste Functions are activated by clicking on the arrow. These include Paste Special and Paste as Hyperlink options. Click on the arrow on the Clipboard Command, to open the Clipboard task pane. Up to 24 items can be saved on the Clipboard

  41. The Home Tab The Font Group: Options to edit fonts, font colors and font sizes & font styles. It replaces the font formatting functions on the Formatting Toolbar and under the Format Menu in Excel 2003 The Font Menu is accessed by clicking on the arrow on the Font Command bar

  42. The Home Tab The Alignment Group: Options for text alignment, cell alignment, indentation, text orientation, text wrapping, and merge & center text. Click the arrow on the Alignment Command Bar to open the Format Cells Menu. These options were located on the Format/Cell menu in Excel 2003

  43. The Home Tab The Number Group:Options for formatting numeric values including; currency ($), percentage (%), and decimal placement (.00), Click the arrow on the Number Command Bar to open the Format Cells Menu. These options were located on the Format/Cell menu in Excel 2003

  44. The Home Tab The Styles Group:Three options to format cells Conditional Formatting: The cell format (i.e. text color, font, or other condition) changes based on changes in cell values. While Conditional Formatting is not a new feature, the variety of conditional formatting options is significant. Format as Table: This feature replaces the AutoFormat option in Excel 2003. The range of table formats is significant

  45. The Home Tab The Styles Group:Three options to format cells Cell Style: allows you to format individual cells or sections of a worksheet with a variety of color and font formats. This is a New Feature. Click on the arrows below each function to view the complete variety of formatting choices

  46. The Home Tab The Cells Group:Options to insert, delete and format cells, columns, and rows. These features were found on the Insert and Edit Menus in Excel 2003 Insert: Insert a cell, column, row, or worksheet Delete: remove a cell, column, row, or worksheet

  47. The Home Tab • Format: • Format and Lock cells • Adjust column width • Adjust row height • Autofit text • Organize (move, copy rename or protect) worksheets • Hide or unhide cells, columns, and worksheets • All of these options were found under the Format and Edit menus in Excel 2003

  48. The Home Tab The Editing Group:Options to AutoSum, Copy formatting, Clear, Sort & Filter, plus Find & Select data. These functions were located on the Edit and Data Menus, as well as the standard Toolbar in Excel 2003. AutoSum: Adds, Averages and counts a column or row of numbers Copy Formatting: Copies cell data and formatting into adjacent cells Clear: Removes data and formatting from a cell or group of cells Sort & Filter: Functions to sort and filter cell, column or row data

  49. The Home Tab • Find & Select: Opens a new menu with options to Find, Replace and Go To other areas of the worksheet, plus access to formulas, Comments, Conditional Formatting and Data Validation options. This is a new feature

  50. The Insert Tab The Tables Group – Inserts Tables into a Workbook Pivot Table: Creates a Pivot Table or Pivot Chart from worksheet data Table: Createsa Pre-formatted Table from worksheet data. In prior versions of Excel, tables were referred to as “Lists”. The table is created with built-in Sort and Filtering options. This is a New Feature. When activating Insert/Table, the Table Tools tab opens