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.
Excel supports two date systems, the 1900 and 1904 date system, which can pose potential problems in financial modelling. The 1900 date system is synonymous with Microsoft Excel for Windows, whilst Excel for Mac © (Apple) apply the 1904 date system.
A Precedent Drop-down list, like a dependent drop-down list, is a robust tool to incorporate in a best practice financial model, because it will restrict user inputs based on a previous drop-down list.
The simple SUM function is an adequate tool to aggregate a data array in a financial model. However there are some financial spreadsheets that will require a more robust Excel function, in order to provision for hidden rows, error values, and nested SUBTOTAL and AGGREGATE function cells.
The use of Excel AGGREGATE with SUM as the function syntax, depending on the Option selected, in terms of which values to disregard in the evaluation range for the function, will overcome certain problems with aggregating a data range.