Excel Tips III - Formulas
Microsoft Excel has so many features and it can do so much, that sometimes it’s hard to know where to start.
This list of Excel tips will give you straightforward answers on how to create and use formulas in Excel. Examples are included to make understanding the steps involved even easier to follow. The list keeps growing so check back often to see what new Excel tips have been added.
Also Read:
Excel Formula Tips
Show Formulas in Excel
Show formulas makes it possible to look at all of the formulas and functions in your spreadsheet. With a quick key combination from the keyboard, you can:
- check to see which cells contain formulas
- read through all formulas to check for errors
- print the spreadsheet while showing all formulas
Using Cell References in Excel Formulas
Cell references describe the location of a cell in an Excel spreadsheet. Using cell references in formulas has several advantages including:
- Using pointing when creating the formula
- Allows you to reuse formulas by copying them to other cells
- Copied formulas automatically update cell references for their new location
- If the data used in the formula changes, the formula automatically updates the answer
"What if" Questions and Excel Formulas
Excel formulas can easily be used to answer "What if" - type questions. "What if" questions involve changing the data used in Excel formulas to give different answers. This article covers:
- How to setup "What if" questions
- The importance of using cell references in formulas
- A step by step example of how to use "What if" questions
Excel Math: How to Add Numbers
This tutorial covers:- how to add numbers using a formula
- an example of addition in Excel
- how cell references will make it easy to update your calculations if your data should ever change
Excel Math: How to Subtract Numbers
This tutorial covers:- how to subtract numbers using a formula
- an example of subtraction in Excel
- how cell references will make it easy to update your calculations if your data should ever change
Excel Math: How to Multiply Numbers
This tutorial covers:- how to multiply numbers using a formula
- an example of multiplication in Excel
- how cell references will make it easy to update your calculations if your data should ever change
Excel Math: How to Divide Numbers
This tutorial covers:- how to divide numbers using a formula
- an example of division in Excel
- how cell references will make it easy to update your calculations if your data should ever change
