Project Plan: How to make GANTT CHART in Excel in Hindi

Channel Avatar
Comment
X
Share
Project Plan: How to make GANTT CHART in Excel in Hindi
Project Plan: How to make GANTT CHART in Excel in Hindi
In this video you will learn how to create a good-looking Project Plan or a Gantt chart in excel. I have not used any kind of Chart or macro. It has been created by using conditional formatting in excel.
How do we create a Gantt chart? / What is Gantt chart formula? / How do I create a project plan in Excel? / How to create a Gantt chart in Excel with start and end dates?

Time Stamp:
00:00 Intro
00:42 Adding Gantt Chart Columns and Data Validaion
03:18 IF logical formula to highlight Gantt Chart Milestone
05:20 Conditional Formatting to highlight Gantt Chart Milestone and timeline
07:01 Designing the Gantt Chart/ Project Plan Template
07:35 Highlighting the important milestone with conditional formatting
09:25 Removing formula or protecting sheet using Protection to create Gantt Chart/ Project Plan
10:01 Wrap up

Subscribe to my channel: https://www.youtube.com/channel/UCGMXorn6yka6-6NfFTC8vTg
Follow us on Instagram: https://www.instagram.com/unofficialkaryalay/
Follow us on Twitter: https://twitter.com/UKaryalay

Excel Reports Playlist: https://www.youtube.com/playlist?listPLQbrn0UaVqQmAN6J_gDiiNvkVUFD0U2C4
Excel Playlist: https://www.youtube.com/playlist?listPLQbrn0UaVqQkCucZ2b6ErJhrp2-R8uK-Y
Excel Tips and Tricks: https://www.youtube.com/playlist?listPLQbrn0UaVqQnOcmKeXEwY8Yiac006B-3L
MS Word: https://www.youtube.com/playlist?listPLQbrn0UaVqQkPW-MXTy4FiV49YAh0-3DI
Excel formula and function playlist: https://www.youtube.com/playlist?listPLQbrn0UaVqQnfSZoc1sHvVT2Mwg6VuMvV

Download Gantt Chart Template: https://docs.google.com/spreadsheets/d/1RXGqhHBf2hRIFbHDz2aJNaqy-vG0O-cR/edit?uspsharing&ouid101104344662470722608&rtpoftrue&sdtrue

Your Queries:
BI Dashboard
EXCEL dashboard
Gantt chart in excel
Project charter in excel
Project Plan in excel
Task Status in excel
conditional formatting in excel
worksheet protection in excel
Hidden cell value in excel
data validation list in excel
highlight a particular column in excel
Project schedule in excel
Dynamics Graphs in excel
Advanced Chart in excel
Business chart in excel
irregular chart in excel
create gantt chart in excel with start and end dates
how to create a gantt chart in excel with months
gantt chart template excel
gantt chart excel template free
gantt chart template
simple gantt chart template excel

#ganttchart #projectmanagement #projectplanning #exceltutorial #ganttchartinexcel #gantt

Take the opportunity to connect and share this video with your friends and family if you find it useful.

Read Also

Leave a Reply

Your email address will not be published. Required fields are marked *