Strong of our knowledge of the OFFSET function, here's a tip on how to use that function in combination with Conditional Formatting to make a table more legible by reducing clutter.
This tip can be applied on a table where the items of the main field are layed out on multiple lines, just like in the next picture.
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 [download id="4"] file, to learn how to use this function.
The Financial Modeler
How to Model Depreciation
Completing the OFFSET series, let’s see a real-life example on how to use the OFFSET function to model depreciation.
Basically, the depreciation model needs the following inputs:
With those inputs we’ll be able to calculate: