Functions

Excel COLUMNS function

Aug 18, 2018
64 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

Aug 18, 2018
113 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

Aug 18, 2018
671 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

Aug 18, 2018
172 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

Aug 16, 2018
614 Views
When acquiring a business that operates the majority of its business under long-term contracts, one of the key considerations when …
Functions

Excel MROUND function

Aug 16, 2018
230 Views
The ‘MROUND’ function in Excel rounds a number up or down to the nearest multiple of significance.  For example, if …
Compatibility

Excel FLOOR function

Aug 16, 2018
93 Views
The ‘FLOOR’ function in Excel rounds a number down to the nearest multiple of significance.  For example, if the significance …
Functions

Excel TRIM function

Aug 16, 2018
91 Views
The TRIM function removes excess spacing from text strings, leaving just a singular space in between words and no spaces …