Offset and Shift Functions

An Excel file that teaches how to perform Offset and Shift Functions operation.

Excel Spreadsheet for Offset and Shift Functions

The starting cell is taken as a reference. Row and column offsets are determined by parameters. Dynamic ranges are created with this function. Usage is shown in the graph and named ranges. Examples provide flexible reporting.

Hope it is useful.