Everyone loves lists, so here’s one of my own — the top 7 things not to do when designing and building a financial model. Nothing controversial in this I hear you say? Fear not — this list will ruffle a few feathers. A few of these are on others’ best practice lists. Read the rest of this entry »
Top 7 Sins of Model Design
April 9, 2010
1 Comment | 
Financial Modelling | Tagged: Spreadsheets, Excel, Formatting, Styles, Design, Errors, named ranges, multiple worksheets, VBA/macros | 
Permalink
Posted by Darren Miller
Styles are more fashionable
May 11, 2009One of the most powerful and most easily understood (but least used) features in Excel is Styles.
Styles allow you to define a cell format (things like number format, shading, borders, etc), give this format a meaningful name (such “input”) and then apply this format to cells in your workbook. ”Ok ” — you say — ”But I can just as easily format cells individually on the fly, and I can even copy a cell’s format and paste this to other cells”. Yes, you can, but here’s why doing it like this is problematic: Read the rest of this entry »
Leave a Comment » | Financial Modelling | Tagged: Excel, Formatting, Spreadsheets, Styles | Permalink
Posted by Darren Miller
