Written by Upendra Kumar
|
|
Saturday, 07 July 2007
Category MS Excel 2007 - Misc.
|
| |
| General Information |
| |
 |
| |
Opening Excel
Create a database from a template
Creating a new WorkBook
Working with cells
Keyboard abbreviated methods
|
| |
|
| |
|
Microsoft Office Excel 2007 is an effective tool that can use to create and to apply format to spreadsheets, and to analyze and to share information to make
decisions better founded. |
| |
|
Office Excel 2007 takes advantage of its new user interface oriented to the results to facilitate the access to effective productivity tools. Also it offers
more space to work and a faster operation. |
| |
| Opening Excel |
| |
| 1) Click on the Start button. Then select Programs >> Microsoft Office >> Microsoft Office Excel 2007 menu item. |
| |
| 2) A new blank workbook, Book1, will be displayed. |
| |
|
| Illustration 1: Excel empty workbook. Click here to view larger image. |
| |
| 3) Upper the grid area, you will see the columns, named with letters from A. |
| |
| 4) A t the left area, you will see the rows numbers. Then, cells are referenced by their column name and row number. As you
can see in the above image, the cursor is positioned at cell D8. |
| |
| 5) The Options Tape extends throughout the superior part of Excel and their related commands are organized in groups. Each group is related to a
specific work that the people can make in Excel. |
| |
|
| Illustration 2: Options Tape and Groups. Click here to view larger image. |
| |
| 6) In order to see the different commands in each group, you must click in groups located in the superior part of the tape of options. The card Home,
that is the first card beginning by the left, contains the habitual commands that people use more frequently. |
| |
| 7) The commands are organized in small related groups. For example, the commands to edit cells are in the group Font, and the commands to
work with cells are in the group Cells. |
| |
|
| Illustration 3: Commands related to a group. |
| |
| 8) The first book opened is denominated Book1. This title appears in the bar at upper side of the window until the book is saved with a new name. Each
new book has three sheets, like the pages of a document. Within the sheets you can specify data. Sometimes the sheets receive the name of spreadsheets. It
is recommended to change the sheet's name to more easily identify the information contained in each one. |
| |
|
| Illustration 4: Book sheets. |
| |
| Creating a new WorkBook |
| |
|
