260 likes | 433 Vues
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
E N D
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 • Use Excel Galleries • Customize the Excel Interface
The Microsoft Office Button Recently Opened Spreadsheet Microsoft Office Button Pinned Spreadsheets Microsoft Office Button menu Options Button
The Ribbon Help Command Tabs Ribbon Groups
Dialog Box Launchers Dialog Box Launchers Dialog Box
Contextual Tabs Tab Category Contextual Tab Groups and commands on the Design tab
Program Tabs Program Tab Groups and commands on the Print Preview tab
Contextual Tabs Tips If you can’t find it, Click on it!
The Quick Access Toolbar Option to relocate and customize the toolbar Quick Access Toolbar
Tip to Configure QAT Arrow Next to QAT Office Button/ Options/ Customize Right-Click Shortcut
Tip to Using the QAT Resist the URGEto fill your QAT!
The Microsoft Office Status Bar Microsoft Office Status bar Views Zoom Slider Record Macro Button Status Display Zoom Selector
Tip to Configure the Status Bar Automatic Figures
Tip to Configure the Status Bar Automatic Figures
Page Layout View Page Layout View Option to include Header Page Layout View button
How to Explore the User Interface Procedure: Page 5
How to Work with the Ribbon Procedure: Page 17-18
Topic CWork with Contextual TabsPage 21Topic DUse Excel Galleries Page 26Topic ECustomize the Excel InterfacePage 30
The Mini Toolbar Mini Toolbar
The Live Preview Feature Available Formats Live preview of selected format Selected Format
The Excel Options Dialog Box Categories in the Excel Options dialog box Options in the Popular category
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
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?