1 / 26

Microsoft Office Excel 2007

Microsoft Office Excel 2007. What’s new in Office 2007 Tips for Excel 2007. Course Outline. Exploring the Excel Environment Organizing Data Analyzing Data Presenting Data . Exploring the Excel Environment. Explore the User Interface Work with the Ribbon Work with Contextual Tabs

vivek
Download Presentation

Microsoft Office 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. Microsoft Office Excel 2007 What’s new in Office 2007 Tips for Excel 2007

  2. Course Outline • Exploring the Excel Environment • Organizing Data • Analyzing Data • Presenting Data

  3. Exploring the Excel Environment • Explore the User Interface • Work with the Ribbon • Work with Contextual Tabs • Use Excel Galleries • Customize the Excel Interface

  4. Topic AExplore the User Interface Page 2

  5. The Microsoft Office Button Recently Opened Spreadsheet Microsoft Office Button Pinned Spreadsheets Microsoft Office Button menu Options Button

  6. The Ribbon Help Command Tabs Ribbon Groups

  7. Dialog Box Launchers Dialog Box Launchers Dialog Box

  8. Contextual Tabs Tab Category Contextual Tab Groups and commands on the Design tab

  9. Program Tabs Program Tab Groups and commands on the Print Preview tab

  10. Contextual Tabs Tips If you can’t find it, Click on it!

  11. The Quick Access Toolbar Option to relocate and customize the toolbar Quick Access Toolbar

  12. Tip to Configure QAT Arrow Next to QAT Office Button/ Options/ Customize Right-Click Shortcut

  13. Tip to Using the QAT Resist the URGEto fill your QAT!

  14. The Microsoft Office Status Bar Microsoft Office Status bar Views Zoom Slider Record Macro Button Status Display Zoom Selector

  15. Tip to Configure the Status Bar Automatic Figures

  16. Tip to Configure the Status Bar Automatic Figures

  17. Page Layout View Page Layout View Option to include Header Page Layout View button

  18. Tip to Interactive Command Guide

  19. How to Explore the User Interface Procedure: Page 5

  20. How to Work with the Ribbon Procedure: Page 17-18

  21. Topic CWork with Contextual TabsPage 21Topic DUse Excel Galleries Page 26Topic ECustomize the Excel InterfacePage 30

  22. The Mini Toolbar Mini Toolbar

  23. The Live Preview Feature Available Formats Live preview of selected format Selected Format

  24. The Excel Options Dialog Box Categories in the Excel Options dialog box Options in the Popular category

  25. How to Work with the Contextual Tabs Procedure: Page 23How to Use Excel Galleries & Live PreviewProcedure: Page 27How to Customize the Excel Interface Procedure: Page 31

  26. Reflective Questions 1. How does the Ribbon enable you to easily identify the features you need to work with in Excel 2007? 2. For what purposes would you use the options on the Microsoft Office button menu?

More Related