How to create formulas in Excel
There’s very little that Microsoft Excel can’t do. At an advanced level, it can automate complex tasks and produce stunning graphs, but even a few beginner tips on creating formulas can have it working wonders for you.
After entering numbers in cells, the most simple way you can save time using Excel is to create formulas. They range from simple addition to cross-referencing multiple spreadsheets. Here’s a quick-start guide.
1. To create a formula in a cell, start with the equals sign (=). Your formula comes after that. For example:
= 10 + 5
would return the answer of 15. Easy hey?
2. If you use cell references instead of values, then the formula will use the values in those cells. For instance::
= C3 + C6
In this example, if cell C3 contained the value 11, and C6 contained the value 20, then those values would be added together, and the formula would return the value 31.
3. This is obviously a sum, and actually SUM is one of the most common formulas in Excel. Most Excel formulas use one of these uppercase terms, such as AVERAGE, COUNT, and IF. In fact, the same result as above can be achieved using the formula:
4. Need to add more values together? Just add more commas, like so:
The values in these four cells will be added together.
5. Actually, in this case, you can do it even more efficiently using the formula:
This trick adds all the value between and including those in cells C3 to C6. It’s invaluable if you’re adding 10, 20, or 500 values together.
What else can Excel do?
Adding numbers together is just the tip of the iceberg. You wouldn’t believe how powerful Excel can be, and the implications for your job prospects can be huge. With the right training, you and your spreadsheets could process as much in 30 seconds as your colleague with a calculator can churn out all day.
If you want to learn more about creating formulas or anything else Excel-related, we’re spotlighting a fast-track tutorial that you can tackle in your own time. Whether it’s 10 minutes in your lunch breaks or intense study to boost your resume, all the training you could possibly hope for is available in the Complete Excel Bundle: Startup Toolbox.
This package contains 14 interactive learning kits covering all aspects of Excel skills, and you don’t need any experience to get started.
It’s worth a whopping $2,800, but it’s on offer from Tech Deals for just $39. Once you’re signed up, you have access for life, so you can take it at your own pace and refer back to it whenever you need a refresher.
Want to find out more? Hit the widget below to check out the deal.
Buy it Now
Buy it Now
Is this deal not quite right for you? To see all our hottest deals, head over to the DEALS HUB.