Using a dashboard in excel can be a very helpful way to tell at a glance what you have to do, what you have done and out of how many. In this video you will learn how to use the #COUNT and #COUNTIF formulas to create an automated dashboard.