Functions

## Excel FORMULATEXT Function

199 Views
The ‘FORMULATEXT’ function in Excel will return the formula being used in any given cell in text format. Note that …
Functions

## Excel LEN Function

217 Views
The ‘LEN’ function in Excel will return the length (i.e. number of characters) of a given text/numerical string. Whilst the …
Analysis

## Last Twelve Months (‘LTM’) Analysis

1520 Views
When comparing financial results for financial years, the last twelve months (‘LTM’) performance is commonly also shown as a reference …
Functions

## Excel ISEVEN Function

148 Views
The ‘ISEVEN’ formula in Excel is used to ascertain whether or not a value is even. It returns TRUE if …
Compatibility

## Excel RANK Function

148 Views
The ‘RANK’ formula in Excel is used to rank numerical values within a list. This formula ranks an input number …
Formulas

## How to add equivalent cells across tabs in Excel

294 Views
This particular technique allows you to add equivalent cells across different tabs within Excel. In our example, we use a …
Date and time

## Excel DATE Function

827 Views
The ‘DATE’ function in Excel will return a date using individual day, month and year inputs. This function is most …
Analysis

## Compound Annual Growth Rate (‘CAGR’)

6023 Views
Compound annual growth rate (‘CAGR’) is a measure of growth over multiple periods of time.  CAGR can be a useful …