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
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!
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.
Excellent as always, Mynda. Thank you very much for sharing such valuable knowledge that results in a profound improvement of our professional development.
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
I don't have time to do it right now, but this video teaches you how to write conditional formatting formulas: th-cam.com/video/Rzz9PyfwiVQ/w-d-xo.html
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.
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.
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
Hi Mynda, I came across your videos on TH-cam 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.
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
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")
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))
@@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.
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.
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.
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
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 😊
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
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
![Model Driven Power Apps FULL COURSE for Beginners [UPDATED 2024 Edition]](http://i.ytimg.com/vi/HrILchHvMUA/mqdefault.jpg)
I had used this technique before. But yours have lots of layers. Thanks for sharing. Loved it.
Awesome! Thank you!
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
Glad it was helpful 😊
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!
😂glad you find my videos helpful!
Good approach to conditional formatting in a Gantt chart. Thank you very much Mynda. The issues of the channel are very practical.
Glad you like them!
Great tutorial, this is better than buying MS Project and it integrates better into program management dashboards.
Glad it was helpful!
Truly an amazing method to use Gantt Chart in Excel.
Glad it was helpful!
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.
Great to hear, Steve!
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.
Yes, Names would be helpful indeed!
Amazing as always Mynda! Thanks a lot! 👏👏👏
Thanks for watching!
Excellent Mynda! Thank you!
Glad you liked it 😊
your videos help me a lot thank you very much. I also share your videos to collegues also. You are very talented.
Thanks so much for your support 🙏
Very Cool. Enjoyed this example for project management visualization
Great to hear! You'll love my Project Management Dashboard then: th-cam.com/video/VU4ncBR0PYw/w-d-xo.html
Great stuff, thanks Mynda!
My pleasure!
u re awesome and really appreciate that you are sharing such brilliant knowledge... you always make my day
Thank you so much 😀
Thanks Mynda! I've used something similar before but I like yours a bit better.
Glad you liked it, Chris!
Dear Mynda, it looks absolutely fantastic!
Would use that at work.
Great to hear!
this is exactly what i need since i don't have a power project license
So pleased you can make use of it!
Excellent as always, Mynda. Thank you very much for sharing such valuable knowledge that results in a profound improvement of our professional development.
You are so welcome!
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? 😬
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
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.
I don't have time to do it right now, but this video teaches you how to write conditional formatting formulas: th-cam.com/video/Rzz9PyfwiVQ/w-d-xo.html
Thank you for this great tutorial
You're very welcome!
Amazing information, Thanks Mam
My pleasure!
Great and easy to make 👌 Thanks
Great to hear!
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.
Nice idea, Adam. I can see that being useful if you need to count results.
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.
Thanks for your kind words 🙏
Hi Mynda!Really Great Tutorial,Will Definitely Be Trying This Cool Technique Out...Thank You :)
Great to hear, Darryl!
Wonderful. Very useful tutorial.
Thank you! Cheers!
Amazing, many thanks just want I needed.
Glad it helped!
Thank you, it's very useful...
Glad to hear that 😊
Great video Mynda, however, is there a week function rather than days? Just so you can compress the Gantt field of view..
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
Hello, do you have a video or tutorial on how to set up task dependencies within an excel worksheet?
No, I don't sorry.
Thank you Mynda, I learned a lot from your videos. I have a question, why did you use 'isblanck", instead of =IF(B5 = " ", " ", ....
Great to hear 🙏 No reason for using ISBLANK instead of ="" Use whichever you prefer.
@@MyOnlineTrainingHub Thank you, Mynda.
Hi Mynda, I came across your videos on TH-cam 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.
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
🙂...Genial, gracias por compartir estos muy interesantes aportes. Me suscribí desde que vi tu primer video ....👍
Mucho gracias!
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")
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))
@@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.
Amazing
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.
I recommend you separate the completed days and estimated days into separate columns to facilitate the graph.
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.
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
Wait.. what was that 'Double-Click' thing to Auto enter all the formatting data ?
Not sure at which point you mean, but I probably covered it in my double click tips video: th-cam.com/video/CyulCCLXEec/w-d-xo.html
@@MyOnlineTrainingHub @ 01:58...
I'll search for your Double Click tips.
Thanks
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 😊
I'm having issues with the formula. I put everything in however it doesn't highlight anything. Please help 🥺
Please post your question and sample Excel file on our forum where we can help you further: www.myonlinetraininghub.com/excel-forum
God bless, first to Comment
Thanks for watching!
Blessings from Nigeria
@@brightdaniel1830 well
@Dyah Hastuti, greetings
did anyone even try? i couldn't even make it to the completion date frst line
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
Not useful at all... (just kidding). Excellent tutorial (as always) 😊
😁 phew! Glad you liked it.
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
Please post your question and Excel file on our forum where someone can help you further: www.myonlinetraininghub.com/excel-forum