It can sometimes be difficult to make sense of complex Excel formulas, especially if you’re not familiar with the functions being used.
One great way to see what’s happening is to evaluate a portion of the formula at a time to determine why Excel is giving you the results that it is. To do this make […]

continue reading.....

If you’re trying to figure out where your complicated Excel model might be going off-track, or perhaps you’ve inherited someone else’s work and you just want to see the formulas used at a glance, use the Formula Auditing mode to help review the sheet.
Pressing Ctrl-` will toggle between displaying formulas and values in the sheet […]

continue reading.....

Excel’s conditional formatting is much more useful than it initially seems to be. You don’t need to base the formatting you set upon the value of the cell you’re formatting; you can format one cell based on the value of a different cell.
In fact, you can base the formatting on formulas and not just on […]

continue reading.....