Formulas

• Click the cell you would like to add a formula to. One common use for formulas includes keeping a running total of numbers in a column. Type an equal sign first, followed by the formula you want to calculate. For example, you can add numbers using the formula "=sum( )" where the cells that need to be added are listed inside the parenthesis and separated by commas. The formula "=sum(A1,A2)" would add together cells A1 and A2. Press "Enter" when you've finished entering the formula.
  
  

Worksheets and Workbooks

• A workbook is a collection of worksheets saved under one file name. A worksheet is an individual page, or spreadsheet, inside the workbook. A workbook can be made up of one worksheet or multiple worksheets. For example, you may choose to keep a workbook saved under the name "Money" and have three worksheets inside it labeled "Bank Account," "Savings Account" and "Credit Card Account." This keeps all the worksheets dealing with your finances in one location.
  
  

Adjusting Columns and Rows

• To make a row or column bigger, click one of the two lines dividing the row or column from the others and drag it to the desired size. Entire rows and columns can be deleted by clicking the number or letter representing the row/column you wish to delete and right-clicking. From the menu that opens, choose "Delete." This same menu gives you an "Insert" option as well to add a row/column above or to the left of the highlighted row/column.
  
  

Charts

• To create a chart, enter the data for the chart. For example, you could label rows 1, 2 and 3 as "Jane," "Sam" and "Tom." You might be tracking company employees and how many sales they made. Their names are in column A so you would record the number of sales for each in column B. Highlight all the cells containing the data for the chart and choose "Insert" then "Chart." Choose the type of chart you want and it will appear on the screen.
  
  

Formatting Data

• Format data in a cell, row or column to match your preferences. Highlight the data you wish to format and for Excel 2003 choose "Format" then "Cells." Excel 2007 has a box under the "Home" tab that says "General." Once you have reached the proper screen or clicked the "General" drop-down menu, choose the format you would like, such as "Currency." This changes the formatting of the numbers in the highlighted cells.