How to Use Excel to Interpolate. Interpolation is a powerful tool used to determine values that do not appear within a given set of numbers.