Deliverablesĭeliverables are the product or products of what you expect to have at the end of your project. Read: Guide to project integration management (7 step process) 4. This could mean the team directly working on it, tertiary teams who need to learn a new process, or the company CEO to ensure that the business continues to run smoothly. Project stakeholders are the people who are directly impacted by the project you are working on. The project manager is responsible for every step of the project-from ideation to completion-as well as key workflows throughout the entire process. A project may have a dedicated project manager, though in some cases the person in the project manager role may have a different title altogether. Project managerĪ project manager is the role a person plays to ensure that a project goes smoothly from beginning to end. Although using project management software is not required when you’re managing a project, it can help align your team to be more efficient by saving time, organizing assets, and tracking your milestones as the project progresses. Some project managers use specific project management software in their project management process, like Asana, and others use more generalized software for their planning, such as Excel. Project management software is the specific type of software you use to manage a project. Project management can cover a wide array of topics, but here are a few terms that are common to project management regardless of what industry you're in: 1. Your team will be more organized, have a stronger sense of what needs to be done, and have a clearer roadmap of how to achieve your goals. Watch it below or see it on my YouTube channel.Whether you’re just getting introduced to all things project management or you’re looking for a refresher on key terms, we’ve compiled a list of common project management terms that you may encounter when managing a project.Īs you gain familiarity with these terms, you’ll see that sharing a common language with your team members can help your project progress more smoothly. If you are still confused about the conditional formatting rules for highlighting overdue items, check out this video. And repeat that 99 more times & you know how to ship 100 smiles □ Highlight overdue items – Video Now that we understand how this works, give me a big smile. By removing the $ Excel will check relative columns and the conditions would not work! We need to use $D6 & $C6 (instead of D6, C6) because we want Excel to check Completed & Due date columns. This is another simple AND formula =AND($C6”Yes”) Then to check if due date is in next week, we use MEDIAN formula, like this MEDIAN(TODAY()+1,$C6,TODAY()+7) We use $D6 (not D6) because we want Excel to look at column D (completed?) even when we are highlighting other columns (B – Item, C – Due date). We just see if a todo item is completed and then highlight the whole row dull gray color. If not done & already due show in red fill, white color.Not done & due in next 7 days show in orange color fill.We have 3 conditions in our highlight table (shown above). Understanding the highlighting conditions Lets talk about the solution & understand why it works. How the heck am I supposed to ship 100 units of smile.Why does it work? – ExplanationĪt this point you may have 2 burning questions. Now, the items will be highlighted based on the current date (TODAY) and change colors as you make progress. And set font color to dull gray from formatting button.Highlight upcoming items: conditional-formatting-rule-for-upcoming-tasks And set fill color to red & font color to white.Select the rule type as “use a formula…”.Select the entire range (B6:D15) and from home ribbon select conditional formatting.Follow below steps: Highlight overdue items: conditional-formatting-rule-for-overdue-items How to apply conditional formatting rules The data is in the range – B6:D15, with Items (column B), Due date (C) and Completed?(D).First lets look at the solution and then learn why it works. And of course start working on the items that are dueĪs you can guess, highlighting the due items is easier than actually doing them.Highlight items & due dates, subject to these conditions.and you have list of to-do items as shown below. highlight-overdue-items-in-excel The problem – Highlight due dates in Excel Here is an example of overdue, upcoming activities highlighted. The item can be an invoice, a to do activity, a project or anything. So today, lets talk about a very familiar problem. For the rest of us, deadlines are the sole motivation for working (barring free internet & the coffee machine in 2nd floor, of course). Congratulations to you if your job does not involve dead lines.