Tag Archives: Tips

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 see [...]
Posted in Tips | Also tagged , , , | Leave a comment

Getting More From Your Pivot Tables

By Sebastien Labonne | Published: October 19, 2009

Getting More From Your Pivot Tables - PictureIn A Few More PivotTable Improvements in Excel 2010, Diego Oppenheimer, Program Manager on the Excel team at Microsoft, discusses new pivot table features being implemented for the next release of Excel.

One of the improvement mentioned is the ability to repeat down labels to facilitate using formulas with the pivot table as a source. If you don't want to wait for the next Excel version, here's a trick to get to the same result.

Posted in Getting More From... | 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 expand the dialog, if it’s not [...]
Posted in Improve Your Model Now! | Also tagged , , | Leave a comment

Quick tip: Make your formulas legible

By Sebastien Labonne | Published: August 25, 2009
Embedded Excel functions is certainly a great feature, but it often makes formulas really long and hard to read. You can easily make your formulas more legible by simply pressing ALT-ENTER while editing it to force a line feed. See for yourself the result of doing so. Note that you need to put the line feed (ALT-ENTER) [...]
Posted in Quick tips | Also tagged | Leave a comment

Seven tips to develop a structured model

By Sebastien Labonne | Published: July 3, 2009
Create A Modular Design For Your Model Don’t put everything on a single worksheet. Separate your model’s components on multiple worksheets, i.e. Revenues, COGS, Other Costs, Financing, Amortization etc… Keep Your Sheet Names As Short As Possible It will help keep formulas legible and you’ll see more sheet tabs at once which will help browse within the workbook. [...]
Posted in Model Techniques, Tips | Also tagged , , | 1 Comment

  • 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