Virtual Assistants, everything you know about sums is wrong.

VAs: Create Traffic Driving Infographics for Your Clients

If you're a virtual assistant that creates blog posts and helps get traffic to your client websites, then you'll love this Infographic Training Course.

I'll show you how to create traffic pulling infographics using Microsoft Office tools. When you do this training you'll wonder how you've not done this sooner!

Subscribe to be the first to know when it's released.

P.S.  You'll love the emails you'll receive and there will be great deals on additional training for you. You won't be spammed and your privacy is protected.

Virtual Assistants – Everything you know about sums is wrong

Sum in Excel

How did you learn to write a sum at school?

When you went to school you may have learned how to add up a sum like this :

12+3=15

Sum in Excel

 

 

 

And when it comes to putting that into an Excel spreadsheet, you assume it is the same. Excel will add up the numbers won’t it?

So you try it out. Type 12+3 into a cell and then see if you can make it add them up! You will find that you can’t. When you press Enter you will simply see 12+3 in the cell you just wrote them in.

So you might try starting with an = (equals) sign and then typing in 12+3 so it would look like this

=12+3 that will give you the right answer – 15 in the cell.

Will it update if the numbers change?

Here is the thing. Because you used actual hard coded numbers in your formula they are fixed. Hard coded. You typed

=12+3 didn’t you?

So what happens if the 12 or the 3 need to change? You would need to go through and rework all the formulas you had written like this.  Now I have just given you one example but in your spreadsheets its more than likely that you will have several formula throughout the worksheet. Then if the numbers need to change, you will need to locate each one and make the change to the numbers.

Tedious!

It doesn’t have to be like that

If you learn how to build a formula properly using Cell References in the sum rather than hard coded numbers, the result of the sum will change if the number in the cell changes.

So my formula above would look like =A1+A2 – when I press enter it will add up whatever is in A1 and A2 so if the numbers change the results will too.

 

Sum in Excel

 

 

 

 

 

 

 

To learn how to build your formula properly and what happens when you need to add subtract divide and multiply, plus what order Excel will perform this in, then you need to take my course – Essential Excel Skills for Virtual Assistants.

In this course you will learn how to Set up your worksheet in seconds, create calculations and formulas with flair, format everything so that it looks clean and professional (and easy to understand!) and make sure the whole thing works without a worry!

What are you waiting for? Head over there now. The first 10 people who purchase via this link will get 20% off the course.

Enter the coupon code EXCELBLOG20 at checkout to have the discount applied.

 

There will be more Excel courses coming soon – the Mac version of this course is in production now.

About the Author Shelley Fishel

I will help you be more productive and earn more money as a virtual assistant. As a trainer with 20 years experience, you'll love how you'll get between 4-8 hours a week back when you use Microsoft tools to their fullest potential. I'm also the author of several best-selling books on Microsoft Word, PowerPoint, Excel and Outlook, published at www.bookboon.com . Subscribe and get more productive!

follow me on:

Leave a Comment: