Excel: How to debug your Excel formulas and keep your eyes on certain cells

Excel: How to debug your Excel formulas and keep your eyes on certain cells

 

 

 Video Summary: Once you have mastered Excel functions and you start to use more complex formulas and build more robust spreadsheet, you are likely to run into two issues:  

1. You have mistakes in your formulas but because they are too long and complex you can’t find where the problem is 
2. The result of your formula throws an error for some cells and you’re not sure why. In this video I will give you a tour of the formula audit tools that are available and how they can help you track and debug your formulas. 

You will also find out how you can use the "watch window" to keep you eyes on the value of certain cells while you adjust your input values elsewhere. This feature can come in really handy and avoids you having to jump between different Excel tabs and workbooks.

 

Related Topics:

• Use Ideas in Excel to get Immediate answers with ONE Click 
• How to Create an Excel Interactive Chart with Dynamic Arrays 
• Do's and Don'ts of Excel Spreadsheet Design (with Examples) 
• Excel Conditional Bar Chart with Drop-down and Icons (This Chick's Trouble for Excel Hash)