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.
One Comment
The Offset function from Chandoo.Org is an excellent exercise were it will be benifited for many people to learn this dynamic function online. I request you to please post some of the Excel sample file worked out with examples. I appreciate your valuable time to teach Excel functions online. It is an honour for me to work in Excel, and with this useful examples it will really benifit a lot.
Thank you for your useful work and valuable time.
Regards.
Vishwanath.
3 Trackbacks
[...] The Financial Modeler Leverage the power of Excel Skip to content HomeAboutContact « OFFSET Function Tutorial [...]
[...] Learn Excel OFFSET Function Interactively [...]
[...] the OFFSET series, let’s see a real-life example on how to use the OFFSET function to model [...]