Interpolate with Excel | FORECAST function can interpolate | Excel Off The Grid

★ Want to automate Excel? Check out our training academy ★
https://exceloffthegrid.com/academy


★ Download the example file★
https://exceloffthegrid.com/interpola...


★ About this video ★
Interpolation is the process of estimating data points within an existing data set, how can we do this with Excel?

It was the following question which first made me look into this topic:
“I have an Excel question – Is there a way to interpolate a value from a table? I have an X and Y that are not on the table, but have correlated data so want to calculate the interpolated value."

In terms of answering the question, there are several scenarios that would lead to different solutions.
Simple mathematics
FORECAST / FORECAST.LINEAR
Inner linear interpolation

In this video, we'll look at all these scenarios.


★ Resources for more advanced techniques ★

Cell ranges: basic things 99% of users don’t know
https://exceloffthegrid.com/cell-rang...

The real reason INDEX / MATCH is better than VLOOKUP
https://exceloffthegrid.com/real-reas...

INDEX / MATCH / MATCH
https://exceloffthegrid.com/index-mat...


★ Download 30 most useful Excel VBA Macros ebook for FREE ★
https://exceloffthegrid.com/


★ Where to find Excel Off The Grid ★
Blog: https://exceloffthegrid.com
Twitter:   / exceloffthegrid  

#MsExcel #ForecastFunction #Interpolate