1 / 28

Differences Between Excel 2003 to 2007

Differences Between Excel 2003 to 2007. Excel 2007. Purdue University Calumet. Excel 2003. What You Will Learn. New Vocabulary & Terms New Visual Layout Differences from previous version. Agenda. Ribbon Office Logo Button Quick Access Toolbar Tabs Groups Commands

guinevere
Download Presentation

Differences Between Excel 2003 to 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. Differences Between Excel 2003 to 2007 Excel 2007 Purdue University Calumet Excel 2003 PowerPoint 03-07

  2. What You Will Learn • New Vocabulary & Terms • New Visual Layout • Differences from previous version Excel 2007

  3. Agenda • Ribbon • Office Logo Button • Quick Access Toolbar • Tabs • Groups • Commands • Keyboard Shortcuts • Mini Toolbar • Highlighting Information • Page View Buttons PowerPoint 03-07

  4. Overview • Excel 2007 putting the pieces together Ribbon Tabs Logo Button Groups Excel Quick Access Toolbar 2007 Highlighted Information Commands Mini Toolbar PowerPoint 03-07

  5. Vocabulary • Ribbon • Office Logo Button • Tabs • Groups • Commands • Quick Access Toolbar • Mini Toolbar PowerPoint 03-07

  6. PowerPoint 03-07

  7. The Ribbon The new look of Excel PowerPoint 03-07

  8. What’s on the Ribbon? • Tabs -There are seven of them across the top. Each represents core tasks you do in Excel. • Groups - Each tab has groups that show related items together. • Commands - A command is a button, a box to • enter information, or a menu. The principal commands in Excel are gathered on the first tab, the Home tab. PowerPoint 03-07

  9. Temporarily Hide the Ribbon Double-click the active tab. The groups disappear, so that you have more room. PowerPoint 03-07

  10. The Office Logo Button Microsoft Office Button This button is located at the upper-left corner of the Excel window and opens the menu shown here. PowerPoint 03-07

  11. The Mini Toolbar • The Mini Toolbar automatically pops up when text is highlighted to format. • When the text is highlighted, the Mini toolbar appears (faded, not shown) • If the mouse is pointed on the Mini toolbar, it will become solid (shown above), then click • to format text. PowerPoint 03-07

  12. Tabs that appear only when you need them If you have a chart in your worksheet more commands are available, but only when you need them. Highlight your information PowerPoint 03-07

  13. Select a chart from the Chart Group PowerPoint 03-07

  14. For instance Column and click, then select 2-D Column select and click again PowerPoint 03-07

  15. A Chart then appears which represents your selection in the column category above. Then Chart Tools tabs become available: Design, Layout, and Format. PowerPoint 03-07

  16. Use the Design tab to change the chart type or to move the chart location. PowerPoint 03-07

  17. The Layout tab to change chart titles or other chart elements. PowerPoint 03-07

  18. The Format tab to add fill colors or to change line styles PowerPoint 03-07

  19. More options, if you need them • Click the arrow at the bottom of a group to get more options if you need them. • The Format Cells dialog box opens. PowerPoint 03-07

  20. Add a command to the Quick Access Toolbar 1. On the Ribbon, click the appropriate tab or group to display the command that you want to add to the Quick Access Toolbar. 2. Right-click the command, and then click Add to Quick Access Toolbar on the shortcut menu. PowerPoint 03-07

  21. Second Way to Add To Your Quick Access Toolbar Right-click in the Quick Access Toolbar Area, and then select Customize Quick Access Toolbar. PowerPoint 03-07

  22. The next screen box is Excel Optionswhere you can add or remove Quick Access Tools to your Quick Access Toolbar PowerPoint 03-07

  23. What about favorite keyboard shortcuts? 1. Make sure text is selected; press ALT to make the Key Tips appear. 2. Then press H to select the Home tab. 3. Press A and C together, in the Alignment group to center the selected text. PowerPoint 03-07

  24. A New View On the Full Ribbon click View PowerPoint 03-07

  25. A New View Appears On the ViewRibbonlook in the Workbook View Group andclick Page Layout View PowerPoint 03-07

  26. Page Layout Print Layout view in Excel 1. Column Headings 2. Row Headings 3. Margin Rules PowerPoint 03-07

  27. Understanding The Connection Excel 2007- Putting the pieces together Ribbon Quick Access Groups Commands Tabs Excel 2007 Mini Toolbar Highlighted Information Office button

  28. Questions PowerPoint 03-07

More Related