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

Подписаться 5 тыс.

Просмотров 159 тыс.

50% 1

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/...
#GanttChart
#ProjectPlanning
#MSExcel

Опубликовано:

3 окт 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 74

@Truefittness 14 дней назад

Paa ji Aapka bahut bahut shukriya aapki wajah se maine ek bahut achhi cheez sikhi hain Mujhe mera first project mila tha or mere boss ne Gantt chart banane ko bola mujhe pata bhi nahi tha ye chart bhi kuch hota hain but aapko support se balle balle ho gai meri to Channel subscribe kardiya hain maine aapka❤

@NadeemKhan-qp9il 18 дней назад

Excellent explanation. Great job Baljeet Singh brother

@rohitnrg 2 года назад

Your are excellent Very greatfull to you for making this.

@rahuljha5972 4 года назад

Sir kaafi knowledgeable videos hai please Inn formula pr videos banee

@engr.muhammadishaque8918 Год назад

Help me alot to complete my task

@TheKiranlntecc Год назад

Very useful brother tq

@RS_Randy 4 года назад

🙏nicely Explain👌

@keuangan7409 Год назад

thank you very much

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

@AbhaySingh-or6bj 2 года назад

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

@cartoon_TVDc 5 месяцев назад

Ye lock karna kya bolo yarrr vo to samjado bhaiiiii mere

@pratikmishra19 4 года назад

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

@JustSharing 4 года назад

Its help me in my project

@CourseforcivilEngineering 8 месяцев назад

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

@samirparmar3318 Месяц назад

Dear please send me this template for my use, it's great

@irfanzia4147 3 года назад

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

@lelounga7932 2 года назад

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

@NotvalidValid 8 месяцев назад

Paaji bahut he tedious method hai, bahut time lagega,

@gcsindia528 2 года назад

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

@pawankishore4933 4 года назад

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

@cartoon_TVDc 5 месяцев назад

Ye lock karna kya bolo yarrr vo to samjado bhaiiiii mere

@vinodsharma-ud6bc 4 года назад

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

@mbaljeetsingh 2 года назад

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

@s2_p_2524 2 года назад

@@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

@meetoswal101 Месяц назад

Thankyou

@jaikishansmspl39 17 дней назад

Good one.

@mohd.ibrahim737 3 месяца назад

So too hard work Kuch easy ho skta h kya

@noufalsm 4 года назад

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

@iqbalsingh6311 4 года назад

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

@balasaheblokhande391 7 месяцев назад

Sir please request to week wise or month wise schedule required

@csukani Год назад

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

@piyushrvyas 2 года назад

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 2 года назад

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

@devendrakushwaha5048 Год назад

Can colorblind poeple make this chart?

@riettefourie8928 4 года назад

Thank you for assisting me. From Cape Town South Africa

@trickshot. 2 года назад

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.

@shakifrauf2204 2 года назад

isse zyada bakwas video maine nahi dekheya abhitak Sorry

@kathirvel6565 2 года назад

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

@edilbertoaustria19 3 года назад

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

@solooutvlog 2 года назад

Kindly monthly base pr kesy bnayegy gantt chart.

@DeepakRajput-ik1qm 4 года назад

Good video sir

@akshaytone1897 11 месяцев назад

Valuable information share...thanks

@farooqbashir4111 2 года назад

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

@Waseemyounus15 Месяц назад

Thank you so much sir.

@josephneequaye7206 2 года назад

English . Selfish man

@dhirajgawde6819 9 месяцев назад

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

@lawrencejiwan7158 Год назад

Very nice and easy to und.Thanks.

@kamleshmishra8020 Год назад

Sir thanks

@aishwaryakamra2034 Год назад

Helpful! Thank you!

@osyuvancmanjunathan1452 6 месяцев назад

Wonderful

@balvinderjp 3 года назад

I want to add holidays into Gantt chart

@noufalsm 4 года назад

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 4 года назад

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.