Tag Archives: Excel

05Oct/11

How can I make my Excel formulas more readable?

Microsoft Excel is a powerful tool.  You can use it to track your personal budget, create a shopping list, or build a corporate cash-flow statement.  Sometimes, troubleshooting an Excel file can be difficult, though.  As you can see in examples below, the variables in an equation are represented by grid coordinates consisting of letters and numbers.  This means that you must look at the coordinates and try to figure out what the variable actually represents.  There is a better way.  If you right-click on a cell and click “Define Name”, you can rename the cell.  This means that instead of the cell being named “D2” it can be named “Hourly Wage”.  This will allow you to develop much more “human readable” Excel formulas.

Example of a simple budget calculator

Step 1

Step 2

Step 3

Step 4

 

 

 

 

20Sep/11

How do you show the formulas in Excel?

This is a quick tip.  Lets say you are working on developing an equation within a cell in Excel and you find yourself wanting to refer back to how you set up another cell.  You can click on the other cell and see the equation but how do you show the value of the cell while it is not selected?  Just hit Ctrl + ` on your keyboard.  To toggle it off, just hit the combination again.  It is as easy as that.