Easy Excel Gantt Charts - Perfect for Project Management

[@MohammadArifRahim]

I had used this technique before. But yours have lots of layers. Thanks for sharing. Loved it.

[@MyOnlineTrainingHub]

Awesome! Thank you!

[@IvanCortinas_ES]

Good approach to conditional formatting in a Gantt chart. Thank you very much Mynda. The issues of the channel are very practical.

[@MyOnlineTrainingHub]

Glad you like them!

[@RandyMcNeil2]

Was all set to see the use of dependencies on tasks and the effects of a change or delay of one item and how it affected the rest. But for a standard training representation of how to format using conditional data in a real life gant chart, this was very good

[@MyOnlineTrainingHub]

Glad it was helpful 😊

[@learningwithmaliha]

Truly an amazing method to use Gantt Chart in Excel.

[@MyOnlineTrainingHub]

Glad it was helpful!

[@manojjohnaxelsson2856]

Every time i come back here to look up something, it is obvious to me that you are the AI (maybe even an alien) in the excel world that is currently in a human experience. Thank you Mynda!

[@MyOnlineTrainingHub]

😂glad you find my videos helpful!

[@brianwied3702]

Great tutorial, this is better than buying MS Project and it integrates better into program management dashboards.

[@MyOnlineTrainingHub]

Glad it was helpful!

[@GingerMan2342]

Excellent video as always - thanks! I wish Excel allowed you to create names for conditional formatting rules - it would be so much easier to understand what potentially complex formulae are doing if instead of seeing the formula in the manage rules dialogue, you saw a user defined name that described the result of the formula.

[@MyOnlineTrainingHub]

Yes, Names would be helpful indeed!

[@rigobertogarcia]

Excellent as always, Mynda. Thank you very much for sharing such valuable knowledge that results in a profound improvement of our professional development.

[@MyOnlineTrainingHub]

You are so welcome!

[@Steve157Oh]

Ooooh - this looks very useful. I use MSP a lot but it's not easy to read if you're not a regular user; these charts are a lot more accessible.

[@MyOnlineTrainingHub]

Great to hear, Steve!

[@giulianopierucci2903]

Excellent Mynda! Thank you!

[@MyOnlineTrainingHub]

Glad you liked it 😊

[@davidlinton4127]

Great stuff, thanks Mynda!

[@MyOnlineTrainingHub]

My pleasure!

[@chrism9037]

Thanks Mynda! I've used something similar before but I like yours a bit better.

[@MyOnlineTrainingHub]

Glad you liked it, Chris!

[@dragonkungfu19901991]

your videos help me a lot thank you very much. I also share your videos to collegues also. You are very talented.

[@MyOnlineTrainingHub]

Thanks so much for your support 🙏

[@robertososa7594]

Amazing as always Mynda! Thanks a lot! 👏👏👏

[@MyOnlineTrainingHub]

Thanks for watching!

[@yahyaalsulaiman9705]

u re awesome and really appreciate that you are sharing such brilliant knowledge... you always make my day

[@MyOnlineTrainingHub]

Thank you so much 😀

[@c.s.m.k5737]

Very Cool. Enjoyed this example for project management visualization

[@MyOnlineTrainingHub]

Great to hear! You'll love my Project Management Dashboard then: kzbin.info/www/bejne/jIaXn5Z4h5WDj9k

[@adamchmielewski61]

I have a slightly different technique. Instead of having the logic in the conditional formatting I have it all in the formulas. And the result is a number (1,2,3) or a short text (ok,x,bad) with the status and an empty string if nothing. And then I apply the conditional formatting to the value (e.g. if value = 2 then font and background green) Thanks to that I can use other formulas (like countif) to reference this. Like count the number of overdue days etc. But with what you gave, it’s easier to change the priority of colours and give comments directly in the cells.

[@MyOnlineTrainingHub]

Nice idea, Adam. I can see that being useful if you need to count results.

[@andriikulishov3371]

Dear Mynda, it looks absolutely fantastic! Would use that at work.

[@MyOnlineTrainingHub]

Great to hear!

