The Excel Conditional Cell Formatting tool is a powerful, yet often underutilised tool in financial modelling. The following blog and two videos will outline its value in a financial model.
Why can’t I kill the Excel External Links?
There are many reasons why we need to break source, Excel external links; including the four less obvious sources of external links.
Data Group in Excel – Strategic Planning
The Data Group tool in Excel is an important feature to implement in a best practice strategic plan. It is a safer, more intuitive alternative to hiding rows or columns, which will often be overlooked by other model users. For the purposes of strategic planning or financial planning & analysis (FP&A), the Data Group function in Excel will enhance the financial model in a number of ways.
Advanced Waterfall Chart – Dealing with Negatives
This article addresses the needs of an advanced Waterfall Chart, which must chart both positive and negative financial KPIs. The flexibility of Excel and the added complexity required, in order to chart negative numbers in a Waterfall Chart, means there are a variety of ways to chart both positive and negative values.
How to create a dynamic Waterfall Chart
This follow-up article to “How to create a Waterfall Chart in Excel”, adds a dynamic drop-down list to enable users to change the source time series period of the Waterfall Chart. A dynamic Waterfall Chart delivers flexibility, which a static Waterfall Chart is unable to offer the users of a financial model.
How to create ordinal numbers using Conditional Formatting in Excel
Here is a great approach to create ordinal numbers, which is dynamic and VBA macro-free. It applies Excel conditional formatting to the required data array. The ordinal number formatting will preserve the integer properties of the relevant data array, and will require a number of rules to be created.