Microsoft Excel 2007

1. Microsoft Excel 2007 Presented By: Sahara Technology Solutions

2. Agenda for today • Take a Pre-Test • Intro to the Microsoft Excel 2007 • Exploring MS Excel 2007 • The New Office Ribbon • The MS Excel 2007 Menus and Buttons • Quick Access Toolbar • Questions and Demonstrations • Watch a Video • Do Hands-on work • Take a Post-Test

3. Agenda Continued(Hands-on Session) • The Hands-On part of this session will touch on the following: • Create a new spreadsheet • Add Rows and Column • Formatting • Copy and Paste • Entering addition formula • Inserting Chart • Sum Function • Subtraction • Multiplication • Using Auto fill • Currency and Symbols • Moving and resizing • Creating chart in excel • Saving you work • Finishing the spreadsheet

4. Overview of Microsoft Excel 2007

5. What is MS Excel 2007 Excel 2007 is the spreadsheet software in the Microsoft 2007 Office Suite. It allows you to store, organize, and analyze numerical and text data. Notably, the old look of menus and buttons at the top of the window in previous versions of MS Excel has been replaced with the Ribbon. The Ribbon, with tabs you click to get to commands, was developed to make Excel simpler to use and to help you quickly find and work with the commands you need.

6. Quick View of MS Excel 2007

7. Explanation of MS Excel 2007 Menus • Home:This menu options contains commonly used Excel features, such as inserting formulas, formatting tables, rows, cells and text, and sorting and filtering • Insert:This menu option handles anything you might want to insert into a document, such as charts, pivot tables, tables, pictures, clip art, text, WordArt ... well, you get the idea. • Page layout:This menu option allows you to change margins, page size and orientation, define your print area, set page breaks, specify which rows and columns will print on each page and so on. • Formulas:This menu allows you to insert and work with formulas. It organizes all of Excel's formulas into categories, such as Financial, Logical, Math & Trig, and so on, so they're all within easy reach. And it also gives you quick access to useful formula-checking features, such as error-checking and the ability to trace precedents and dependents.

8. Explanation of MS Excel 2007 Menus • Data:Whatever you need to do with data, you'll find it here. For example, you can use this tab to import data from a wide variety of sources, including the Web, Access, SQL Server and so on. You'll also be able to filter and sort data, validate your data, group and ungroup data, and perform data analysis, among other features. • Review:Need to check spelling and grammar, look up a word in a thesaurus, work in markup mode, review other people's markups or compare documents? This is the tab for you. It also lets you protect worksheets and workbooks, and share workbooks. • View:Here's where to go when you want to change the view in any way, including displaying or turning off gridlines and the formula bar, zooming in and out, splitting and hiding panes, and so on.

9. More commands, but only when you need them The commands on the Ribbon are the ones you use the most. Instead of showing every command all the time, Excel 2007 shows some commands only when you may need them, in response to an action you take. So don’t worry if you don’t see all the commands you need at all times. Take the first steps, and the commands you need will be at hand.

10. More options, if you need them Sometimes an arrow, called the Dialog Box Launcher, appears in the lower-right corner of a group. This means more options are available for the group. Click the Dialog Box Launcher , and you’ll see a dialog box or task pane. The picture shows an example: On the Home tab, click the arrow in the Font group. The Format Cells dialog box opens, with superscript and other options related to fonts.

11. What about favorite keyboard shortcuts? If you rely on the keyboard more than the mouse, you’ll want to know that the Ribbon design comes with new shortcuts. This change brings two big advantages over previous versions of Excel: • There are shortcuts for every single button on the Ribbon. • Shortcuts often require fewer keys.

12. What about favorite keyboard shortcuts? The new shortcuts also have a new name: Key Tips. You press ALT to make Key Tips appear. For example, here’s how to use Key Tips to center text: Press ALT to make the Key Tips appear. Press H to select the Home tab. Press A, then C to center the selected text.

13. A new view Not only the Ribbon is new in Excel 2007. Page Layout view is new, too. If you’ve worked in Print Layout view in Microsoft Office Word, you’ll be glad to see Excel with similar advantages.

14. Working with different screen resolutions Everything described so far applies if your screen is set to high resolution and the Excel window is maximized. When and how do things look different? • When the Excel window isn’t maximized. Some groups will display only the group name.

15. Stop!! Class Activity • Video • Introduction to MS Word 2007

16. Discussing the Video (Interactive learning) • What did you learn from the video? • How can you use what was learned from the video and the presentation

17. Class Exercise (Hands-on)The RBHS SUSU club Assignment • Objectives • Create a new spreadsheet • Add Rows and Column • Formatting • Copy and Paste • Entering addition formula • Inserting Chart • Sum Function • Subtraction • Multiplication • Using Auto fill • Currency and Symbols • Moving and resizing • Creating chart in excel • Saving you work • Finishing the spreadsheet

18. Summary • Reviewed Previous Day’s work • Took a Pre-Test • Discussed Microsoft Excel 2007 • Explored MS Excel 2007 new interface • New ways to perform familiar tasks • Discussed new features • Watched a video • Did hands-on exercises • Take Post Test