By Brian Bagenstose
I found this great excel macro/addin that simplifies auditing formulas in Microsoft Excel.
Description: A powerful, intuitive, easy to use, and FREE formula auditing tool. Designed by a professional financial modeller to be used by experts and newbs alike. Once you start using it, you’ll wonder how you ever managed without it. Imagine using the audit arrow feature on a formula and then tracing each precedent or dependent to find out what the value is and then finally returning back to that orgin cell. Imagine if you could automate that process and display all that information instantly in a well organized interactive format. Now that would be a great formula auditing tool! One day I stopped wishing for it and just built it. Now you can have it too.
Download XL-Logic’s EXPLODE macro here
If you liked my post, feel free to subscribe to my rss feeds
BlogoSquare
2 Comments so far (Add 1 more)