This article illustrates how to use the Excel tool, Flash Fill, for the purposes of financial modeling and business planning. Excel Flash will be demonstrated across a number of instances, and highlight how it can be an incredibly powerful and time-saving tool in financial modelling. This is especially so with large data sets.

The What-if or sensitivity analysis tools in Excel are often overlooked by financial modelling professionals. The tools represent immense analytical value during a financial modelling exercise, no matter if it is for corporate valuation, strategic planning or management accounting/reporting purposes.

The idea or concept of added value is different in the eyes of clients, but also in the eyes of financial modelling professionals. Especially in the current economic climate, there is an even bigger need for professionals to demonstrate the added value they provide to clients. One area of value-adding importance is incorporating sensitivity analysis into your best practice financial model.

→ Added Value: fully tailored sensitivity/scenario analyses to measure financial performance

Another value‐added and sophisticated element that Strategize can offer a company is the added sensitivity and scenario functionality with its customised financial modelling solution. This area of a Strategize best practice financial model can assist corporations, to conceptualise how to improve income streams, optimise costs, smooth out the lumpiness of cash flow, and strive for improved profit margins and free cash flow.