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

EUSPRIG – European Speadsheet Risk Interest Group

Tuesday, July 6th   1 Comment

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...

Read entire article

Are you a financial modelling Expert?

Thursday, May 6th   1 Comment

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...

Read entire article

What to look for in a Financial Modeller

Saturday, May 1st   7 Comments

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...

Read entire article

Which industry sector would benefit the most from improved financial modelling standards?

Tuesday, April 6th   9 Comments

Fimodo speaks to four financial modelling experts to understand how they see the benefits of financial modelling standards.
...

Read entire article

Including Scenarios in your Financial Model (Video)

Tuesday, February 2nd   15 Comments

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...

Read entire article

Linking Excel to Web Data – The Easy Way to Update Inputs

Tuesday, February 2nd   2 Comments

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...

Read entire article

How are you currently dealing with compatibility issues of Excel 2003 / 2007?

Wednesday, January 20th   6 Comments

Fimodo speaks to five financial modelling experts to understand how they have (and continue to) deal with compatability issues.
...

Read entire article

How has your approach to financial modelling evolved over your career?

Tuesday, November 24th   1 Comment

Fimodo speaks to four financial modelling experts to get a brief history of their professional development, and how that has changed over time.
...

Read entire article

Using a faded colour scheme in Excel for user interface modelling

Monday, November 16th   No Comments (yet)

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...

Read entire article

Set up a base template in Excel and re-use your precious Styles!

Wednesday, September 30th   15 Comments

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...

Read entire article

Can Fimodo change the financial modelling world?

Tuesday, August 25th   2 Comments

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...

Read entire article

‘Edit directly in cell’ – Quick Excel Tip

Tuesday, August 25th   4 Comments

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...

Read entire article

Do not use WordArt in your financial model!

Thursday, July 16th   4 Comments

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...

Read entire article

Improved financial modelling with conditional formatting

Monday, July 13th   No Comments (yet)

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...

Read entire article

How many Excel Worksheets do you prefer?

Friday, July 10th   4 Comments

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...

Read entire article

Visually tracing all precedents in Excel without add-ins

Sunday, July 5th   7 Comments

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...

Read entire article

Snap to Grid – quick tips for perfect alignment in Excel

Saturday, June 27th   1 Comment

Preparing an Excel spreadsheet for distribution to other people requires an additional focus on presentation. This article outlines a very quick trick t...

Read entire article

Optimise image presentation in Excel – 4 hot tips

Wednesday, June 10th   No Comments (yet)

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...

Read entire article