OFFSET Function Tutorial

OFFSET is a useful function that adds lots of flexibility to your Excel models.

Using it can help you transform what would have been formula modifications into simple inputs changes. A common example is to use it to automatically compute monthly figures into year-to-date results by changing one input instead of changing formulas each month.

Download the OFFSET tutorial.xls file, to learn how to use this function.

The file includes:

• A quick reference table that describes each function parameters
• An interactive tool to visualize how changing the parameters affects the results (screenshot below)
• An applied example to compute year-to-date results

The interactive OFFSET tutorial tool in action

Click on the link to download the file: OFFSET tutorial.xls

Feel free to share it!

UPDATE: I have updated the file to correct the conditional formatting rules when negative width or height inputs are used in the OFFSET tutorial tool.