Gantt Chart Excel Tutorial in Hindi || Make a gantt chart with automatic chart update with dates ||

In this video, I will show you how to make a basic Gantt Chart. This is a basic gantt chart with Project Plan start & End Date and Project actual start and end date. As soon as you enter date in the cells, chart will get updated automatically. We have covered all the steps to make a chart from scratch.
Get Excel File: gumroad.com/l/jlXoQy
#GanttChart
#ProjectPlanning
#MSExcel

[@riettefourie8928]

Thank you for assisting me. From Cape Town South Africa

[@thomastung1378]

SO helpful for me. Thank you guy!

[@rakeshghosh741]

Just loved it🧡.. thanks a lot 🙂🙏

[@ashishq2002]

Thanks, Very nicely explained, looking forward for more videos.

[@rojahazarika8960]

Was really helping THANK YOU SO MUCH SIR

[@Rmujib47]

lovely to see nd very informative ...thank you so much

[@rohitnrg]

Your are excellent
Very greatfull to you for making this.

[@dhirajgawde6819]

Baljeet Bhai , Very informative video. Thanks for sharing your valuable knowledge

[@RS_Randy]

🙏nicely Explain👌

[@aishwaryakamra2034]

Helpful!
Thank you!

[@harshadpatkar5346]

Help full.. Thank You

[@lelounga7932]

It is good, please also make weekly and monthly project chart for longer projects
Thank you

[@kapileshdubey2597]

Superb, Sir 👍

[@akshaytone1897]

Valuable information share...thanks

[@RajanandSinghSupport675]

Thank you sir
Maine bana Diya sir ji

[@lawrencejiwan7158]

Very nice and easy to und.Thanks.

[@rahuljha5972]

Sir kaafi knowledgeable videos hai please Inn formula pr videos banee

[@anwarpatelrazvi]

Zabrdast paaaji

[@JustSharing]

Its help me in my project

[@gcsindia528]

Ek video men formula samjhayye aaram se plz, excellent teaching sir

[@TheKiranlntecc]

Very useful brother tq

[@CourseforcivilEngineering]

Plz make video for weekwise instead of datewise.
Means W1,W2,W3,W3 for perticular month then same for next month.

[@DeepakRajput-ik1qm]

Good video sir

[@govindkerai8717]

Good work
Needful

[@engr.muhammadishaque8918]

Help me alot to complete my task

[@nehagoyal5236]

helped me a lot, thanks! Just want to know is there is a way to hide weekends (Sat-Sun)? Deleting Sat-Sun is messing up with the date logic.

[@user-ju6kv3tc4m]

thank you very much

[@vipsingh7273]

Thank sir✌

[@flowcharttocodeconverter936]

Good information

[@abdulwahabal-anesi1961]

Good Gant Chart

[@piyushrvyas]

Baljeet, that was wonderful tool you developed. i am a novice in excel, only using basics of excel. Hence request you to please share this file of Gantt so that i can start working and tutoring ourselves

[@mbaljeetsingh]

Get Excel File here: mbaljeetsingh.gumroad.com/l/jlXoQy

[@osyuvancmanjunathan1452]

Wonderful

[@juststart8387]

Got it.. 🙂

[@farooqbashir4111]

Very Good. Kindly add one Column cor Duration = No. Of Days. Again Thank You.

[@kamleshmishra8020]

Sir thanks

[@pratikmishra19]

Hi Sir, Can you provide the formula where i can start with number of week, not with date?

[@mohd.ibrahim737]

So too hard work
Kuch easy ho skta h kya

[@noufalsm]

Good Morning . Very Nice Explained and I implemented on my files. I have one question regarding in this. In UAE we consider Friday is Holiday, so accordingly all the activity shall be impact ,could you please explain this logic in this Excel Sheet .

[@iqbalsingh6311]

Hi Mohammed Noufal, in the video, all days are mentioned. If you are asking your week to start on satuday, that you can do by changing the weekday function to respective value.

[@csukani]

Very useful video... but just want to know .. how we can eliminate sunday .or weekends.... & particular day... in such kind of charts

[@trickshot.]

Sir please make video on gantt chart on hourly basis for daily planing.

[@sibanandamishraeeedept1831]

Sir , How to keep print out of this gant chart for record.

[@pawankishore4933]

sir i am not able to get "X " on the start date of the month

[@solooutvlog]

Kindly monthly base pr kesy bnayegy gantt chart.

[@dineshkumarsaxena1939]

Sir I want to know how to take task duration.

[@balasaheblokhande391]

Sir please request to week wise or month wise schedule required

[@sivaprabhu9243]

Jii in this chart how do we avoid the weekend days with manual entry

[@iqbalsingh6311]

Hi Siva, you can simply not write formulas for weekend at first place. That should help

[@edilbertoaustria19]

I like your gantt format but i can understand the way you do it, it's complicated

[@AbhaySingh-or6bj]

Sir jo ye activity hai usme hm kuch bhi mention kr sakte hai

[@balvinderjp]

I want to add holidays into Gantt chart

[@devendrakushwaha5048]

Can colorblind poeple make this chart?

[@irfanzia4147]

Baljeet Paaji how can we do it in month & not in week

[@kathirvel6565]

What happens if we only have start date not knowing the exact end date

[@vinodsharma-ud6bc]

Please upload the excel file of this Gantt chart in description so that one can download

[@mbaljeetsingh]

Get Excel File here: mbaljeetsingh.gumroad.com/l/jlXoQy

[@s2_p_2524]

@@mbaljeetsingh Hi sir , I just watched the video , it’s really helpful . Can I get your email id for further discussion on this pls ? I wanted this file . Thank you 🙏🏼

[@nanda2.037]

​@@s2_p_2524for file u need to be pay money

[@edilbertoaustria19]

Can you explain it in English

[@cartoon_TVDc]

Ye lock karna kya bolo yarrr vo to samjado bhaiiiii mere

[@noufalsm]

Can you please provide the formula which is avoid Friday
=IF($B5="","",IF(AND($C5=F$3),"x",""))

[@iqbalsingh6311]

You can simply delete column having friday and copy the same for all weeks

[@Godblessforeveryone]

Subtitle Sir 🙏🙏😁

[@user-xp8kp2zk7w]

Paaji bahut he tedious method hai, bahut time lagega,

[@josephneequaye7206]

English . Selfish man

[@shakifrauf2204]

isse zyada bakwas video maine nahi dekheya abhitak
Sorry

[@cartoon_TVDc]

Ye lock karna kya bolo yarrr vo to samjado bhaiiiii mere