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.

Calculate the difference between dates

You have a start date and and end date and want to know how many days are in between team. Or want to know how many works days or months or even years are between these dates. Trying doing this by hand or even with a calculator and you'll go crazy. Try doing this will Excel and you'll be done in less time it takes to get a cup of coffee. Check out the video to see how to do the calculate the difference between dates with various date functions.