Tag Archives: Auditing

Spotting Errors

By Sebastien Labonne | Published: November 17, 2009
In a workbook, I like to be consistent in the use of columns across all worksheets. If the first month of my model is in column L in one worksheet, then it will be the same in all sheets. I have found that this method is really useful in reading formulas because you can promptly [...]
Posted in Tips | Also tagged , , , | Leave a comment

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! | Also tagged , , | Leave a comment

R1C1 Enlightenment

By Sebastien Labonne | Published: September 3, 2009
You might know that Excel has two different reference styles for formulas: A1 (default) R1C1 But why should you care? You might think the default A1 reference style is sufficient for you, but that would leave opportunities only the R1C1 reference style allows. Let’s first see the difference between both reference styles Reference Type A1 [...]
Posted in Excel Options | Also tagged , , , , , | 2 Comments

  • Email updates

    Enter your email address:

  • Share this blog

    Bookmark and Share

  • Recent Posts

  • Recent Comments

  • Meta

  • RSS The Financial Modeler

SEO Powered by Platinum SEO from Techblissonline