Intro-MS Excel 2007

Create a Workbook

To create a new Workbook:

• Click the Microsoft Office Toolbar
• Click New
• Choose Blank Document

If you want to create a new document from a template, explore the templates and choose one that fits your needs.

Save a Workbook
When you save a workbook, you have two choices: Save or Save As.
To save a document:

• Click the Microsoft Office Button
• Click Save

You may need to use the Save As feature when you need to save a workbook under a different name or to save it for earlier versions of Excel.  Remember that older versions of Excel will not be able to open an Excel 2007 worksheet unless you save it as an Excel 97-2003 Format. To use the Save As feature:

• Click the Microsoft Office Button
• Click Save As
• Type in the name for the Workbook
• In the Save as Type box, choose Excel 97-2003 Workbook

Open a Workbook
To open an existing workbook:

• Click the Microsoft Office Button
• Click Open
• Browse to the workbook
• Click the title of the workbook
• Click Open

Entering Data
There are different ways to enter data in Excel:  in an active cell or in the formula bar.
To enter data in an active cell:

• Click in the cell where you want the data
• Begin typing

To enter data into the formula bar

• Click the cell where you would like the data
• Place the cursor in the Formula Bar
• Type in the data

Excel allows you to move, copy, and paste cells and cell content through cutting and pasting and copying and pasting.

Select Data
To select a cell or data to be copied or cut:

• Click the cell

• Click and drag the cursor to select many cells in a range

Select a Row or Column
To select a row or column click on the row or column header.

Copy and Paste
To copy and paste data:

• Select the cells that you wish to copy
• On the Clipboard group of the Home tab, click Copy

• Select the cells where you would like to copy the data
• On the Clipboard group of the Home tab, click Paste

Cut and Paste
To cut and paste data:

• Select the cells that you wish to copy
• On the Clipboard group of the Home tab, click Cut

• Select the cell(s) where you would like to copy the data
• On the Clipboard group of the Home tab, click Paste

Undo and Redo
To undo or redo your most recent actions:

• On the Quick Access Toolbar
• Click Undo or Redo

Auto Fill
The Auto Fill feature fills  cell data or series of data in a worksheet into a selected range of cells. If you want the same data copied into the other cells, you only need to complete one cell.  If you want to have a series of data fill in the first two cells in the series and then use the auto fill feature. To use the Auto Fill feature:

• Click the Fill Handle
• Drag the Fill Handle to complete the cells

Insert Cells, Rows, and Columns
To insert cells, rows, and columns in Excel:

• Place the cursor in the row below where you want the new row, or in the column to the left of where you want the new column
• Click the Insert button on the Cells group of the Home tab
• Click the appropriate choice: Cell, Row,  or Column

 

Delete Cells, Rows and Columns
To delete cells, rows, and columns:

• Place the cursor in the cell, row, or column that you want to delete
• Click the Delete button on the Cells group of the Home tab
• Click the appropriate choice:  Cell, Row, or Column

Find and Replace 
To find data or find and replace data:

• Click the Find & Select button on the Editing group of the Home tab
• Choose Find or Replace
• Complete the Find What text box
• Click on Options for more search options

Go To Command
The Go To command takes you to a specific cell either by cell reference (the Column Letter and the Row Number) or cell name. 

• Click the Find & Select button on the Editing group of the Home tab
• Click Go To

Spell Check
To check the spelling:

• On the Review tab click the Spelling button