Uploaded November 2025 | Updated November 2026, 3 days ago
Build a clean assignment or task tracker in Excel with automatic schedule view.
⬇️ Download the free template and follow along: bit.ly/tracker25file
👩🏫 Join my Excel Expert course: bit.ly/tracker25course
🎬 MORE FREE EXCEL TEMPLATES, full playlist here: bit.ly/templates26playlist
In this video, we’ll build a clean Assignment or Task Tracker in Excel with drop-downs for Subject and Type, automatic Days Available, colour-coded Status and highlighted overdue tasks.
You’ll be able to filter by subject to see what’s due next, focus on specific work types and status.
Plus, there’s an automatic schedule for a quick calendar style overview, all without any macros.
You can grab the completed file from the link, but first I’ll explain how to build it yourself so you can customize it to your needs.
LEARN MORE
===========
📰 EXCEL NEWSLETTER - join 450K+ subscribers here: myonlinetraininghub.com/excel-newsletter-sign-up
🎯 FOLLOW me on LinkedIn: linkedin.com/in/myndatreacy
💬 EXCEL QUESTIONS: Get help on our Excel Forum: myonlinetraininghub.com/excel-forum
#Excel #TaskTracker #ExcelTemplate
Build a clean assignment or task tracker in Excel with automatic schedule view.
⬇️ Download the free template and follow along: bit.ly/tracker25file
👩🏫 Join my Excel Expert course: bit.ly/tracker25course
🎬 MORE FREE EXCEL TEMPLATES, full playlist here: bit.ly/templates26playlist
In this video, we’ll build a clean Assignment or Task Tracker in Excel with drop-downs for Subject and Type, automatic Days Available, colour-coded Status and highlighted overdue tasks.
You’ll be able to filter by subject to see what’s due next, focus on specific work types and status.
Plus, there’s an automatic schedule for a quick calendar style overview, all without any macros.
You can grab the completed file from the link, but first I’ll explain how to build it yourself so you can customize it to your needs.
LEARN MORE
===========
📰 EXCEL NEWSLETTER - join 450K+ subscribers here: myonlinetraininghub.com/excel-newsletter-sign-up
🎯 FOLLOW me on LinkedIn: linkedin.com/in/myndatreacy
💬 EXCEL QUESTIONS: Get help on our Excel Forum: myonlinetraininghub.com/excel-forum
#Excel #TaskTracker #ExcelTemplate










