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

[@unofficialkaryalay]

Like, Share and Subscribe!

[@jayantpandit339]

Very nicely explained. Thank you so much.

[@unofficialkaryalay]

Thank You Sir!

[@jatingirdhar1589]

00:04 Learn how to create a dynamic Gantt chart in Excel 01:20 Using data validation to create a dropdown list and adding dates to the Gantt chart in Excel 02:31 Creating Gantt chart in Excel with orientation and logical formulas 03:51 Creating Gantt chart in Excel with logical tests and conditional formatting 05:15 How to apply conditional formatting in Excel 06:32 Customizing Gantt Chart in Excel in Hindi 07:49 Formatting and highlighting dates in Excel 09:16 Locking the cells and protecting the chart in Excel

[@unofficialkaryalay]

Thanks

[@AyemUnknown]

such an underrated channel. such a good teacher

[@unofficialkaryalay]

Thanks a lot bhai

[@baiesha]

wow what a wonderful explaination =..keep going dear... u just didnt waste a bit of time ..

[@unofficialkaryalay]

Thank you so much 🙂

[@rssamanta4437]

Very good video.Thank you.

[@unofficialkaryalay]

Thank you

[@AvantGarde-wx7yz]

Simple and easy to understand

[@unofficialkaryalay]

Glad to hear that

[@sonambedi110]

Very helpful and easy to understand video Thank you sir

[@unofficialkaryalay]

Most welcome

[@sonambedi110]

Very informative. Thank you so much

[@unofficialkaryalay]

Glad it was helpful!

[@FunCorner-nj7kw]

amazing report🔥

[@unofficialkaryalay]

Thanks

[@vijaykumar-pq2lm]

very well explained 👌

[@unofficialkaryalay]

Thank you so much 🙂

[@SanketS-q6o]

Nice video and topic

[@unofficialkaryalay]

Thanks

[@ashishbanerkar8489]

Thank you, very well explained.

[@unofficialkaryalay]

Glad you liked it

[@ashitguleria5868]

Useful 🤘🏻

[@unofficialkaryalay]

Thanks!

[@sm9399]

Brilliant. Thank you 🙏🙏

[@unofficialkaryalay]

Glad it was helpful!

[@gurpreetkour1894]

Thanks bro, much needed.

[@unofficialkaryalay]

Glad it helped

[@vijaykumar-pq2lm]

very nice vedio👌👌👌👌👌

[@unofficialkaryalay]

Thanks a lot

[@mathsbyranjeetchauhansir3995]

Smart teaching sir

[@unofficialkaryalay]

Thanks sir

[@mathsbyranjeetchauhansir3995]

Good job for new guys

[@unofficialkaryalay]

Thanks!

[@abuluqman03]

Thank you, Very informative with short time. One question, How to add milestone marker on particular day?

[@unofficialkaryalay]

It is there in the video itself.

[@deepakkumar-ki7gq]

nice

[@unofficialkaryalay]

Thanks!

[@NidhiMittal-p4i]

good trick

[@unofficialkaryalay]

Thanks

[@syamaldas8468]

Sir, It is a very usefull and good and easy to learn. Thank you very much. One question as given below 1) why there's no any link in between one activity to next activity?Is it possible to link each other? Kindly send. Regards 🙏

[@unofficialkaryalay]

Thanks for your kind words. Just to clarify by activity you mean the videos?

[@ShravyaShetty-f7s]

thanks sir

[@unofficialkaryalay]

Most welcome

[@PuneetKumar-nm6je]

Bahut achha sikhaya but speed Kam Karo sir please

[@unofficialkaryalay]

Thanks bhai. Next video m dhyaan rakhunga

[@NotvalidValid]

Sir, brilliant sab ek dum theek hai lekin sir thoda time dekar, slowly explaination karenge to behtar rahega note karnay kay liye.

[@unofficialkaryalay]

Thanks for your feedback!

[@hedayatullahkhan3940]

Bahut fast hai bhai apne bolo apne samjho

[@TechEngineer0123]

v nice

[@unofficialkaryalay]

Thanks

[@Rishi-j9c4m]

badhiya hai

[@unofficialkaryalay]

👍

[@rajeshpandey1882]

Sir, in status columns, how to select dummy statuse. Regard

[@rajeshpandey1882]

Please help and let me know. Regards

[@unofficialkaryalay]

Update the cell reference

[@sohrabahmad9474]

I am unable to use if and and formula. I am doing everything as per your guidance but it is not happening

[@unofficialkaryalay]

Please verify the Excel version that your using

[@navinyadav9793]

Can you please add one column as - Actual End date and it is also shown in the bar chart. If possible please add one more which is the work completion percentage.

[@unofficialkaryalay]

Thanks for the feedback, will work on it.

[@engineerlife3504]

What's the main difference between primavera p6 and Microsoft Office? Please give me a proper answer.

[@unofficialkaryalay]

I have not used Primavera

[@jatingirdhar1589]

Sir, 4:30 par samajhne me bahut problem aa rahi hai jabki kai dafa video dekh liya, fir bhi :( ...please help me, sir !

[@unofficialkaryalay]

Kya problem aarahi hai?

[@jatingirdhar1589]

sir, aap ye bhi bataiye ki aaj kya date hai taki viewers relate kar payein date ke hisab se ... :)

[@unofficialkaryalay]

Sure, thanks

[@lotusadvance]

same formula i am using dikto copy but not working

[@unofficialkaryalay]

Koi ek specific formula kaam nahi kar raha hai ya koi bhi nahi kar raha?

[@unofficialkaryalay]

Koi specific formula kaam nahi kar raha hai ya koi bhi formula kaam nahi kar raha?

[@vsstoryteller]

Sir, apko mai shayd pehechanta hun... Plz apna naam bataiye

[@amanullahamanullah5386]

How to add milestones

[@unofficialkaryalay]

Review important milestone cell to understand how to add milestone. Same process can be repeated to add multiple milestones.

[@hedayatullahkhan3940]

You are very fast please make it slow thanks

[@unofficialkaryalay]

I will try my best

[@lotusadvance]

please help

[@unofficialkaryalay]

Ok