# Welcome

Document Sample

```					Welcome to Excel Basics… In order to truly understand Excel, you need to be familiar with: * Navigating through workbooks and worksheets, * Cell formatting and style, * Selecting, copying and moving data, * Mathematical functions, and * Formatting and printing worksheets and workbooks. This tutorial will introduce you to these topics, and is designed to work best with Excel 2003. Let's begin...

You have just opened an Excel workbook and are looking at the Welcome worksheet. In Excel, when you open a new workbook, you are automatically provided with three worksheets, which you can rename. You can also insert new worksheets by going to the Insert menu and choosing Worksheet. In this workbook, the worksheets have already been named for you, such as Checkbook, Statistics and Fun.

Exercise 1  Click on the worksheet tabs along the bottom of the screen and review the different worksheets in this workbook. Continue to the Welcome 2 worksheet when you are finished. NOTE: If you have any questions along the way, consult the "Help and Credits" worksheet at the end of this workbook for instructions.

Press Tab Press Tab Press Tab Press Tab Press Enter Press Tab Press Tab Press Tab Press Tab Press Enter Press  Press  Press  Press Tab Press Tab Press Enter Press  Press  Press  Press  Press Tab Press Tab Press Enter Press  Press Tab Press Enter Press  Press Shift-Tab Press  Press  Press  Press  Press  Press Enter Press  Press Shift-Tab Press Shift-Tab Press Shift-Tab Press Shift-Tab Press  Press  Press  Go back to A1 and do it again until you are comfortable navigating using the Tab and Arrow keys.

Exercise 1, continued 

Now that we know how to navigate between worksheets, let's spend a bit more time navigating within one worksheet. Click on cell A1 and follow the directions in each cell to work through this worksheet. When you are finished, click the Checkbook tab to go to that worksheet.

Exercise 2 

Let's create a checkbook ledger. 1 In Row 1, in columns A through D Funds Available. Use Word Wrap if needed. (Go to Alignment and select Wrap Text). 2 Move the mouse pointer over the letter once to highlight the column. 3 Go to the Format menu and select 4 Click on the Number tab. 5 Choose the Date data type and pick a data format such as OK. 6 Do the same for the remaining columns ( Currency for each column. 7 Move the mouse pointer over to the number row. 8 Go to the Format menu and then select 9 Look through the options under the 10 Center your headings and make them 11 Add a few sample deposits and withdrawals to your tabl "Funds Available" column for now.

Go to Checkbook 2 when you're finished and continue with

through D type Date, Deposit, Withdrawal and Word Wrap if needed. (Go to Format → Cells → rap Text). pointer over the letter A (in the gray column bar) and click

data type and pick a data format such as 3/14/01, and click

he remaining columns (B-D) and set the data type to

pointer over to the number 1 and click once to highlight the

menu and then select Cells. options under the Alignment and Font tabs. dings and make them bold. e deposits and withdrawals to your table. Ignore the olumn for now.
when you're finished and continue with Exercise 2.

Date 03/04/00 03/04/00 03/06/00 03/07/00 03/10/00 03/12/00 03/15/00 03/18/00 03/18/00 03/22/00 03/25/00

Deposit \$500.00

Withdrawal \$250.00 \$24.45 \$45.90 \$101.02

Funds Available

Exercise 2, continued 

\$220.22 \$136.89 \$4.31 \$40.00 \$3.50 \$28.98

12 Click and drag from cells B13 to B2. 13 Click on the Σ button on your toolbar (the AutoSum feature) to sum up your deposits. 14 Calculate the sum of your withdrawals, totaling them in cell C13. Type an = (equal sign) in cell C13, and click on the fx symbol (Insert Function) in the gray formula bar. Select the SUM function and click OK. In the Function Arguments window which appears, verify that cells C2 through C12 will be totaled. Edit as needed. Click OK. 15 Click on cells B13 and C13, and look in the Formula bar to see how the totals were calculated. 16 Click in cell D2, type 500 and press Enter. (Notice how it has been formatted for currency for you already.) 17 Click in cell D3 and type =D2+B3-C3 in the formula bar and press Enter. 18 Click in cell D3 to make it active, and then go to the Edit nenu and select Copy. 19 Click and drag to select from cells D12 to D4. 20 Go to the Edit menu and select Paste. What was the result? You have completed Exercise 2! Be sure to SAVE your work! Go to the file File menu and select Save As. Rename your workbook (so that you can repeat these worksheets later) and click SAVE. When you are finished, go to the Statistics worksheet.

Librarian Greg I.M. Peter Alexander Ernie Bert Frida Ansel Phil Bobby Claudia

No. Reference Questions McKeldin 10 Architecture 68 McKeldin 27 Architecture 95 Engineering 12 Engineering 45 Art 17 Art 58 Performing Arts 64 McKeldin 61 Chemistry 43 Library

Exercise 3 

1 Click and drag from C12 to A1. 2 Go to the Data menu, and select Sort. Sort the list by Library 3 In cell B14, type Average. Click in cell C14, and type = (equal sign). Click on the small downward arrow next to the word SUM above cell A1. Select the Average function to calculate the average number of questions. Verify that cells C2:C12 will be averaged. 4 In cell B15, type Maximum. Click in cell C15, type = (equal sign) and select the Max function from the list above Cell A1 to calculate the maximum number of questions. Verify that cells C2:C12 will be calculated. Click OK. 5 In cell B16, type Minimum. Click in cell C16, and choose More Functions...In the "Insert Function" box that appears, type Minimum in the "Search for a Function" and click GO. Choose from the list that appears and click OK. Verify that cells C2:C2 will be calculated, and click OK. 6 In cell B17, type Total Questions, and use Word Wrap if needed. In cell C17, use the SUM function once more to total the questions in cells C2 through C12. 7 Experiment with this feature until you become more comfortable. 8 Save your work when finished. When you are finished, go to the Fun worksheet.

Library. (equal

function to erify that cells C2:C12

(equal sign) e Cell A1 to calculate at cells C2:C12 will be

, and choose More appears, type . Choose MIN that cells C2:C2 will

Word Wrap if ce more to total the

me more comfortable.

Exercise 4 

Note: If you need to repeat an exercise, close this workbook (if you renamed it) and open ExcelOverview again, or close this workbook without saving it again and reopen it to repeat exercises on this worksheet. Happy Excel-ling!

cises to

hand e button

heet tab

ars, and

reopen

Help and Credits

Accessing Excel Help
There are a number of ways to access help features within Excel. • To open the Excel Help task pane [NEW In Office 2003] you may either: -- Press F1, -- Click on the Help button on the Standard Toolbar, or -- Go to the Help menu and select Microsoft Excel Help.
You can also: • Double-click on the Office Assistant. A dialog box will appear for you to enter your query. Click Search when ready. (If the Assistant is not visible, go to the Help menu and select Show the Office Assistant).

• Type in a keyword or phrase in the Search for: box located on the right side of the menu bar and press Enter. [NEW In Office 2003]

Workbook created for Excel 97 by Stephen Spohn, Staff Learning, June 2000.
Revised and updated for Excel 2003 - October 2004 Maggie Saponaro, Staff Learning.

Prepared by Staff Learning And Development 11/8/2009

Page 12

```
DOCUMENT INFO
Shared By:
Categories:
Stats:
 views: 20 posted: 11/8/2009 language: English pages: 12
How are you planning on using Docstoc?