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.

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." ...

If you want to count the frequency of a text in Excel, you can use the Countif function. This article explains the step-by-step procedure.

Don’t worry about which form to use. Excel selects the correct one based on which function_num you chose. Also, don’t worry about trying to remember all the options; Excel will provide drop-down lists ...