Microsoft Excel is a useful spreadsheet creation tool that is very easy to use. Before you start to use the program, we recommend brushing up on some of Excel’s basic formulas. Here are a few helpful hints to make addition, multiplication, subtraction, division and more much easier in Excel.
Let’s say you have a series of numbers you want to work with. You can perform a variety of mathematical functions with these digits by clicking in an open cell and following these instructions:
Addition
1. Type in “=sum(”
2. Click on the first cell that you want to add
3. Press the “+” key
4. Click on the next cell in the series
5. Repeat steps 3 and 4 until you have selected all of the numbers of the equation
6. Press the “enter” key
7. The sum of the numbers will appear in the blank cell you initially selected
Averages
1. Type in “=average(”
2. Type in the name of the first cell in your series (ex: A1)
3. Press the “:” key
4. Type in the name of the last cell in the series (ex: A5)
5. Press the “enter” key
6. Excel will automatically find the average of the numbers from the first cell in the series to the last.
Count (Used to count the number of entries you have in a database)
1. Type in “=count(”
2. Type in the name of the first cell in your series
3. Press the “:” key
4. Type in the name of the last cell in the series
5. Press the “enter” key
6. Excel will automatically count the number of entries from the first cell in the series to the last.
Max (Used when you have a lot of numbers and want to find the biggest in the series)
1. Type in “=max(”
2. Type in the name of the first cell in your series
3. Press the “:” key
4. Type in the name of the last cell in the series
5. Press the “enter” key
6. Excel indicate the largest number in the series and place it in the blank cell you initially selected.
You can also create equations for numbers you have not yet entered into a cell. For example, say you wanted to add 1, 2 and 5. Click in a blank cell and type “=1+2+5” and then press “enter.” The program will add the numbers together for you. If you wanted to add the same numbers and then divide them by half, type “=(1+2+5)/2” and then press “enter.”
Did this help you? Maybe you have more ideas for videos. Be Your Own IT is committed to helping a community of users just like you with our Computer Repair Forums and other useful Computer Repair Videos. Please let us know if you need any more additional help or ideas for more free video ideas. Be Your Own IT is also committed to bringing you some of the top Computer Repair Training Courses on the web.
Order the NEW 2011 Computer Repair Home Study Course
Yes! I would like Be Your Own IT's
Computer Repair Home Study Course (learn more)
Select the Version You'd Like:
How the order process works
- You will be transferred to a secure server at 1ShoppingCart (https://www.mcssl.com)
- You will be asked to fill out your payment information
- Your payment will be processed by the 1ShoppingCart secure server
- Your order will be done
- You will be transferred back to www.beyourownit.com
- You will be provided a login/password and a special download page where you can watch and download the course
