Category Archives: Improve Your Model Now!

Improve your model now! #REF Editions

By Sebastien Labonne | Published: September 21, 2009

Are you looking to: Quickly find the sources of all your #REF errors found in some cells? Audit your model for potential undetected problems? Simply use Excel’s Find functionality to find all of the #REF errors. Press CTRL-F to launch the “Find” dialog Type #REF in the “Find what:” section Click the “Options” button to [...]

Posted in Improve Your Model Now! | Tagged Auditing, Errors, Find, Tips | Leave a comment

Search
Auditing Best Practices Conditional Format Controls Data Tables Data Validation Depreciation Error Handling Errors Excel Function Excel Functionality Find Find & Replace Format Formula Go to Input Model Model Structure OFFSET Options Pivot Tables R1C1 RAND Reference Style Scenario Sensitivity Settings Shortcuts Tables Technique Tips Trigger Tutorial Visualization
WP Cumulus Flash tag cloud by Roy Tanck and Luke Morton requires Flash Player 9 or better.
RSS updates
- All posts
- All comments
Email updates

Enter your email address:
Share this blog
Recent Posts
Recent Comments
- wp framework on Using Data Validation – The Trigger Technique
- Vishwanath.N on OFFSET Function Tutorial
- Chris on Back to School – The Excel Model
- Pia on Discovering Sensitivity Tables
- Dr. Peter AIDS Foundation on How to Model Depreciation
Blogroll
Links
- ModelCom
Meta
The Financial Modeler

Category Archives: Improve Your Model Now!

Improve your model now! #REF Editions

Search

RSS updates

Email updates

Share this blog

Recent Posts

Recent Comments

Blogroll

Links

Meta

The Financial Modeler