[@nadermounir8228]

Thank you for this great tutorial

[@MyOnlineTrainingHub]

You're very welcome!

[@darrylmorgan]

Hi Mynda!Really Great Tutorial,Will Definitely Be Trying This Cool Technique Out...Thank You :)

[@MyOnlineTrainingHub]

Great to hear, Darryl!

[@Chiddu_Chingari298]

Hi Mynda, truly amazing!!👌🏻 Thank you so much for this video on Gantt Charts. Really means a lot to me. You're really helping many professionals like me to develop ourselves, gain knowledge & explore more. Take care & stay blessed.

[@MyOnlineTrainingHub]

Thanks for your kind words 🙏

[@Azhar_Khan383]

Amazing information, Thanks Mam

[@MyOnlineTrainingHub]

My pleasure!

[@magsarjavbolor5305]

Hi Mynda. Thank you for all that you do. It was very helpful! Could you tell me the way that we can highlight the task in column A? 😬

[@MyOnlineTrainingHub]

Glad you found it helpful. Not sure what the conditions are for highlighting a task. Please post your question and sample Excel file on our forum where someone can help you further: www.myonlinetraininghub.com/excel-forum

[@magsarjavbolor5305]

Condition is the same as the one that you did on the video 😬 if the task is overdue, i want that task to be highlighted as well.

[@MyOnlineTrainingHub]

I don't have time to do it right now, but this video teaches you how to write conditional formatting formulas: kzbin.info/www/bejne/iKvdaoOvm9ycjLM

[@ibugurudyah]

Thank you, it's very useful...

[@MyOnlineTrainingHub]

Glad to hear that 😊

[@arbazahmad7177]

Great and easy to make 👌 Thanks

[@MyOnlineTrainingHub]

Great to hear!

[@szadzik53]

Wonderful. Very useful tutorial.

[@MyOnlineTrainingHub]

Thank you! Cheers!

[@karlamartin123]

Hello, do you have a video or tutorial on how to set up task dependencies within an excel worksheet?

[@MyOnlineTrainingHub]

No, I don't sorry.

[@fjrxj1134]

Amazing, many thanks just want I needed.

[@MyOnlineTrainingHub]

Glad it helped!

[@diamondsandlipgloss]

this is exactly what i need since i don't have a power project license

[@MyOnlineTrainingHub]

So pleased you can make use of it!

[@srizki]

Thank you Mynda, I learned a lot from your videos. I have a question, why did you use 'isblanck", instead of =IF(B5 = " ", " ", ....

[@MyOnlineTrainingHub]

Great to hear 🙏 No reason for using ISBLANK instead of ="" Use whichever you prefer.

[@srizki]

@@MyOnlineTrainingHub Thank you, Mynda.

[@colinwheatley387]

Great video Mynda, however, is there a week function rather than days? Just so you can compress the Gantt field of view..

[@MyOnlineTrainingHub]

Not a week function as such, but you can change the formula to calculate based on weeks. I don't have an example file, but you can post your question and sample Excel file on our forum where we can help you further: www.myonlinetraininghub.com/excel-forum

[@mt3690]

Hello Mynda, I am having trouble for the formula if my completed days are in the same column as the estimated days since I want to show to bar graph for estimated and completed in parallel. Thank you in advance.

[@MyOnlineTrainingHub]

I recommend you separate the completed days and estimated days into separate columns to facilitate the graph.

[@Fredick.7]

🙂...Genial, gracias por compartir estos muy interesantes aportes. Me suscribí desde que vi tu primer video ....👍

[@MyOnlineTrainingHub]

Mucho gracias!

[@christopherjohndavis5882]

Hi Mynda, I came across your videos on KZbin and think they are brilliant. I am trying to build a maintenance schedule and have a start date but in some cases the maintenance can be fortnightly, monthly, quarterly, 6 monthly and annual depending on the task. I assume that this is something similar to a Gantt chart. do you have a tutorial that you can point me to please and thankyou for everything so far Love it.

[@MyOnlineTrainingHub]

