VisiCom Services Blog

VisiCom Services has been serving the Rochester Hills area since 1994, providing IT Support such as technical helpdesk support, computer support, and consulting to small and medium-sized businesses.

Formulas and Reactions 101: Microsoft Excel 2013 Edition

b2ap3_thumbnail_microsoft_excel_400.jpgDo you have trouble keeping track of your budget and expenses within your company? It's not your fault - prices change over time, and paperwork can be tedious to go through. By taking advantage of Microsoft Excel's basic mathematical formulas, you can simplify the way that keep track of your business's budget.

Mathematical Orders
Just like a calculator, Excel operates by using mathematical symbols when running formulas:

Addition: +
Subtraction: -
Multiplication: *
Division: /
Exponents: ^

The formulas begin with an equals sign (=), the reason being that the cell itself contains the result of the formula entered. For example: =5+3 would create the number 8 in that cell.

Cell References
In addition to entering Excel formulas manually, you have the option of using cell addresses to enter a formula into a spreadsheet. Cell addresses are a combination of letters and numbers that determine the location of the cell on the chart. Columns and rows are what determine this address. By using cell addresses when entering formulas, you can know for sure that the values are accurate in the calculation. For example: =A3*A5 or =B2-A1

The cell addresses represent the value entered into that particular cell. You can also use a combination of cell addresses and cell numbers. For example: =C6/2 or D1*4 or B6^2

Creating Formulas
We'll show you how to use Microsoft Excel 2013 to build a budget spreadsheet using formulas.

  1. Select a cell for the formula. Here, we select the cell B3.
  2. Next, enter the formula in the formula bar. You'll notice that whatever you enter into the formula bar will also appear in the selected cell.
  3. Type the cell address of a cell you wish to use for the formula. For instance, cell B1 contains the budget surplus left over from December 2013, while B2 has January's budget. We want to add those two numbers together. Type B1 into the formula bar, and notice the blue border. That indicates that you will be using the selected cell.
  4. Type the cell address of another cell with a mathematical operator. Here, we'll add B1 and B2. The second referenced cell will have a red border surrounding it.
  5. Press Enter, and the formula will be calculated and place the value in the displayed cell. If the formula is too big to display in the selected cell, it will appear as pound signs (#). If this happens, increase the column width and the content should show properly.

Modifying Values for Formulas
Let's say that you have decided to increase the marketing budget for the next year. With cell references, you'll be able to change the value of one cell and Excel will automatically recalculate the value of the formula. However, you should make sure that the calculation is correct, as Excel will not tell you if the recalculated value is invalid.

Whether you are simply trying to figure out your budget from last year, or are trying to get ahead by planning for the future, using formulas will help you keep your company's assets managed neatly and efficiently. For more tips and tricks on how to use the latest Microsoft Office applications, contact VisiCom Services at 248.299.0300.

Comments

 
No comments yet
Already Registered? Login Here
Guest
Thursday, 18 July 2019
If you'd like to register, please fill in the username, password and name fields.

Sign Up For Our Newsletter

Powered by ChronoForms - ChronoEngine.com

Mobile? Grab this Article!

QR-Code dieser Seite

Recent Comments

Tip of the Week: Tip of the Week: Mirror or Cast Your Android Device’s Screen
14 September 2017
Usually I don't refer spending time like these categories subjects and website but really the blog w...
Tip of the Week: 4 Google Chromecast Features that May Surprise You
05 September 2017
I’m really satisfied to find this site.I need to thank you only for this brilliant read!!I unquestio...
Microsoft OneNote May Be the Best Note-Taking Tool on the Market
27 June 2017
I blog frequently and I really value your substance. The article has really crested my advantage. I ...

Latest Blog Entry

17 July 2019
Visicom Blog
Tip of the Week
Businesses often utilize signage to direct visitors to specific points of interest in their offices, but with the advent of digital technologies, the potential for digital signage is nearly endless. I...

Latest News

Contact Us

Learn more about what VisiCom Services can do for your business.

callphone

Call us today    248.299.0300

2534 S Rochester Road
Rochester Hills, Michigan 48307

#