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.
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.
Under Ctrl – Excel Ctrl shortcut keys
Here are some great Excel keyboard shortcuts, which all financial modelling professionals should know about. All of these Excel Ctrl shortcuts can greatly improve the speed, efficiency and accuracy when building or editing financial models.
Excel Traffic Lights
There are many ways to verify or analyse financial outputs. Clearly all financial outputs must be correct, but the financial analyst must be able to deliver added value via summaries, dashboard and Excel charts. This article and video will focus primarily on Excel Traffic Lights, via Excel Conditional Formatting, in order to improve the analytical demonstration of high-level financial performance