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.

Use a Dropdown to Switch between Charts

If you've got a table to show different views of a data series, you might want to show it one at a time. For example you may want to compare the sales, costs and profits of different items, but not all at the same time. Instead of creating three separate charts, you have a drop down for selection and it will show the respective view of your data. See the video to learn how to use a drop down combo box form control to switch between different charts in your worksheet.