Create a Speedometer Chart

If you like cars and Excel, you might like this video. The speedometer analogy on business dashboards is often used or mis-used. You've got a spectrum where data resides and it gets separated by good, average, and poor areas. If you like the visual appeal of a car dashboard chart on your worksheet see this video to learn how to create a speedometer chart in Excel.

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.