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.

To extract and sort non-adjacent arrays in your data, nest the CHOOSECOLS or CHOOSEROWS functions inside your SORT or SORTBY ...

Using three Microsoft Excel functions, you can easily parse time components from a full date value.

This formulaic conditional formatting Excel rule will let viewers determine how many top values to view on the fly.