Excel Tips

## How to Use Relative and Absolute Referencing in Excel

176 Views
When you reference a singular cell or cell range in Excel (e.g. =sum(A1) or =sum(A1:B1)), you call upon the contents …
Functions

## Excel ROWS function

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

## Excel ROW function

125 Views
The ‘ROW’ function in Excel will return the row number of a specified cell. Note: if you wish to know …
Functions

## Excel MIN function

66 Views
The MIN function calculates the smallest value within a specified range of cells.  Only numerical values are accepted, given that …
Functions

## Excel MAX function

109 Views
The MAX function calculates the largest value within a specified cell range.  Only numerical values are taken into account.  An …
Functions

## Excel MEDIAN function

96 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

210 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

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