Tuesday, September 3, 2013

Let Excel Be Your Calculator

Do you need to put numbers into a spreadsheet?  Do you need to add, subtract, multiply, or divide them?  If you do then you will want to use the formula features in Excel.  These features will save you time so you don't have to add up the numbers before you enter them into your excel spreadsheet.
  
The example numbers I am using are 9 & 2.  To add numbers and put them into a cell select first you select the cell where you want the numbers to go then enter:

=9+2  

The number 11 will appear in the cell you selected.  If you would like to subtract numbers and put them into a cell then you enter:

=9-2 

(use the * for multiply and / for divide). 

If you want to add several cells together,select the cell where you would like the answer to go and enter the cell information of the cells you want added together. 

For instance say you want to add cell B3 thru B8 and you want the answer to go into cell B9; you select cell B9 then type in that cell:

=SUM(B3:B8)  

The cells you are adding together will highlight as you are typing. The answer will appear in the cell you chose.

If you would like additional training in Excel 2010 or any other program you may sign up for any number of workshops offered by the Technical Education & Outreach team by going to http://www.ferris.edu/tactraining/ and clicking on the "Book NOW!" button. Training is also available via online video through Atomic Learning and Lynda.com.

Written By Carrie Hall