When I first started using Excel, I thought it was just a digital table. But once I learned how to make it calculate things automatically, my mind was blown. Excel isn’t just about typing numbers—it’s about making those numbers *work for you*.
In this tutorial, we’ll explore the four pillars of arithmetic in Excel: addition, subtraction, multiplication, and division. Trust me, once you get the hang of these, you’ll start seeing Excel as your personal calculator on steroids.
Table of contents [Show]
Arithmetic functions are the foundation of Excel formulas. They let you perform calculations just like on a calculator—but smarter, because Excel can handle hundreds of numbers at once! The four basic operations you’ll use most often are:
In Excel, every formula starts with an = sign. This tells Excel that you’re about to enter a formula, not just text.
Addition is one of the simplest and most common operations in Excel. You can use it to sum numbers, add totals, or even combine results from different cells.
=10+20
Excel will display 30 as the result. Simple, right?
Let’s say you have values in cells A1 and B1, and you want to add them:
=A1+B1
This formula will take the value in cell A1, add it to B1, and show the result.
Instead of writing long addition formulas like =A1+B1+C1+D1, use the SUM function:
=SUM(A1:D1)
This adds up all the values from A1 through D1 in one go.
Subtraction in Excel works just like addition, but instead of combining values, you’re finding the difference between them.
=50-20
The result will be 30.
If you want to subtract the value in B1 from A1:
=A1-B1
This is useful for finding remaining amounts, like profit after expenses or stock balance after sales.
Imagine you’re tracking your monthly budget. Your income is in cell A2, and your expenses are in B2. To find your savings, use:
=A2-B2
Excel will automatically calculate your remaining amount. One glance, and you’ll know whether you can afford that weekend pizza party!
Multiplication helps you quickly find totals like price times quantity, area, or even growth factors. The multiplication operator in Excel is the asterisk (*), not the “×” symbol you might be used to.
=8*5
Excel returns 40.
=A1*B1
If A1 has 10 (price per item) and B1 has 3 (quantity), Excel will return 30.
Suppose you have a product list where column A has Price and column B has Quantity. To find the total revenue per product in column C:
=A2*B2
Then, drag the fill handle (that tiny square in the corner of the cell) down the column to apply the formula for all rows.
Division in Excel uses the forward slash (/) symbol. You can use it to calculate ratios, unit costs, averages, and much more.
=100/5
The result will be 20.
=A1/B1
If A1 contains 50 and B1 contains 10, Excel will return 5.
If you divide by zero, Excel will show an error: #DIV/0!. To handle this gracefully, you can use the IFERROR function:
=IFERROR(A1/B1,"Cannot divide by zero")
You can mix these operators in a single formula. Just remember, Excel follows the Order of Operations (PEMDAS) — Parentheses, Exponents, Multiplication/Division, Addition/Subtraction.
=A1+B1*C1
Excel will multiply B1*C1 first, then add A1 to the result. To change the order, use parentheses:
=(A1+B1)*C1
() to make your formulas clear and avoid confusion.Congratulations! You’ve just mastered the basic arithmetic functions in Excel. These four operations—addition, subtraction, multiplication, and division—are the building blocks of every powerful spreadsheet you’ll ever create. Once you get comfortable using them, you’ll find yourself breezing through calculations that used to take minutes in mere seconds.
So, open your Excel sheet right now and try it out. Remember: Excel isn’t scary—it’s just math with a little bit of magic (and a lot of gridlines)!
If you’ve ever looked at a financial report or a sales dashboard and wondered, “How did they visualize this so clearly?”, chances are you saw a Waterfall or a Funnel chart.
These two charts are not just visually appealing — they are powerful tools for explaining change and progress.
In this tutorial, we’ll explore what a secondary axis is, why you need it, and how to add it step by step in Excel. By the end, you’ll be able to compare data with different scales like a pro.
Sparklines are miniature charts that fit neatly inside a single Excel cell. They display trends or variations in a series of data points — such as sales performance, temperature changes, or stock prices — without taking up much space.
