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. A business owner can take numbers concerning future ...