The drop-down list is a common tool to experienced financial modelling professionals. This alternate approach, a ‘radio button’ drop-down list, does not require Excel VBA macros but instead uses the Data Validation tool.
10 Common Problems with Financial Models
The humble Excel spreadsheet is one the most common software tools used by the business world. Consequently, many financial models are beset by the following problems, which undermine their accuracy and reliability.
How to create dependent drop-down lists
This is a fast approach to add a level of sophistication and reduce input error in your spreadsheet. It is a great technique because it will flex, based on the value chosen in a precedent drop-down list.
Dynamic drop-down list
Here is an effective and simple technique to incorporate a dynamic approach to a drop-down list of inputs. It offers a more effective approach than creating a dynamic name range.
Financial Modelling New Year’s Resolutions
The advent of a new year is a great opportunity to put in place some aims and goals. Financial modelling should be no different. Here are some things, which you might want to focus on for your New Year’s Resolutions as a financial modeller.
Financial Spreadsheet Risk
Reliance on erroneous spreadsheets by corporations for inaccurate financial reporting and business decision making has been reported in the financial media, because it has often resulted in profit downgrades, share price falls and a revision of corporate financial statements.