How has your approach to financial modelling evolved over your career?
Fimodo speaks to four financial modelling experts to get a brief history of their professional development, and how that has changed over time.
...
How are you currently dealing with compatibility issues of Excel 2003 / 2007?
Fimodo speaks to five financial modelling experts to understand how they have (and continue to) deal with compatability issues.
Rickard Warnelid
Corality
www.corality.com The issue of non-compatibility of Excel 2003 / 2007 is not generally a problem internally within financial modelling teams, unless of course dif
...Read entire article
Corality
www.corality.com The issue of non-compatibility of Excel 2003 / 2007 is not generally a problem internally within financial modelling teams, unless of course dif
Using a faded colour scheme in Excel for user interface modelling
I have recently been involved in a project where the end product spreadsheet has been designed to be used to consumers, i.e. a less technical audience than I...
Set up a base template in Excel and re-use your precious Styles!
When you create a new Workbook in Excel you get the standard three worksheets and the standard (useless) Excel Styles. This means that every time you want to...
Can Fimodo change the financial modelling world?
There are a number of financial modelling websites out there, and they all have their respective strengths and weaknesses. Over the last few years I have of...
‘Edit directly in cell’ – Quick Excel Tip
There is a setting in the Options -> Edit -> Setting section called ‘Edit directly in cell. The ‘Edit directly in cell’ related to the way Excel shows f...
Do not use WordArt in your financial model!
In Excel there is a horrible functionality called WordArt. If you didn’t know this already then I apologise for having given you an idea of being able to pres...
Improved financial modelling with conditional formatting
Presenting data in a format that is easy to read in Excel can be a challenge, in particular when you are dealing with larger arrays of data. In this example we w...
How many Excel Worksheets do you prefer?
When building a financial model, for any discipline, you may want to think about if you want to have lots of worksheets with not much in each one or few but rich...
Visually tracing all precedents in Excel without add-ins
There are numerous tools and add-ins in the market constructed to enhance the ability to critically review formulas in Excel. Many of these tools build on t...
Snap to Grid – quick tips for perfect alignment in Excel
Preparing an Excel spreadsheet for distribution to other people requires an additional focus on presentation. This article outlines a very quick trick t...
Optimise image presentation in Excel – 4 hot tips
When working with images in Excel it is important to take control over the various settings to avoid presentation becoming sub-standard over time. A commo...