Working with Excel 2007 workbook
How to Create a Workbook
To create a workbook:
- Click the Microsoft Office Toolbar
- Click New
- Choose Blank Document
How to create a new Workbook Using Template
If you want to create a new document from a template, preview the templates and select any that soothes your needs.
Do the following:
Click on the Microsoft office button
Click install templates
Click on any template design you want and
Click create at the bottom.
How to Save a Workbook
When you want to save a workbook, you are provided with two options:
Save or Save As.
To Use Save
· If the document had been previously saved with a name,
To Use Save As
· When saving for the first time,
· You want to rename the document / workbook
· You want to save to a different location outside your document folder etc..
To save a document:
- Click the Microsoft Office Button
- Click Save
To use the Save As:
- Click the Microsoft Office Button
- Click Save As
- Type in the name for the Workbook
- In the Save as Type box, choose Excel 2007 Workbook
- Then click Save
How to open an existing Workbook
To open an existing workbook:
- Click the Microsoft Office Button
- Click Open
- Search for the name of the workbook you want to open and
- Click Open
Before you start entering your data, lets take an overview on Cells.
Excel is made up of Rows and Columns.
Rows are numbered at the left side of the window and Columns are represented by Letters above each column.
Now, where a Row and a Column intersect form a Cell(s). So, each Cell gets its name by the combination of a letter and a number, and this will be displayed in the name box below the Microsoft office button.
To start entering data in a cell:
Click in the cell where you want the data
and begin typing
You can also use the formula bar to insert data
- Click on the cell where you would like to insert the data
- Place the cursor in the Formula Bar
- Type in your data into the formula bar
