Original Task Tracker for Excel- Full Overview and Tutorial
Let's build the Excel version of the original task tracker that started it all. If you can't use VBA at work, this non-automated version is perfect for you to get organized at work. If you have the ability to use VBA at work, check out my continuous flow task tracker as well.
What we'll learn:
Add Drop-downs
Create an automatic counter
Add a completed task counter
Add conditional formatting
Formulas Covered:
Data Validation
CountA
Sequence
CountIF
Conditional Formatting