This video will outline a macro-free approach to execute effective consolidation of data, which in this example will sum capital expenditure across three business units for strategic planning purposes.
Dynamic dependent drop-down list – advanced approach with LOOKUP
This approach uses the LOOKUP to produce a dynamic dependent drop-down list, which will cater to dependent lists of various input quantities. The application of a dynamic dependent drop-down list, can be applied in a variety of financial models and spreadsheet situations.
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.
Shuffling data with HLOOKUP
Here is a great and effective approach to shuffle columns of data. It will use the Excel HLOOKUP function, and not require any VBA macros or complicated re-engineering of this summary worksheet.
Converting between the two Excel Date Systems in Financial Modelling
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.
Financial Model Benefits of Excel Custom Format Cells
This is an introductory examination into the use of Excel Custom Format Cells, in order to improve the cosmetic appeal of a best practice financial model.