Sunday, July 19, 2009

Creating an Excel 2007 Spreadsheet


Starting Excel 2007

In the following exercises you will learn some of the necessary steps to create a spreadsheet using Microsoft Excel 2007. You will learn not only how to type various items into the spreadsheet, but also how to copy columns, widen columns, fill columns, add, subtract, multiply, divide, do graphics and a variety of other “things.”
To begin, load the spreadsheet by quickly clicking twice on the Excel 2007 Windows Icon in the Windows Desktop. If you do not see an Excel Icon, click the Start Button in the lower left corner of the screen, move the cursor up to Programs, then move to Microsoft Office. Move down to Microsoft Excel 2007 and click.

A spreadsheet is a “number manipulator.” To make the handling of numbers easier, all spreadsheets are organized into rows and columns. Your initial spreadsheet will look something like the one below:


Notice that the “main” part of the spreadsheet is composed of Rows (Labeled 1, 2, 3, 4, etc.) and Columns (Labeled A, B, C, D, etc.). There are a lot of rows and columns in a spreadsheet. The “intersection” of each row and column is called a cell. In the image above the cursor is on the “home” cell – A1. Notice Row 1 and Column A are “bold,” and colored “orange.” This indicates what is called the “address of the cell. Notice right above cell A1, that A1 is displayed in a small box called the Name Box. Whenever you “click” on a cell the address of that cell will be shown in the Name Box.

If you have used previous versions of Microsoft Excel you will quickly notice that the above image is very different from what you are used to seeing. In Excel 2007 you will now use Tabs, Ribbons and Groups, as well as special Tabs/Ribbons. These replace the Menu Bar and Buttons in older versions. For an overview of 2007 Office, please see the Introduction to Microsoft Office 2007 Tutorial. This short tutorial introduces you to the many enhancements in the 2007 Office Suite.

No comments:

Post a Comment