EDUCBA

EDUCBA

MENUMENU
  • Free Tutorials
  • Certification Courses
  • 120+ Courses All in One Bundle
  • Login
Home Excel Excel Resources Excel Charts Project Management with Gantt Chart
Secondary Sidebar
Excel Functions
  • Excel Charts
    • Excel Data Visualization
    • Dashboard in Excel
    • Bullet Chart in Excel
    • Excel Animation Chart
    • Plots in Excel  
    • Interactive Chart in Excel
    • Surface Charts in Excel
    • Excel Calendar Template
    • Thermometer Chart in Excel
    • Box Plot in Excel
    • S CURVE in Excel
    • Venn Diagram in Excel
    • Project Management with Gantt Chart
    • Change Chart Style in Excel
    • 3D Scatter Plot in Excel
    • Box and Whisker Plot in Excel
    • Radar Chart in Excel
    • Control Charts in Excel
    • Dot Plots in Excel
    • Marimekko Chart Excel
    • Combo Chart in Excel
    • Contour Plots in Excel
    • Candlestick Chart in Excel
    • Map Chart in Excel
    • Pie Chart Examples
    • Excel Stacked Bar Chart
    • Excel Flowchart
    • Excel Types of Graphs
    • Excel Normal Distribution Graph
    • Excel Bell Curve
    • Legends in Excel Chart
    • Excel Chart Templates
    • Excel Organization Chart
    • Excel Doughnut chart
    • Excel 3D Plot
    • Excel Scatter Chart
    • Excel Line Chart
    • Excel Combination Charts
    • Excel Gauge Chart
    • Excel Pivot Chart
    • Excel Clustered Column Chart
    • Excel Dynamic Chart
    • Excel Stacked Column Chart
    • Excel Bubble Chart
    • Histogram Chart Excel
    • Excel Gantt Chart
    • Excel Stacked Area Chart
    • Excel Waterfall Chart
    • Excel Area Chart
    • Excel Clustered Bar Chart
    • Excel Column Chart
    • Excel Pie Chart
    • Comparison Chart in Excel
    • Pareto Analysis in Excel
    • Add a Secondary Axis in Excel
    • Grouped Bar Chart
  • Excel Functions (12+)
  • Excel Tools (114+)
  • Financial Functions in Excel (17+)
  • Logical Functions in Excel (14+)
  • Lookup and Reference Functions in Excel (35+)
  • Maths Function in Excel (47+)
  • TEXT and String Functions in Excel (26+)
  • Date and Time Function in Excel (24+)
  • Statistical Functions in Excel (59+)
  • Information Functions in Excel (4+)
  • Excel Tips (222+)
  • Workplace Productivity (4+)
  • Microsoft Office Tools (15+)
  • Excel Formula and Functions (22+)
  • MS Excel Shortcuts (4+)
Excel Functions Courses
  • EXCEL ADVANCED COURSE
  • Excel Data Analysis Course
  • Excel for Marketing Course

Project Management with Gantt Chart

By Madhuri ThakurMadhuri Thakur

Excel Project Management Template

Project Management with Gantt Chart (Table of Contents)

  • Excel Project Management Template
  • How to Create Project Management Using Gantt Chart in Excel?

Excel Project Management Template

Every project needs to be tracked for a smooth flow of the process. If you surf on Google, you will find plenty of ready templates but not necessarily which fits your needs. Most people download and start using those ready templates and are not worried about how they actually prepared. However, knowing how they have prepared will be key to preparing your own project management templates using a Gantt chart. This article will show you how to create a project management template using the Gantt chart in excel.

How to Create Project Management Using Gantt Chart in Excel?

Excel is a popular tool for using Project Management. Let us see how we can use this with the help of an excel spreadsheet.

You can download this Excel Project Management Template here – Excel Project Management Template

Project Management Gantt Chart Example

Gantt chart is the most often used technique for project management. A Gantt chart is prepared using excel’s built-in charts, but in this article, we will show you how to build a Gantt chart by using conditional formatting. Assume you have taken a construction project, you are supposed to work in a tight guideline from the starting day of the project, and you are required to finish the project in 30 days. The first thing you need to do is to list activities involved in construction. Below are the activities involved in general. Now you need to decide on the time frame of each activity, i.e. duration time for each process. Prepare the duration from starting date to ending date.

