Category 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 | Tagged , , , , | Leave a comment

Improve Table Visualization using OFFSET and Conditional Formatting

By Sebastien Labonne | Published: November 3, 2009

Strong of our knowledge of the OFFSET function, here's a tip on how to use that function in combination with Conditional Formatting to make a table more legible by reducing clutter.

This tip can be applied on a table where the items of the main field are layed out on multiple lines, just like in the next picture.

Posted in Tips | Tagged , , , , , | 1 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. [...]
Also posted in Model Techniques | 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