Launch Excel and open a worksheet you wish to extract interpolated data from. If you are building a worksheet, then create the columns with values that will correspond to an x-axis and a y-axis.

In Excel, simple linear interpolation is the most commonly used method. It can be done in four simple steps, as follows: 1. Identify the target cell where the interpolated value should be placed. 2.

As a result, you can use both to interpolate data in Excel. To better understand TREND, let’s go through an example. Suppose you have eight known Y values (1 to 8) and corresponding X values ...

All that’s left to do is to save the modified data to Microsoft Excel, as follows: 5. Click the Home tab. 6. In the Close group, click Close and Load from the Close & Load dropdown.