Start Your Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

Excel Project Management Template 1-1

  • Now on the horizontal row, enter these days like below. The starting date will be 17th July 2019, and the end date will be 16th Aug 2019.

PMC

  • One of the problems with this is that dates are too long to see in the single view; you have to change the date format from “DD-MMM-YYYY” to only the “DD” format to minimize the column width.

Excel Project Management Template 1-3

  • In these small boxes, we need to decide which date each activity is supposed to close. Enter the below formula to declare the closing date.

Excel Project Management Template 1-4

  • After using the formula, the output is shown below.

Excel Project Management Template 1-5

  • This formula says if the horizontal date is >= starting date and horizontal date is <= ending date, then the result should be “P” or else blank.
  • To apply the formula to all the remaining cells, we first have to select and press Ctrl + D and then press Ctrl + R.

Excel Project Management Template 1-6

Now we need to apply Conditional Formatting for this. Follow the below steps to apply conditional formatting.

Step 1: Select the area that we have applied the formula to declare “P”.

Step 2: Go to Conditional Formatting and click on “New Rule”.

Excel Project Management Template 1-7

Step 3: In the New, Rule window select the option “Format only cells that contain”.

New Formatting Rule

Step 4: Next, in the formula section, choose “equal to” and enter the below formula.

edit the rule Description

Now we need to apply the Conditional Formatting to the cell, which has the letter “P”, So enter the formula as “P”.

All in One Excel VBA Bundle(120+ Courses, 30+ Projects)
Basic ExcelAdvanced ExcelVBA & MacrosExcel Dashboards
Pivot TablesStatistical FunctionsFinancial FunctionsCharts & Graphs
Price
View Courses
120+ Online Courses | 30+ Projects | 500+ Hours | Verifiable Certificates | Lifetime Access
4.9 (64,596 ratings)

edit the rule Description 1

Step 5: Now click on “Format”.

Format edit

Step 6: Now, we will see the “Format Cells” window. In this window, we can choose the kind of format that we are looking to apply to the cells which have the letter “P”. Go to the “Fill” tab and choose the color as “Green”.

Fill Tab

Step 7: In the same window, go to the “Font” tab and choose the font color as “Green” only. I have selected green because we don’t want to see the letter “P” in the Gantt chart.

Font Colour

Step 8: Now click on Ok to apply the formatting. It will take you back to the previous window of conditional formatting. In this window to click on “OK” to complete the conditional formatting.

edit the rule Description 2

Step 9: Now, our Gantt chart, which tracks our project of construction, is ready.

Gantt Chart

Things to Remember About Project Management with Gantt Chart

  • Creating Project Management with Gantt Chart is a quite complex process. It is not always easy for intermediate users of excel.
  • Through conditional formatting, we can easily create a Gantt chart to track any project.
  • We have given the example of construction; based on your requirement, you need to change the activity list, starting date, ending date, and the same needs to be updated horizontally as well.
  • You can change the color of the chart while applying conditional formatting.

Recommended Articles

This is a guide to Project Management with Gantt Chart. Here, we discuss creating project management with a Gantt chart with practical examples and a downloadable excel template. You can also go through our other suggested articles –

  1. Excel Gantt Chart
  2. Project Management Template in Excel
  3. Marimekko Chart Excel
  4. VBA Charts
Popular Course in this category
Excel Advanced Training (16 Courses, 23+ Projects)
  16 Online Courses |  23 Hands-on Projects |  140+ Hours |  Verifiable Certificate of Completion
4.8
Price

View Course

Related Courses

Excel Data Analysis Training (17 Courses, 8+ Projects)4.9
Excel for Marketing Training (8 Courses, 13+ Projects)4.8
0 Shares
Share
Tweet
Share
Primary Sidebar
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Corporate Training
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Excel Charts
  • Excel Tips
  • All Tutorials
Certification Courses
  • All Courses
  • Excel VBA Course - All in One Bundle
  • VBA Course
  • Excel Data Analysis Course
  • Excel for Marketing Course
  • Excel for Finance Course
  • Excel for HR Training

ISO 10004:2018 & ISO 9001:2015 Certified

© 2022 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA Login

Forgot Password?

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

Download Excel Project Management Template

EDUCBA

Download Excel Project Management Template

EDUCBA

डाउनलोड Excel Project Management Template

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more