EUSPRIG – European Speadsheet Risk Interest Group
EuSpRIG 2010 is presented in Greenwich on July 15-16 and has a impressive line-up of spreadsheet risk experts. Fimodo supports EUSPRIG as it is a great init...
Systems Modelling Ltd – Spreadsheet Review
As part of Fimodo’s setup we welcome specialists in financial modelling and spreadsheets to contribute and share their knowledge and experience. This week Patrick O’Beirne from Systems Modelling Ltd in Wexford presents his views on Peer Reviews of Spreadsheet. Patrick is one of the driving forces behind EUSPRIG’s (European Speadsheet Risk Interest Group) success, and will be p...Read entire article
Are you a financial modelling Expert?
We are looking for more Expert contributors to Fimodo! If you would like to share your views on the topic of financial modelling with a global community then...
What to look for in a Financial Modeller
When you decide your company’s financial models are not as good as they should be, is the first thing you do; send your staff on an Advanced Excel course? Whil...
Which industry sector would benefit the most from improved financial modelling standards?
Fimodo speaks to four financial modelling experts to understand how they see the benefits of financial modelling standards.
...
Including Scenarios in your Financial Model (Video)
This video looks at including scenarios in your financial model, using different methods in Excel. From a simple manual drop down selection, to using R...
Linking Excel to Web Data – The Easy Way to Update Inputs
Excel has some powerful features that allow the user to directly query databases and websites. Whilst the application of such functionality is not going t...
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.
...
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.
...
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...