Learn Excel Now

Conquer the Fear of Excel

Reviewing Formulas and Functions Part 1: SUM in Excel

by

Mastering Excel formulas can make a world of difference for working professionals. Not only does using formulas save time, but it also ensures that the figures you’re calculating are correct based on the data in your spreadsheet.

Read on and we’ll show you how to use the SUM formula correctly.

SUM in Excel

The SUM function is used to add the values of various cells on an Excel spreadsheet. This option reality simplifies things for working professionals who want to save time and avoid possible mistakes that come from copying data onto a calculator.

Using the SUM Formula

There are a couple of ways to use the SUM formula in Excel. You can either add the values of individual cells or add the values of a cell sequence. 

  • =SUM(C4:C9) – this version is used to add the values of one cell through another in a sequence
  • =SUM(C4, C9) – this version is used to add the values of one cell and another, not in a sequence

We at Learn Excel Now hope you feel comfortable creating using the SUM function in Excel. Next week, we’ll cover the AVERAGE function in Excel so stay tuned!

Like Learn Excel Now? Follow us on social media and share our content with your networks!

Creating Basic Formulas Part 3: Division

by

Excel formulas can simplify the essential mathematical operations of addition, subtraction, multiplication, and division.

In Part 2 of this series, we covered creating basic multiplication formulas in Excel. To finish this series, we’ll tackle how to divide with the program.

Division Formula

Division has the same capabilities as addition and multiplication. To divide cells, you can either type in the totals or the cell names and use the “/” sign to indicate division. If you want to divide C7 and C5, which will be 6 and 2 for this example, you can write the formula as C7/C5 or 6/2.

You can also use the QUOTIENT function, which works the same way the =SUM and =PRODUCT functions do. In the cell where you want your total to appear, type “=quotient” and choose the =QUOTIENT function. Select the cells you want to divide and hit enter.

There are an extensive number of Excel formulas that enable more advanced mathematical functions, but these four are the most essential formulas to learn for Excel beginners.

We at Learn Excel Now hope you feel comfortable creating addition formulas with Excel. Next week, we’ll wrap up this series with how to divide in Excel so stay tuned!

Like Learn Excel Now? Follow us on social media and share our content with your networks!

Creating Basic Formulas Part 2: Multiplication

by

Addition, subtraction, multiplication, and division are essential mathematical functions that can be made easy by using Excel formulas. 

In Part 1 of this series, we covered creating basic addition and subtraction formulas in Excel. This week we’ll tackle how to multiply with the program.

Multiplication Formula

Like adding and subtracting, multiplying cells can be done by typing in the totals or by using the cell names. Let’s say that you want to multiply F4 and F8, which will be 12 and 3 for this example. 

You can name the cells in the formula  =F4*F8, or you can type the totals into the formula =12*3.

The PRODUCT function can also be used to multiply different cells. To use it, click on the cell where you want your total to appear, then type in “=product” and choose the PRODUCT function. Then, as with using the =SUM function, select the cells you want to multiply and hit Enter.

We at Learn Excel Now hope you feel comfortable creating addition formulas with Excel. Next week, we’ll wrap up this series with how to divide in Excel so stay tuned!

Like Learn Excel Now? Follow us on social media and share our content with your networks!

Creating Basic Formulas Part 1: Addition and Subtraction

by

Excel can be intimidating for people who have just been introduced to the program, but basic mathematical functions are relatively easy through Excel when you know the right formulas.

To begin, we’ll just cover the basic formulas for now: Addition, Subtraction, Multiplication, and Division.

Let’s begin with Addition and Subtraction.

Addition Formula

The basic way to add numbers from different cells on your Excel spreadsheet involves writing the first cell name (the column and row letter and number), then the plus (+) sign, then the next cell name. For example, =C5+C8.

If you want, you can also combine the numbers in the cells you want so that you don’t have to type in the cell names. This can be done by typing the list of numbers into the upper input bar. For example, =5+3+4+12+9 (let’s say these are the numbers in E3 to E7).

You can also use the SUM function by typing “=sum” into the area where your totals will be recorded. Once the SUM function populates, you can select all of the cells you want to include in the addition formula.

Subtraction Formula

Much like creating an addition formula, subtraction can be done by typing in the first cell name you want to use, then the subtraction (-) sign, then the next cell name. For example, =B4-B2.

You can also subtract the number totals the same way you can with addition. However, there is no subtraction function in Excel.

We at Learn Excel Now hope you feel comfortable creating addition formulas with Excel. Next week, we will cover how to multiply in Excel so stay tuned!

Like Learn Excel Now? Follow us on social media and share our content with your networks!

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.

Connect with Us

Contact

Learn Excel Now
questions@learnexcelnow.com
1-484-259-7664 or 1-800-964-6033
660 American Ave
Suite 203
King of Prussia, PA 19406

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

Copyright © 2023 ­Learn Excel Now

Terms of Service

Privacy Policy