Learn Excel Now

Conquer the Fear of Excel

Keep up to date on all the newest live trainings, events, and tutorials.

  • Home
  • Training
    • Live Training
    • eLearning
    • On-Demand Training
  • All-Access
  • Resources
  • Library
  • Contact

Basic Calculations in Excel: How to Quickly Find the Answers You Need – Video

February 17, 2016 by Tyrone Pernsley

Excel has tons of formulas, functions and features to make calculations for your data. But you can also do basic calculations in Excel without using formulas. Basic calculations in Excel are great for quickly finding the results you need – be it addition, subtraction, multiplication or division – without having to enter any clunky formulas (or remembering them!)

LEN-WebVideo_BasicFormulas from Learn Excel Now on Vimeo.

Please enjoy this video on basic calculations where you will discover:

  • How to set up basic arithmetic in a cell
  • How modifying a cell in a formula will affect the answer

As you can, basic calculations in Excel are quick and easy. Here are a few keys to remember when doing basic calculations in Excel:

  • All formulas begin with the equal sign: =
  • For addition, you want to use the plus sign: +
  • For subtraction, us the minus sign, also the hyphen: –
  • For multiplication, use the asterisk (shift+8): *
  • For division, use for forward slash: /

Basic calculations in Excel are perfect when you need to find a result quickly and easily. For example, if you have two rows of sales totals and want to know their total sum, you can enter:

=(Cell1+Cell2)

Or let’s say you have a revenue and one column and cost in another want to find profit, you would enter:

=(Cell with profit total – Cell with cost total)

Another key to remember is that all cells in Excel have an alphanumeric designation; where the cell begins with the Column identify letter and ends with the Row identifying number (e.g. A1, B2, etc.)

Using the cell destination, rather than value in the cell, allows to the outcome of the formula to change if the cell value is changed.

You should be all set for using Basic calculations in Excel!

We at Learn Excel Now hope you found this week’s tip useful. Please subscribe to the newsletter to stay up-to-date with our latest tips, guides, tutorials and training!

Like Learn Excel Now? Get social with Excel! – Share this post with anyone needing Excel help on social media.

Kevin – Learn Excel Now

Filed Under: Formulas & Functions Tagged With: Excel 2010, formulas

Keep up to date on all the newest live trainings, events, and tutorials.

All Access Subscription
Our 1-year all-access subscription provides step-by-step guidance for mastering Microsoft Office applications, with workshops, exercises and quick reference eGuides. It's perfect for anyone that needs to brush up on certain skills or even folks who need to learn the programs - from a beginner’s level.
Excel Foundations
Take the fear out of Excel with this 20 module self-paced training course. You will cover the most essential topics to develop a solid foundation of Excel or a lifetime of mastery.

Learn Excel Now helps you conquer the fear of Excel. By providing self-paced and instructor-led training and free strategies and guides, we leave no Excel mystery unsolved.

Sitemap

  • Home
  • Training
    • Live Training
    • eLearning
    • On-Demand Training
  • All-Access
  • Resources
  • Library
  • Contact

Connect with Us

  • Facebook
  • Linkedin

Contact

Learn Excel Now
questions@learnexcelnow.com
1-800-964-6033
384 Technology Drive
Malvern, PA 19355

Microsoft® Office Excel® is a registered trademark of the Microsoft Corporation in the United States and other countries. All rights reserved.

Copyright © 2020 ­ Learn Excel Now

Copyright © 2021 · News Pro Theme on Genesis Framework · WordPress · Log in