Ever want to see which formulas are being used in an excel documents? Well, now you can.

Scatter plots are used to see the trend of the data set as a whole instead of the sequential pattern of the data.

The IF statement is excel is very useful, but can become a little complicated. The following explanation will explain how to easily and properly use this function.

The following formula easily tranforms a list of data from Upper to Lower case.

This Excel function is very useful when dealing with long lists of data. However, it is extremely easy to use once you know the simple formula.