How to create a Project Plan in Microsoft Excel

Get the template: https://youexec.com/spreadsheet-templ...

Table of Contents:
00:00 - Intro
01:16 - How to set up a project in the Project Plan template
02:46 - How to manage tasks in a Project Plan Template
04:53 - How to track tasks with a Gantt Chart
05:59 - Task triage with Eisenhower and Impact vs. Effort matrix
08:49 - Analyze potential risk of tasks with the Project Plan template
11:25 - How to create a RACI matrix in a spreadsheet
12:32 - How to create a Project Plan dashboard
14:12 - Outro

Any project manager needs a go-to spreadsheet template they can use to manage the tasks and milestones of a bespoke project. In this video, we are going to highlight the features of our Project Plan Template, so you can systematize your project management.

We will illustrate how to manage different projects and tasks to analyze them in different views, such as: Kanban board, to keep track of the task's stage; Gantt chart, to track the timeline and duration; Triage matrix, to categorize the importance, urgency, effort and impact of the task; Risk analysis layout, to assess the task's risk severity based on likelihood and tolerance; RACI chart, to assign different roles to team members for each task; and lastly, a Dashboard, to overview the project's results and outcome.

Although this template can be used for corporate, small business, or personal initiatives – we are going to use the hypothetical example of “house flip” throughout this video to give you concrete examples of how to use this template. Watch until the end to learn more!