This article and video will show you one way to break external links from only selected cells in an Excel workbook. As we can see,…
Form control button jumping around
The use of a customised form control button, commonly referred to as a macro button, can add another dimension to a financial model’s value to a company. This video focuses on the properties of a Form control button, and in particular the common problem of a macro button moving or re-sizing in a financial model.
Why can’t I kill the Excel External Links?
There are many reasons why we need to break source, Excel external links; including the four less obvious sources of external links.
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.
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.