iTechGuides is reader-supported. When you buy through links on our site, we may earn an affiliate commission. As an Amazon Associate I earn from qualifying purchases. Learn more
Yes—you can turn a basic Excel list into a small task dashboard that counts completed and pending items and shows progress. The setup uses an Excel table, in-cell checkboxes, and formulas. How-To Geek author Tony Phillips estimated the build at 10 minutes; your time may vary with your Excel version and familiarity.
What this Excel task tracker includes
The tracker has a task-name column and a checkbox status column, plus a compact dashboard for total, completed, pending, and percentage-complete figures. It is designed for a straightforward checklist, not a full task-management system: it does not include due dates, reminders, owners, recurring tasks, or categories.
Tony Phillips framed the appeal this way: “Lots of task-tracking software is costly and comes with more features than you need.” That is the author’s rationale, not a general comparison of software prices or features.
Free tools Windows power users keep installed
One-click scans. No signup required.
Check whether your Excel version supports in-cell checkboxes
Microsoft’s checkbox guidance lists Excel for Microsoft 365 and Excel for Microsoft 365 for Mac. Check the Insert options in your own app before following the checkbox steps; availability can depend on edition and rollout.
#1 Best Overall
- TASK PLANNER NOTEPAD FOR WORK – Structured task planner and productivity planner designed as a task organizer and workflow planner with expanded layout
- REDUCE OVERWHELM & IMPROVE EXECUTION – Use this task planner, productivity planner, and task tracker to organize workflow and improve execution
- TASK PLANNING + ACTIVITY TRACKING IN ONE FORMAT – Use as a productivity planner, task organizer, and workflow planner to manage tasks and execution
- ANALOG TASK & ACTIVITY SYSTEM THAT WORKS – Writing tasks improves memory and reduces missed steps
- STRUCTURED CHECKLIST + LOG FORMAT – Combines task planning and activity tracking with expanded space for detailed workflow management
Checkboxes work with ordinary logical values: Microsoft says a checked checkbox has the value TRUE and an unchecked one has the value FALSE. That lets the dashboard count status values directly.
Create the task table
- Open a blank worksheet. Enter Task Name in D4 and Status in E4.
- Enter one task per row beneath the headers, leaving the Status cells ready for checkboxes.
- Select the header and task range, then use Excel’s Insert Table command. Confirm that the table has headers.
- With a cell in the table selected, open the Table Design tab and set the table name to
T_Tasks. - Select the Status cells and use Insert > Checkbox, if that command is available in your Excel edition.
The structured references used below rely on the table name and column headers matching those exact names. Microsoft explains that table structured references adjust as table data is added or removed in its guide to structured references.
Rank #2
- Ultimate To Do List with Multiple Sections: A to do list lover’s dream, our notepad offers multiple sections with ample space to write all your important tasks so you can organize and track your tasks better than with a regular list. Sheets have separate spaces for each day, as well as sections for a to do list and top priorities, making it easy to prioritize and stay organized. Say goodbye to feeling overwhelmed and hello to a more organized and productive you!
- Minimalist Design to Boost Productivity: Experience the perfect balance of minimalist and functional design with our weekly to-do list notepad. Each notepad measures 8.5” x 11” and has 52 sheets, so there is enough space to write down everything you need to do. Made with a minimalist black and white design and premium materials, our notepad is the perfect tool to keep you on track and motivated throughout the day!
- Premium, non-bleed pages: No more frustrations about pens or markers bleeding through flimsy paper! Our notepad is made with premium non-bleed 100 gsm paper to give you the best writing experience. Unlike with our competitors, these pages won’t bleed onto the next one, even if you write with a permanent marker.
- Sturdy Backing for Writing Anywhere: Our notepad is made with a thick backing that provides a sturdy surface for writing anytime, so you can take it on the go and never miss an important task again. Whether you're at home, in the office, or on the go, you'll always be able to capture your thoughts and stay on top of your daily routine.
- Easy to Tear Off Pages: The easy to tear off, undated pages make it simple to share your lists with others or start each day with a fresh page. You'll love the convenience of being able to remove yesterday's tasks and start with a clean slate, allowing you to focus on what really matters.
Build the dashboard counts and progress
Place dashboard labels and formulas in unused cells outside the table. These formulas assume the table is named T_Tasks and its headers are Task Name and Status.
Quick wins for a faster PC:
Scan for outdated or missing drivers - takes under a minuteDriver Scan →Clear out junk files and repair common Windows errorsFree Scan →Fix the driver behind crashes, sound loss and screen glitchesFind Drivers →- Total tasks:
=ROWS(T_Tasks) - Completed:
=COUNTIFS(T_Tasks[Status],TRUE) - Pending:
=COUNTIFS(T_Tasks[Status],FALSE) - Progress: divide completed tasks by total tasks, for example
=IFERROR(COUNTIFS(T_Tasks[Status],TRUE)/ROWS(T_Tasks),0)
Format the progress cell as a percentage. The IFERROR wrapper makes the display return 0 if the table has no rows instead of showing a divide-by-zero error. If you use a different table name or header text, update the structured references to match.
Rank #3
- ✅ SCIENTIFICALLY STRUCTURED FOR ADHD - Designed specifically to combat ADHD-related challenges, our "ADHD Task Hub" uses color-coded sections and categorized tasks (calls, emails, appointments, to-dos) to reduce overwhelm, enhance focus, and improve daily productivity.
- ✅ BOOST MOTIVATION & CLARITY - Features dedicated sections for "Today's Wins" to celebrate achievements, "Random Thoughts" to capture creative ideas and reduce anxiety, ensuring you stay motivated and organized throughout your day.
- ✅PREMIUM QUALITY & DURABILITY - This A5 (5.9 x 8.5 inch) planner boasts a sturdy plastic cover for protection, 100gsm thick paper to prevent bleed-through, and a durable spiral binding, ensuring it withstands daily use.
- ✅ COMPREHENSIVE TASK MANAGEMENT - With 102 undated ADHD task templates, this planner provides ample space to manage all aspects of your life, from daily tasks and appointments to research goals and follow-ups, making organization effortless.
- ✅ REDUCE ANXIETY & THRIVE DAILY - By providing a clear, visual roadmap for your day, this planner helps you prioritize effectively, minimize mental clutter, and transform your daily routine into a streamlined, stress-free experience, helping you "Stay Organized, Thrive Daily."
Add visual feedback
Mark completed task names
Select the task-name cells and create a conditional formatting rule based on the corresponding Status cell being TRUE. Set the format to gray text with strikethrough, so a checked task is visually distinct without removing it from the list.
Show progress with a data bar
Apply conditional formatting with a data bar to the progress cell. Set its scale from 0 to 1 so the bar represents the full percentage range.
Hide worksheet gridlines
On the View tab, clear the Gridlines option to give the worksheet a cleaner dashboard appearance.
Choose whether completed tasks stay in the list
Leaving completed rows in the table keeps them in the total and progress calculation. Deleting completed rows removes them from both: the total and completion percentage then describe only tasks still in the table, not the full history of work completed. Keep completed rows if you want the dashboard to retain that record.
Best Value
- BOOST YOUR PRODUCTIVITY - This undated weekly productivity planner notepad focus on the important work and get organized. Weekly to do list notepad allowing you to categorize and prioritize your tasks effectively. Whether you're a small business owner, project manager, freelancer, academicians or master multitasker, the weekly to do list pad will be your new favorite daily office productivity tool.
- UNDATED WEEKLY PLANNER - This weekly planner start any time with 54 weeks, Weekly planner notebook has plenty of space to write your goal plan, work plan, student plan or personal schedule, keep track of priorities, and write notes on the back. This versatile planner allows you to stay organized in 2026, 2027, or even as far ahead as 2028!
- FEATURES - Weekly Theme and Highlights for at-a-glance planning Top 3 Priorities for the week 6 Focus Areas to segment and list tasks for goals, projects, or clients Daily Tracker for healthy habit-tracking and routine-tracking.
- HIGH QUALITY - This weekly desk planner size of 8.5" x 11", it offers ample space for writing and planning your tasks, just the perfectly size to fit in your backpack. Is used to high quality 100gsm pure white paper, elastic band and a back pocket for extra space.
- FUNDTIONAL DESIGN - This weekly deskpad planner will completely change how you structure your work: by segmenting your tasks by area and tracking the most important details, you'll feel less scattered and more organized.We believe in helping you be fulfilled with your life and productive at the same time by using a weekly to do list notepad.
Check the tracker as you use it
Add a task row and toggle a checkbox. The table-based references are intended to follow changes to table rows, while the TRUE/FALSE status values feed the counts and progress calculation. If the results do not update as expected, verify that the table is named T_Tasks, the headers are spelled Task Name and Status, and each checkbox is in the table’s Status column.
Quick Recap
Product prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on Amazon at the time of purchase will apply.
