{"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/1\/18\/Manage-Priorities-with-Excel-Step-4-Version-4.jpg\/v4-460px-Manage-Priorities-with-Excel-Step-4-Version-4.jpg","bigUrl":"\/images\/thumb\/1\/18\/Manage-Priorities-with-Excel-Step-4-Version-4.jpg\/aid409031-v4-728px-Manage-Priorities-with-Excel-Step-4-Version-4.jpg","smallWidth":460,"smallHeight":345,"bigWidth":"728","bigHeight":"546","licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>

<\/p><\/div>"} 4 Define the name "Importance". Select from Cell A2 to C7. Click on Insert Name Define Define the name as "Importance" and click OK. Select from Cell A2 to C7. Click on Insert Name Define

{"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/f\/fc\/Manage-Priorities-with-Excel-Step-5-Version-4.jpg\/v4-460px-Manage-Priorities-with-Excel-Step-5-Version-4.jpg","bigUrl":"\/images\/thumb\/f\/fc\/Manage-Priorities-with-Excel-Step-5-Version-4.jpg\/aid409031-v4-728px-Manage-Priorities-with-Excel-Step-5-Version-4.jpg","smallWidth":460,"smallHeight":345,"bigWidth":"728","bigHeight":"546","licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>

<\/p><\/div>"} 5 Create the Effort Table. Repeat steps 3, 4 and 5 to create the Effort table in columns E, F, and G. Select cells E2 to G6 and give them the name "Effort".

{"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/b\/b3\/Manage-Priorities-with-Excel-Step-7-Version-4.jpg\/v4-460px-Manage-Priorities-with-Excel-Step-7-Version-4.jpg","bigUrl":"\/images\/thumb\/b\/b3\/Manage-Priorities-with-Excel-Step-7-Version-4.jpg\/aid409031-v4-728px-Manage-Priorities-with-Excel-Step-7-Version-4.jpg","smallWidth":460,"smallHeight":345,"bigWidth":"728","bigHeight":"546","licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>

<\/p><\/div>"} 7 Enter headings on Home tab. Click on the Home tab and insert headings in row 1: A - Priority A formula, 1 for the most important task, but can be over 100

B - Task Name of the task.

C - Importance An A, B, C, D, E, or F from the table.

D - Effort A 1-5, from the Effort table.

E - Urgency A formula based on Due date.

F - Due Date when the task should be finished. Due dates are not hard and fast. Ramp Up tells you how early you could start the task and Extension tells you how many days it could slide. Getting a haircut might have a Ramp Up of 5 and an Extension of 4 - it doesn’t make sense to get a haircut 2 weeks early and people might notice if it was more than 5 days late.

tells you how early you could start the task and tells you how many days it could slide. Getting a haircut might have a Ramp Up of 5 and an Extension of 4 - it doesn’t make sense to get a haircut 2 weeks early and people might notice if it was more than 5 days late. G - Ramp Up Days prior to Due date you could start task.

H - Extension Automatic extension of Due date

I - Days Left Formula. Number of days before Due date; negative if Due date has passed.

J - Finished Date task was actually completed.

K - Comment Any details for the task. Click on the Home tab and insert headings in row 1:

{"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/d\/df\/Manage-Priorities-with-Excel-Step-10-Version-4.jpg\/v4-460px-Manage-Priorities-with-Excel-Step-10-Version-4.jpg","bigUrl":"\/images\/thumb\/d\/df\/Manage-Priorities-with-Excel-Step-10-Version-4.jpg\/aid409031-v4-728px-Manage-Priorities-with-Excel-Step-10-Version-4.jpg","smallWidth":460,"smallHeight":345,"bigWidth":"728","bigHeight":"546","licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>

<\/p><\/div>"} 10 Change the format for Cell I2 to Integer by right clicking on the cell, selecting format and make it a Number with 0 Decimal places.

{"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/a\/a0\/Manage-Priorities-with-Excel-Step-11-Version-4.jpg\/v4-460px-Manage-Priorities-with-Excel-Step-11-Version-4.jpg","bigUrl":"\/images\/thumb\/a\/a0\/Manage-Priorities-with-Excel-Step-11-Version-4.jpg\/aid409031-v4-728px-Manage-Priorities-with-Excel-Step-11-Version-4.jpg","smallWidth":460,"smallHeight":345,"bigWidth":"728","bigHeight":"546","licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>

<\/p><\/div>"} 11 Copy formulas for Priority, Urgency and Days Left to the remaining cells in each column. Select cell E2 and type CTRL-C. Select cells E3 to E10 and click CTRL-V. Repeat to copy cell I2 to cells I3 to I10. Finally, repeat to copy cell A2 to cells A3 to A10. Ignore the odd values you get for undefined tasks.