Create a Frequency Table and Chart

If you're doing basic statistical analysis you're probably going to come across frequency table or chart. You're basically taking a group of data and putting them into some buckets and comparing them. Excel makes this quite easy with the COUNTIF function and using PivotTables. Check out the video to learn how.

How to Rank Items Using Excel RANK Functions

This video shows you how to rank a list of values. It show three different functions to do this: RANK, RANK.AVG and RANK.EQ. There's also some extra on how to use the VLOOKUP and create a dropdown to save extra space.

Use the COUNT (COUNT, COUNTA, COUNTBLANK, COUNTIF, COUNTIFS) functions

Are you interesting in learning how Excel counts? IF you are, you've come to the right place! There are numerous ways that Excel can count stuff like numbers or text. This video covers the group of count functions (COUNT, COUNTA, COUNTBLANK, COUNTIF, COUNTIFS) that Excel provides.