1 / 67

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

This presentation on project planning in Excel will help us understand the process of project planning concerning Excel. The video will explain the process of project management in Excel, elaborating on the reasons why we should use excel for project management. Then we will see the basics of a Gantt chart, along with understanding the process of making a Gantt chart in Excel. We will also see different Microsoft Excel templates, along with their features. Now, let us get started.<br><br>The below topics are explained in this project planning presentation:<br>1. What is a project plan?<br>2. Project management in Excel<br>3. Why use Microsoft Excel?<br>4. How to make a Gantt chart in Excel?<br>5. Microsoft Excel templates <br><br>PMP Certification Course Overview<br>The course covers new trends, emerging practices, tailoring considerations, and core competencies required of a Project Management professional. Placing a greater emphasis on strategic and business knowledge, this course also includes a new section on the role of the project manager in both large and small companies.<br><br>PMP Course Key Features:<br>- 35 contact hours/PDUs<br>- 8 industry case studies, 20 industry-based scenarios<br>- 6 hands-on projects, 7 simulation test papers (200 questions each)<br><br>Eligibility:<br>The PMPu00ae certification is an essential professional requirement for senior project manager roles across all industries. The course is best suited for: Project Managers, Associate/Assistant Project Managers, Team Leads/Team Managers, Project Executives/Project Engineers, Software Developers, Any professional aspiring to be a Project Manager.<br><br>Pre-requisites:<br>You should have a secondary degree (i.e. high school diploma, associateu2019s degree or the global equivalent) with 7,500 hours leading and directing projects along with 35 hours of project management education.OR You should have a four-year degree with 4,500 hours leading and directing projects along with 35 hours of project management education.<br><br>Learn more at https://www.simplilearn.com/project-management/pmp-certification-training

Simplilearn
Download Presentation

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

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. 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

  2. What is a Project Plan?

  3. Click here to watch the video

  4. 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

  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 Project control

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

  7. 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?

  8. 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?

  9. 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?

  10. Project Management in Excel

  11. 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

  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 Plan

  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 Monitor Visualize Plan

  14. Why use Microsoft Excel?

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

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

  17. 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

  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 MS Excel provides several project management templates

  19. How to make a Gantt chart in Excel?

  20. 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.

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

  22. 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)

  23. 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

  24. 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.

  25. 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

  26. 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

  27. 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

  28. 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

  29. 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

  30. 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

  31. 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

  32. 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

  33. 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

  34. 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

  35. 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

  36. 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

  37. 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

  38. 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

  39. 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

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

  41. 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

  42. 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

  43. 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

  44. 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

  45. Microsoft Excel templates

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

  47. 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

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

  49. 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

More Related