How to Create an Adjustable Forecast with the Excel OFFSET Function

This tutorial covers how to use Microsoft Excel and the OFFSET Function to create flexible and adjustable forecasts. When it comes to project cost management, a flexible forecast is KEY. Using this specific approach in Microsoft Excel, it's easy to build a range of scenarios and predict outcomes.
- -
TUTORIAL CHAPTERS:
00:00 Introduction to creating an adjustable forecast
00:22 Defining variables
01:53 Creating scenarios
04:25 Creating projections
05:05 HLOOKUP
07:38 Using the OFFSET Function
14:28 Creating a helper scenario
17:34 Calculating revenue
18:00 Calculating cost of sales
18:31 Calculating gross profit
18:46 Calculating cash impact
19:15 Conclusion
- -
You can read the entire tutorial, step-by-step, here: https://bsha.re/3xl16QQ

And if you found this video helpful, don't forget to:

🎉 Comment, like, & subscribe!
🎉 Check out our playlist filled with more how to's and spreadsheet tips:    • Tutorials: Spreadsheet Tips  
🎉 Have a look at the other tutorials on our blog: https://bsha.re/4eAtXkF