An Excel Graph is a great way to communicate a company’s financial performance to stakeholders. A conventional Excel graph has a hard time updating for source data changes; unlike other Excel functions such as formulas or cell formats that update seamlessly. The introduction of dynamic data ranges in an Excel Graph will solve this problem.
DCF Sensitivity Analysis using Excel Data Table
The Excel Data Table “What-if Analysis” tool is one of the most powerful, yet underutilised functions in Excel. It is a great way to deliver a high-level, informative what if analysis of a company’s financial position such as its Net Present Value (NPV) from a Discounted Cash Flow (DCF) schedule.
How to create a dynamic drop-down list from a horizontal range
This is a follow-up to “How to create a dynamic drop-down list in your financial model”, but this article focuses on creating a dynamic drop-down list from a horizontal range or data array. A dynamic drop-down list can equally update and expand seamlessly, whenever additional items are added to a horizontal array of data.
How to create a Waterfall Chart in Excel
This article shows how to create a simple Waterfall Chart in Excel. It will apply the bar or column chart template with “Stacked Column” properties, which will produce an aesthetically pleasing graph of financial performance; based on a specified key performance indicator (KPI) over a selected time period i.e. EBITDA.
How to use Excel Data Validation to protect cells
Excel’s Data Validation is one of the more underutilised and understated features in Microsoft’s spreadsheet application.
Quite simply it is a great, VBA macro-free tool, in which to improve the internal controls and corporate governance surrounding the management of a financial model.
How to create a dynamic drop-down list in your financial model
A dynamic drop-down list is a great way to force spreadsheet users, to select a specific array of inputs for a cell in a financial model. This dynamic approach combines the Defined Name function, OFFSET and COUNTA functions to provide a drop-down list, which flexes whenever there are additions or deletions to the data array of inputs.