Excel+2007

** Get a handle on the new look of Excel. ** Find everyday commands on the Ribbon: Cut, Copy, Paste, Insert Sheet Rows, Insert Sheet Columns, and Sum. Save workbooks in the new Excel file formats. What you need is now more clearly visible and more readily available. Instead of having 30 or so undisplayed toolbars, and commands buried on menus, you have one control center — the Ribbon, which brings together the essentials and makes them very visual. When you try the new design, you'll discover that the commands you already know how to use are grouped together in ways that make sense to you.
 * What’s New with Excel 2007? **

There are three basic components to 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 commands on the Ribbon are the ones you use the most. Instead of showing every command all the time, Excel 2007 shows some commands when you may need them, in response to an action you take. Click the arrow at the bottom of a group to get more options if you need them. As you work on a worksheet, you take some actions that are general, or repetitive, and that don't have to do with a particular phase of the process, such as saving your file or undoing something you didn't mean to do. For such things, use the Quick Access Toolbar. It's the small group of buttons on the left, above the Ribbon. It contains the Save, Undo, and Repeat or Redo commands. Options for the Quick Access Toolbar · Adding commands to the Quick Access Toolbar · Removing commands from the Quick Access Toolbar · Moving the Quick Access Toolbar 1 - Column headings 2 - Row headings 3 - Margin rulers Not only is the Ribbon new in Excel 2007. Page Layout view is new too. If you have worked in Print Layout view in Microsoft Office Word, you'll be glad to see Excel with similar advantages. To see the new view, click Page Layout View on the View toolbar on the bottom right of the window. Or click the View tab on the Ribbon, and then click Page Layout View in the Workbook Views group. In Page Layout view there are page margins at the top, sides, and bottom of the worksheet, and a bit of blue space between worksheets. Rulers at the top and side help you adjust margins. You can turn the rulers on and off as you need them (click Ruler in the Show/Hide group on the View tab). It's easy to add headers and footers in Page Layout view. When you type in the new header and footer area at the top or bottom of a page, the Design tab opens with all the commands you need to create your headers and footers. Right-click a button you added on the Quick Access Toolbar. Click Remove from Quick Access Toolbar. Like the previous “File” menu. This is also where the “options” from the previous “Tools” menu are! Before getting down to business, notice that this menu is packed with useful items. Click **Excel Options** at the bottom of the menu to access the options. Format data and edit data by using commands in groups on the Home tab. ** In the Font group, you click the arrow on Font Color, and you see many more colors to choose from than before in Excel. You can see how the title will look in different colors by pointing at any color and waiting a moment. This preview means that you don't have to make a selection to see the color, and then undo your selection if it's not what you want. When you see a color you like, click it. Adjust the: · Font Size · Alignment · Styles To enter a simple formula, on the Home tab, in the Editing group, click the Sum button. Before handing off the report, you want to add up the numbers in the Quantity column. That's easy — use the Sum button. To do more than add, click the arrow on the Sum button. Then click any of the functions on the list that appears: Average, Count, Max, or Min. If you click More Functions, Excel opens the Insert Function dialog box where you can choose from all of the Excel functions. Or click the Formulas tab and check out the Function Library and Calculation groups. First, change to Page Layout view. Click the View tab, and then click Page Layout View in the Workbook Views group. (Or click the middle button on the View toolbar at the bottom of the window.) It is very easy to add headers and footers in Page Layout view. Instead of opening a dialog box to add a header, just click in the area at the top of the page that says Click to add header. As soon as you do, the Header & Footer Tools and the Design tab appear on the Ribbon. These have all the commands to work with headers and footers. There's also a command, new in Excel 2007, to apply different headers and footers on odd and even pages In **Page Layout** view, you can make adjustments to your worksheet and see the changes on the screen, before you print. Click the **Page Layout** tab to fine-tune your printing options. On this tab, in the Page Setup group, you can click **Orientation** and then select **Portrait** or **Landscape**. In Page Layout view, you'll see the orientation change, and how your data will look each way. Still in the **Page Setup** group, click **Size** to choose paper size. You'll see the result of your choices as you make them. What you see is what you print. The New Workbook window offers you everything from a blank workbook to online Excel templates. Excel 2007 has a new file format. Why? Increased security for your files; reduced risk of file corruption; reduced file size; and new features. In Excel 2007, you can open files created in previous versions of Excel, from Excel 95 through Excel 2003. But what if you're the first person in your office to have Excel 2007? What if you need to share files with departments that don't have Excel 2007 yet? You can all share workbooks with each other. Here's how: If you have questions, try the help menu first. It is the blue question mark in the upper right-hand corner.
 * The Quick Access Toolbar **
 * The new Page Layout view in Excel **
 * Delete a button **
 * Microsoft Office Button ** –
 * Microsoft Office Button ** in the upper-left corner of the window. There you'll get the same commands you've used in the past to open and save your workbooks.
 * Entering Simple Formulas **
 * Add Headers and Footers **
 * Printing – Check out the Page Layout tab first! **
 * New Workbook Window **
 * New File Format **
 * How do I work with people who don't have Excel 2007 yet? **
 * Old files stay old ** unless you choose otherwise. If you open a file that was created in a previous version, when you save that file and any work you do in it, the automatic setting in the Save As dialog box is to save the file in the original version's format. If it started in Excel 2003, Excel 2007 saves it in the 2003 format unless you say otherwise.
 * Newer features warn you if you save ** ** a file as older ** . When you save a file in a previous version's format, if any 2007 features are not compatible with the previous version, a Compatibility Checker tells you so.
 * New features ** In addition to the features you've seen in the previous lessons, the number of rows on a worksheet has gone from 65,536 to 1,048,576. The number of columns has increased from 256 to 16,384. You can write longer formulas in the new resizable Formula Bar. And if you click large chunks of text in a cell, the Formula Bar no longer spills into the worksheet grid.
 * Safer files ** Workbooks containing unwanted code or macros are easier to identify and block.
 * Less risk of file corruption ** Excel has an improved ability to open corrupt files and recover some of your work that might otherwise have been lost.
 * Reduced file size ** Workbooks are compressed; file size is approximately 50 percent to 75 percent smaller than in previous versions of Excel. You open and save the compressed files as you are used to opening and saving any Excel file.
 * More useful data ** More can be done with the data because its basis in XML makes it much easier to integrate with other data sets from other computers and programs. For example, store your budget data in a specialized program, select what you need, and import it into a Word document, an Excel worksheet, and an Access database.