Project Planning | Project Plan In Excel With Gantt Chart | Project Management In Excel |Simplilearn

2. What’s in it for you? What is a Project Plan? Project Management in Excel Why use Microsoft Excel? How to make a Gantt chart in Excel? Microsoft Excel templates

3. What is a Project Plan?

4. Click here to watch the video

5. What is a Project Plan? Project Management Book of Knowledge (PMBOK) defines the project plan as a formal, approved document used to guide both project execution and project control Project execution

6. What is a Project Plan? Project Management Book of Knowledge (PMBOK) defines the project plan as a formal, approved document used to guide both project execution and project control Project execution Project control

7. What is a Project Plan? A project plan should answer: What? What are the major deliverables of the project?

8. What is a Project Plan? A project plan should answer: What? How? What are the major deliverables of the project? How we are supposed to get our deliverables before or on time?

9. What is a Project Plan? A project plan should answer: Who? Who will all be involved in the project, and what will be their responsibilities?

10. What is a Project Plan? A project plan should answer: Who? When? When will the project begin and when is it supposed to be complete? Who will all be involved in the project, and what will be their responsibilities?

11. Project Management in Excel

12. Project Management in Excel Microsoft Excel is a simple project management tool used by project managers working on small or midsized projects to visualize, plan, and monitor the project Visualize

13. Project Management in Excel Microsoft Excel is a simple project management tool used by project managers working on small or midsized projects to visualize, plan, and monitor the project Visualize Plan

14. Project Management in Excel Microsoft Excel is a simple project management tool used by project managers working on small or midsized projects to visualize, plan, and monitor the project Monitor Visualize Plan

15. Why use Microsoft Excel?

16. Why use Microsoft Excel? Simple to use and easy data manipulation

17. Why use Microsoft Excel? Simple to use and easy data manipulation Many analytical tools for efficient analysis, like concatenate etc

18. Why use Microsoft Excel? Simple to use and easy data manipulation Many analytical tools for efficient analysis, like concatenate etc Easy tracking and monitoring of project status

19. Why use Microsoft Excel? Simple to use and easy data manipulation Many analytical tools for efficient analysis, like concatenate etc Easy tracking and monitoring of project status MS Excel provides several project management templates

20. How to make a Gantt chart in Excel?

21. What is a Gantt chart in excel? • Gantt chart is a horizontal bar chart used in project management. • A Gantt chart provides a graphical representation of the schedule • Gantt charts help in assessing deadlines in a long project and the resources it needs.

22. How to make a Gantt chart in excel? Some basic steps of making a Gantt chart in excel can be seen as under:

23. How to make a Gantt chart in excel? 1. Make a project table • Each task is mentioned in a separate row, with their respected starting date and tenure (number of days required to complete that task)

24. How to make a Gantt chart in excel? 2. Make an excel bar chart • Select range of start date, B1:B11 • Click on insert tab, select bar charts group • Then select stacked bar in 2-D Bar chart group

25. How to make a Gantt chart in excel? 2. Make an excel bar chart • As a result we will have a bar graph as shown.

26. How to make a Gantt chart in excel? 3. Adding tenure to the chart • Right click anywhere on the chart • Select the “Select Data” option, from the drop-down menu

27. How to make a Gantt chart in excel? 3. Adding tenure to the chart • The “Select Data Source” window will open • Start Date is already in the entries • Click on the “Add” button, so we can enter the tenure

28. How to make a Gantt chart in excel? 3. Adding tenure to the chart • Type “Tenure” in Series name • Then click on the “range selection” icon

29. How to make a Gantt chart in excel? 3. Adding tenure to the chart • Then select the Tenure from the first cell from C2. • Drag all the relevant cells

30. How to make a Gantt chart in excel? 3. Adding tenure to the chart • Click on “OK” in the dialog box • We get this bar graph on the screen

31. How to make a Gantt chart in excel? 4. Adding task description to Gantt chart • Open the “Select Data Source” dialog box • Click on the “Edit” option as shown in the figure

32. How to make a Gantt chart in excel? 4. Adding task description to Gantt chart • Select your tasks in the same way, we selected our tenure • Click on “OK” after selection

33. How to make a Gantt chart in excel? 4. Adding task description to Gantt chart • Now we can see the tasks on the left side of the Gantt chart

34. How to make a Gantt chart in excel? 5. Changing from bar graph to Gantt chart • Click on the bars and select “Format Data Series” option

35. How to make a Gantt chart in excel? 5. Changing from bar graph to Gantt chart • Select “No fill” in the “Format Data Series” dialog box

36. How to make a Gantt chart in excel? 5. Changing from bar graph to Gantt chart • We can see the Gantt chart according to the data we had entered

37. How to make a Gantt chart in excel? 5. Changing from bar graph to Gantt chart • Click on the task panel • Select “Categories in reverse order option from the “Format Axis” dialog box

38. How to make a Gantt chart in excel? 5. Changing from bar graph to Gantt chart • Now the tasks are arranged in the right order, and we have this Gantt chart

39. How to make a Gantt chart in excel? 5. Changing from bar graph to Gantt chart • As we can notice the dates on the Gantt chart are from 11-Dec, while the dates we have entered is from 01-Jan • Copy the first date in any box

40. How to make a Gantt chart in excel? 5. Changing from bar graph to Gantt chart • Now click on the copied date and go in the “Home” menu to select the dialog box shown

41. How to make a Gantt chart in excel? 5. Changing from bar graph to Gantt chart • Select “Number” option in the dropdown menu

42. How to make a Gantt chart in excel? 5. Changing from bar graph to Gantt chart • Now, we can see a number displayed in the selected box

43. How to make a Gantt chart in excel? 5. Changing from bar graph to Gantt chart • Now, click on the dates on the Gantt chart, the “Format Axis” dialog box opens • We will put the number received in the previous slide, here in the “Minimum” box

44. How to make a Gantt chart in excel? 5. Changing from bar graph to Gantt chart • This is the final Gantt chart, that we get

45. How to make a Gantt chart in excel? 6. Improving the design of the Gantt chart • Now, we can do several things to improve the design of the Gantt chart • We can change the color or put effects to the bar

46. Microsoft Excel templates

47. Microsoft Excel templates for Project Management Microsoft Excel templates help collect data, schedule them and check their dependencies with each other

48. Microsoft Excel templates for Project Management Microsoft Excel templates help collect data, schedule them and check their dependencies with each other Microsoft Excel templates help in tracking and monitoring tasks, subtasks and their progress in a project

49. Microsoft Excel templates for Project Management 1. Excel Project Review Template

50. Microsoft Excel templates for Project Management 1. Excel Project Review Template • Excel Project Review Template helps in showing a clear overview of all the planned, outstanding, completed tasks • It allows Project Managers to measure progress in the project and discuss it with the stakeholders https://www.officetimeline.com/project-management/excel