Functions

Excel MEDIAN function

22 Views
The MEDIAN function calculates the median number within a specified range. What is the Median? Where there are an odd …
Functions

Excel AVERAGE function

19 Views
The AVERAGE function calculates the average (i.e. sum total divided by number of numbers) value within a specified cell range.  …
Functions

Excel OFFSET function

36 Views
The ‘OFFSET’ function in Excel will return a cell reference that is a given number of rows and columns away …
Functions

Excel COLUMNS function

22 Views
The ‘COLUMNS’ function in Excel will return the number of columns between a specified cell range.  For example, there are …
Functions

Excel COLUMN function

18 Views
The ‘COLUMN’ function in Excel will return the column number of a specified cell. Column A is returned as column …
Functions

Excel CELL function

29 Views
The ‘CELL’ function in Excel returns information about a specified cell. The information returned varies depending on the ‘info_type’ argument …
Functions

Excel HYPERLINK function

20 Views
The ‘HYPERLINK’ function in Excel will create a clickable link (to a website, a separate sheet, external file or to …
Analysis

Contract run-off analysis

70 Views
When acquiring a business that operates the majority of its business under long-term contracts, one of the key considerations when …