Recently Liam Bastick (Excel MVP) wrote an article about using the OFFSET function to calculate depreciation in financial models. You can check out the full article here.
When plotting Actuals and Forecasts on a single line chart you may want to use a vertical dotted line to identify where the Actuals finish and the Forecasts begin.
Import PDF Update
The Power Query engine keeps getting better.
Hopefully soon it will handle PDF documents.
If you want to watch the presentation mentioned above here is the link.
There is an easy technique to copy a single formula and paste it without affecting relative references but what if you wanted to paste lots of formulas?