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.

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