Create an Excel task list – with progress & deadline countdown ✅📊
👩💻 Welcome to my Excel tutorial!
In this video, I'll show you how to create a smart task list in Excel – with automatic progress, deadline countdown, and clear status indicators.
Perfect for projects, to-dos, or your personal task management – all directly in Excel.
✅ Ideal for:
– To-do lists with status & progress
– Task overviews for your team
– Tasks with deadlines and priorities
⏰ Timestamps:
0:00 – Introduction
0:40 – Basic structure of the task list
1:40 – Dropdown and traffic light for priority
3:55 – Dynamic dropdown for responsibilities
7:30 – Countdown to deadline with conditional formatting
10:28 – Status & icons
13:21 – Automatic progress bar
16:58 – Automatically cross out completed tasks
18:41 – Final formatting
19:21 – End
📌 Did the video help you?
Then give me a thumbs up 👍
and subscribe to my channel for more Excel hacks and tutorials!
🧠 Question for you:
What other features would you use in your Excel task list? Let me know in the comments!
✅ Find out more on my website:
https://www.cemiscode.com
📥 Free templates:
Discover practical Excel templates for your everyday work:
https://www.cemiscode.com/
📘 Excel beginner's course:
Would you like to learn Excel from scratch or refresh your basic knowledge?
Then check out my Excel beginner's course – step by step to confidently handling tables and functions:
https://www.cemiscode.com/excel-kurs