Excel To Do List

Excel To Do ListDownload

This template does not contain macros/VBA code.

To do list with drop down percentage complete and auto-calculating overall progress bar.

Directions:

Add a task name under the “Task” column and a due date under the “Due Date” column. If you leave the value under “Percent Done” as a dash “-” the total progress bar will not calculate it in. Adding a new task must be changed to 0% or higher to be included in the total progress average.

If you remove a task, change “Percent Done” back to a dash “-” to prevent total progress from using it in its calculation.

*If you need to add more than the provided 20 lines, modify cell D3 (the total progress bar). In the original formula “=IFERROR(AVERAGEIF(D4:D23,”<>-“),””)” where it states D23 may need to be increased to the proper cell if Excel fails to do it automatically. In most cases, it should automatically update.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: