Training for Online Teaching

NR Computer Learning Center located in California, USA provides online training to tutors and teachers to those who want to provide online training. Training for Online Teaching (PPT). For further information, call 949-300-9646.

Step-by-Step Instruction for Creating an Address Book using Excel 2007

 

This project will provide step-by-step instructions for using an Excel Spreadsheet to create an Address Book for maintaining the following contact information:

Address Book

  

Step 1: Start the Microsoft Excel Application by clicking on the Start button at the bottom left corner of the Window.  Select All Programs, then Microsoft Office, then click on Microsoft Excel to start the Excel application.

 

Step 2:  Click on Cell D1 in Row 1 and type Address Book.

 

Step 3: To add the contact information headers, click on Cell A2 and type First Name; in cell B2 type Last Name, in cell C2 type Address, in cell D2 type City, in cell E2 type State, in cell F2 type Postal Code, in Cell G2 type Phone, in cell H2 type Email, and in cell I2 type Comments.

 

Step 4: To store contact information in the Address Book, use the same procedure to type in the contact information given below, from Cell A3 to Cell I11.

 

Step 5: To make the text in the header row of the Address Book bold, click on cell A1, hold the <shift> key down, and click on cell I2, so that all the cells from A1 to I2 are highlighted.  Now, click on the Bold icon in the Font group under the Home tab in the Ribbon (circled below) to make the highlighted text bold.

 

Step 6: To color the cells in the header row, first highlight the header row (cells A1 through I2). While this row is selected, click on the Fill Color icon in the Font group under the Home tab in the Ribbon to display all the colors available for filling these cells.  Select a blue color from the dropdown color box and see the cell color change in the highlighted cells.

 

Step 7:  To change the font color of the header row, highlight this row (cells A1 through I2) and click on the Font Color icon in the Font group under the Home tab in the Ribbon. Select a white color from the dropdown font color box. You should now have a blue background with white text for the header row (cells A1 to I2). 

 

Step 8: To center-align the text in the header row, select this row and click on the Center Justify icon in the Alignment group under the Home tab in the Ribbon.  The text in each selected cell will be aligned to the center.

Step 9: To center-align the text in the City, State, Postal code, and Phone columns, highlight cells D3 to G11, click on the Center Justify icon in the Alignment group under the Home tab in the Ribbon to center-align the selected text.

 

Step 10.  To add a border to the cells, select cell A2 and hold down the <shift> key while moving the mouse to cell I11 and clicking. Note that all cells between A2 and I11 will be selected.  Click on the Borders icon in the Font group under the Home tab in the Ribbon to select a way to define the border around the selected text. Select All Borders from the dropdown menu to draw the all the borders around the selected cells in the spreadsheet.

 

Step 11: To preview the spreadsheet before printing, click on the Print Preview icon  in the Quick Access Toolbar.

 

Step 12:  To print the Excel spreadsheet, click on the Office Button and select the Print option.

 

Step 13: Select the correct printer and click on the OK button.

 

Step 14: To save the Excel spreadsheet, click on the Office Button and select the Save As option.  Type the name of the Spreadsheet (Address Book) in the File Name box, and click on the Save button.