★ Want to automate Excel? Check out our training academy ★
[ Ссылка ]


★ Download the example file★
[ Ссылка ]


★ 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
- [ Ссылка ]

The real reason INDEX / MATCH is better than VLOOKUP
- [ Ссылка ]

INDEX / MATCH / MATCH
- [ Ссылка ]


★ Download 30 most useful Excel VBA Macros ebook for FREE ★
[ Ссылка ]


★ Where to find Excel Off The Grid ★
Blog: [ Ссылка ]
Twitter: [ Ссылка ]

#MsExcel #ForecastFunction #Interpolate

свернуть