![]() How pivottable reports organize, summarize, and analyze data. How to create a chart using the new Excel 2007 commands and make changes to a chart after you create it Pivottables in EXCEL 2007 How to find the number of days between dates, or the date after a number of workdays, or the date after a number of days, months, or years Charts I: How to create a chart in Excel 2007 How to enter simple formulas into worksheets, and how to make formulas update their results automatically Learn how to figure out dates using formulas in Excel 2007 How to create a workbook, enter and edit text and numbers, and add rows or columns Get to know Excel 2007: Enter formulas Get to know Excel 2007: Create your first workbook This concludes the lesson on Microsoft Office 2007 excel features and overview.Introductory Tutorials from Introduction to EXCEL 2007ĭescription of the layout How to accomplish everyday tasks in Excel 2007, and a bit about the XML file formats. Microsoft Excel 2007 Tutorial - Free & Online Also observe that on top of the shortcut menu, you will find the Mini Toolbar for an easy access and use Related links: If you notice the Shortcut Menu not only has formatting commands for cells, you can also view commands like copy, paste, change column and row settings and add comments. Here is a screen shot of what Shortcut Menu looks like on our Budget workbook. The Shortcut Menu changes depending on what screen and what application you are in. ![]() The idea is to have common commands available to you as you’re working on your spreadsheet. The last thing we want to talk about is the Shortcut Menu sometimes also known as the Right Click Menu or Context Menu. These steps are shown in the next two figures. This will add the Spelling command to the quick access toolbar and will be present at all times. Next move the mouse over the Spelling command, right click and then select Add to Quick Access Toolbar. Let us say that you wanted to add the Spelling command to your Quick Access Toolbar. You can browse to the Review Tab and then the Proofing group. You can customize the Quick Access Toolbar to add the more often used commands. Here is what the Quick Access Toolbar looks like on my screen. Out of the box, Quick Access Toolbar has the Save, Undo, and Redo commands. The Quick Access Toolbar is a global toolbar which is present regardless of what tab you are on. The next new feature in Microsoft Excel 2007 that we are going to look at is the Quick Access Toolbar. The Tabs (top) And that Groups (bottom) are shown in the figure below and highlighted using red rectangles. The tabs are further broken down into logical groups. For example if you’re trying to insert an object, you will find the related commands under the Insert Tab. ![]() The Ribbon in Microsoft Excel 2007 is broken down into Tabs that deal specifically with a certain task. Included is a screen capture of what the Ribbon looks like. The idea is to give the user a task oriented interface where one will spend more time working on the actual workbook and less time looking for specific commands. ![]() The Ribbon is what Microsoft is calling the new user interface. In Microsoft Excel 2007, the old Menus and the Toolbars have been replaced by what’s called the Ribbon. For example, when I selected the Print command, I was given the fly out menu with additional print options like Print, Quick Print and Print Preview. When I clicked on the Office Button in Microsoft Excel 2007, this is what I saw.Īs you click on the various commands, you will be given related options. Commands are listed on the left, and recently opened files appear on the right side. The Office Button provides functionality common to all Office applications, including opening, saving, printing, and closing a file. The Office Button in Microsoft Excel 2007 replaces the File menu available in previous versions of Excel. Let us take a look at microsoft office 2007 excel features like the following: The focus behind the change is an optimized, task oriented approach which translates to better spreadsheets prepared in less time. Microsoft Excel 2007 has a brand new look and feel. Microsoft office 2007 Tutorial Excel features and overview Insert Tab
0 Comments
Leave a Reply. |