For example, if you want to show a frequency distribution for every 10 units you would need to define that for Excel. The Frequency function refers to this limit as the "Bin Array." ...

Excel has over 475 formulas in its Functions Library, but we've selected the most popular, from date and time functions to mathematics and simple data manipulation.

From lookup functions to multi-part formulas, I wish I knew about these Excel formulas earlier because they make me feel like a data wizard whenever I use them.