Glad you've found my tutorials helpful 🙏 I don't have anything like you describe, but if you get stuck implementing it, you're welcome to post your question and sample Excel file on our forum where someone can help you further: www.myonlinetraininghub.com/excel-forum

[@vivekanandareddy1134]

AND(ISNUMBER(B2),LEFT(CELL("format",B2),1)="D") I am using this formula as conditional for to restrict data other than date. But the thing is that this condition is not working online mode, it shows an error. So can you help me on this. I want to restrict a column to enter date only.

[@MyOnlineTrainingHub]

The CELL function isn't available online. I'm not sure how you could do this another way off the top of my head, but if you post your question and sample Excel file on our forum we can help you further: www.myonlinetraininghub.com/excel-forum

[@Jakeu1701]

the portion of the first formula will return the false condition every time. Simple example: =IF(ISBLANK(A2)="","True", "False") is incorrect. To have the formula work correctly, it should read =IF(ISBLANK(A3),"True", "False")

[@MyOnlineTrainingHub]

oops, yes I had a moment writing that formula! I think originally I had =IF(B5="",... and then decided to use ISBLANK but forgot to remove the ="" part. In my written tutorial I have: =IF(ISBLANK(B5),"",WORKDAY.INTL(B5-1,D5+E5,1))

[@Jakeu1701]

@@MyOnlineTrainingHub no worries. I use isblank all the time and noticed it. I pulled up Excel and tried it because I don't know everything and I've seen some formulas done differently than I would write them. Thanks for the reply. I like your videos and recommend them to others. Keep up the good work.

[@ibugurudyah]

Amazing

[@kletops46]

Wait.. what was that 'Double-Click' thing to Auto enter all the formatting data ?

[@MyOnlineTrainingHub]

Not sure at which point you mean, but I probably covered it in my double click tips video: kzbin.info/www/bejne/earYnXZ5gb14m8U

[@kletops46]

@@MyOnlineTrainingHub @ 01:58... I'll search for your Double Click tips. Thanks

[@MyOnlineTrainingHub]

Ah, that's double clicking the fill handle in the bottom right of the cell to copy down the formula. I still recommend watching my double click tips video linked to in my comment above though 😊

[@laimajanaudite2141]

I'm having issues with the formula. I put everything in however it doesn't highlight anything. Please help 🥺

[@MyOnlineTrainingHub]

Please post your question and sample Excel file on our forum where we can help you further: www.myonlinetraininghub.com/excel-forum

[@brightdaniel1830]

God bless, first to Comment

[@MyOnlineTrainingHub]

Thanks for watching!

[@brightdaniel1830]

Blessings from Nigeria

[@ibugurudyah]

@@brightdaniel1830 well

[@brightdaniel1830]

@Dyah Hastuti, greetings

[@tasmisa6778]

did anyone even try? i couldn't even make it to the completion date frst line

[@MyOnlineTrainingHub]

If you're stuck, please post your question and sample Excel file on our forum where someone can help you further: www.myonlinetraininghub.com/excel-forum

[@MiRofek]

Not useful at all... (just kidding). Excellent tutorial (as always) 😊

[@MyOnlineTrainingHub]

😁 phew! Glad you liked it.

[@daisypowell2555]

Hello Mynda, I've created a Gantt Chart, however, i have a problem in the formula [=IF(H16>=1, WORKDAY.INTL(I16, INT(H16), "0000011") + IF(MOD(H16,(INT(H16)))>=1, TIME(12, 0, 0), 0), WORKDAY.INTL(I16, INT(H16), "0000011") + IF(H16>=1, TIME(12, 0, 0), 0))]. Here the Col. H is duration, Col. I start date, end date is calculated in Col. J. Now the issue is when the task requires 1 day to complete instead of the output result being the same day, it is taking an extra day and resulting in the next day as end date. I need the end date to be the same day, similarly if the task requires 2 days and the start day falls on a Friday, the end date should be the following Monday, which excludes the weekends. Pls help

[@MyOnlineTrainingHub]

Please post your question and Excel file on our forum where someone can help you further: www.myonlinetraininghub.com/excel-forum