You can do a lot more in Excel than just add up numbers.
Excel is designed to help you create formulas to perform a variety of different calculations and tasks. But formulas can be intimidating. You probably already know how to auto sum numbers and handle basic calculations.
But there’s more to formulas than just the basics. Here’s what you can do with them.
- You can multiply, subtract, divide, and average numbers.
- You can see the minimum and maximum numbers in a column or row.
- You can include different types of calculations in a single formula.
- You can also use absolute cell references in your formulas to keep certain numbers constant.
Let’s look at how to work with formulas in Excel.
I’m using Excel 2016 as my test subject, but the steps I describe here apply equally to the previous few versions of the program.