~~~~~FAQ~~~~~ It is unlikely I will have time to answer your specific questions about this video. I'll include some answers in this FAQ, but if you are stuck at some point in the video: (1) check formulas, (2) check references or (3) download the templates instead. 1] Q: What version of Excel are you using in this video? A: Microsoft 365 (Excel 2016/2019) 2] Q: How do I display weeks or months instead of days (+100 other ways of asking that)? A: Watch the rest of the videos in this video series or download the files that come with the Pro version of the gantt chart template on my website. www.vertex42.com/ExcelTips/how-to-make-a-gantt-chart-in-excel.html There are also templates on the construction template page with timelines based on months or weeks: www.vertex42.com/ExcelTemplates/construction-schedule.html 3] Q: What is the "Upper Left Cell in the Range" that is mentioned at 4:46? A: The range I'm talking about was selected at point 4:23 in the video, so the upper-left cell is E7. That means that your relative references within the formula should be created based on E7. That is why you use E$5, $B7 and $C7 when creating the formula. Column E and Row 7 are relative to cell E7 because they do not have the $ in front of them. Think of a conditional formatting rule as being "copied" to the other cells in the "Applies To" range, with relative and absolute references following the same rules for copying as when you create formulas within cells. 4] Q: Are there ways to show repeated/recurring tasks? A: Sure, create additional rows for each occurrence of the recurring task. In Part 2 of the video series, you'll see how to start creating dependencies between tasks (linking the start of one task to the end of another). Although it is possible to show recurring tasks on the same row (by creating a custom formula or CF rule), it becomes extremely complicated to create a dependency to a particular occurrence of a recurring task, unless each occurrence is on its own row with its own start and end date. So, although a lot of people like to show recurring project meetings, unless those meetings affect the timing of other tasks in the project, I would normally recommend leaving them off the gantt chart, or just making a note somewhere that says "Project Meetings: Every Tuesday at 10:00 am". 5] Regarding problems with the progress rule (referring to 11:18 in the video): Make sure that the formula is correct based on the upper-left cell in the Applies To range. Check for correct use of relative vs. absolute references. Make sure you are using the correct Applies To range. If all else fails, download the template. 6] Q: How can I show Planned vs. Actual? A: See this blog post from a while back: www.vertex42.com/blog/help/gantt-chart-help/actual-dates-vs-planned-dates-in-a-gantt-chart.html 7] Q: Can this be done in Google Sheets? A: Most of it. Watch this ... th-cam.com/video/8eKk0M2zGIk/w-d-xo.html 8] Q: How do I show delay or float time within the Gantt chart? A: See the answer to question #6. Another approach to show delay or float time as a different color is to create a new column for listing a second End Date. You'll then need to create a new conditional formatting rule that uses THAT end date instead of the original end date, and make sure that the new rule is listed AFTER the original rule in CF Rules Manager. See the following article if you need to learn more about conditional formatting: www.vertex42.com/blog/excel-tips/how-to-use-conditional-formatting-in-excel.html 9] Q: How do I add Milestones to the Gantt chart? Method 1: Watch the rest of the videos in the series, especially the one about using different colors for the bars, and then use a specific color for milestones (black is commonly used). Method 2 (really advanced): If you want a black diamond ◆ to show as a milestone, you can use your own formulas and custom number formatting and the black diamond unicode character. I don't have a video demonstrating this, but the latest version of Gantt Chart Template Pro includes an example. 10] Q: I can't get the conditional formatting to work. What am I doing wrong? A: Here is the process for resolving problems with conditional formatting ... (1) Check your Applies To range (2) Check that every reference in your formula is based on or relative to the upper left cell in your Applies To range (3) Check the formula (4) Download the template instead. 11] Q: Can you please slow down? A: The video was intentionally created to fit a LOT of stuff in a short time. It is expected that you'll need to pause very frequently or even rewind as needed if you want to ponder, and especially if you want to follow along in Excel. Note that I never said that this video would show you how to create your own Gantt chart in 13 minutes. It took me FAR longer to create than that, and even if you follow along exactly, it could take a few hours. I didn't originally design the video to be a follow-along tutorial, but rather a quick demo of some advanced techniques for intermediate and advanced Excel users, so a huge congratulations to those people who have commented and said they were able to create their own chart just from the tutorial (rather than downloading the template). 12] Q: Add 2:00 how do you link cell E2 to B1? A: Select cell E2 and type "=B1" then Enter (don't type the quotes). Google "how to create a formula in Excel" for more info. What you are doing here is creating a formula in cell E2 that returns the value in cell B1.
i would like know if he can make the gantt chart in hours, rather than no of days. some projects are short and are calculated in hours. thanks for the excellent explanations
I've considered myself above average at Excel for some time. after watching this 1st video of the series, I put myself a lot floors down. What a great class. Thanks.
I too had the same feeling. This is why they say, be humble because everything you think that you understood is just a misunderstanding. There is a long way to go. This video is mesmerizing. Hats off and great to know the possibilities of Excel, as common people like me are just scratching the surface since quite sometime.
@Ot Chuckm This was great, thanks, I have been researching "how do you write current status of a project?" for a while now, and I think this has helped. Ever heard of - Peyictorier Imaginative Preeminence - (Have a quick look on google cant remember the place now ) ? It is an awesome one of a kind product for getting useful project management and business templates minus the headache. Ive heard some unbelievable things about it and my partner got cool results with it.
My eyes have never seen such a profound execution of elegance and swagger...... and yes I know I'm talking about an Excel tutorial...and yes I am closing my laptop for the night to reevaluate my existence
I doubt you will see this, but I'm leading a very large project and I will using this and I just have to say. Thank you so much. I wish you all the success. Great narration, great to the point, not in your face. Please never change.
I'm far from an Excel expert. This was outstanding content. Simple. Straight-forward. Less than an hour to create. A HUGE time saver for my business. Many thanks!
The most productive and concise TH-cam I've ever watched. I followed the project through from beginning to end and produced the Gantt chart that I needed in my current work. It took me two hours of carefully following every step, but the results speak for themselves.
Excellent Video clip! Apologies for the intrusion, I am interested in your opinion. Have you ever tried - Teannah Psychic Sucker (search on google)? It is a good exclusive guide for finding the best project management and business templates minus the normal expense. Ive heard some interesting things about it and my cousin after many years got great success with it.
I've watched many videos about different things but this has got to be the easiest and clear-cut process to follow. Even someone who barely has 0 knowledge in excel can follow this
I just learned a ton, a metric ton. Your 12 min video has at least an hour of lessons in it for the average Excel user, and probably a week for a complete beginner. Thank you for putting this together and helping all of us "professionals " out. I will definitely be saving this as a template for future projects.
I love the ebb and flow of the video. It is not drawn out. I've learned a lot in a short time. I love the way you explain why you are using a particular function and that you incorporate short cuts. I didn't feel you were talking above my head. A lot of your tips are useful for my other projects. Just a great video! Thank you.
EXCELLENT! I am a below average Excel user and was blown away with this example of Gantt chart creation. A bit fast for me, but the cc and additional pop up controls helped. Would absolutely recommend
Great instruction!! Very clear and straight to the point! Two quick questions, 1. How do you add the Week # above the dates? 2. How do you add columns (for additional weeks)?
Had someone else make the gantt chart for a group project last year, I did NOT realise how difficult this could be. I've just spent 2 hours creating a rudimentary one thanks to you and I really appreciate what your doing here.
Great explanation and to the point! I love when people just tell you exactly how to do something and if I am unclear on a step i can always just look up that step myself or refer to another video. Not bogged down by explaining every little detail in a 2 hour video. Thank you, great job!
Watched it step by step, absolutely genius. Worked like a charm for my assignment. Putting his name as a stakeholder in my report, he deserves a mention for delivering such high-quality work :D
Same as the commentator Bruno, I also considered myself above average at Excel for quite some time, now you've given me a new bone to chew on :D Thank you very much sir
THANK YOU! Everyone said it... One of the direct-to-the-point tutorials I have ever watched! Please continue to make more videos like this with topic: Macros, Visual Basics and Dash boardings. Looking forward to them already. God bless you!
Hands down one of the best excel training videos I have seen! Clear, concise, articulate, practical with some great features! Well done! Thank you! An absolute pleasure to watch!
I Thought I knew a thing or two about excel but watching this video is like to be sitting at a Formula 1 race watching the cars at 200 mph!! Great information! Keep up this wondeful work!!
Your tutorial helped me finish a new team organization chart for the company that hired me as an intern. they loved it so much they are thinking about keeping me... thank you oh so much
great video @Vertex42. if you get stuck around 11:09 (show progress) when pasting the formula, make sure the (=) sign is not missing in the conditional formatting rule bar. took an hour to figure out. 2019 Excel Mac user here :)
Look I'm gonna be honest.... I was in a hurry to get a file like this done, I thought I could pull it out fast, but then I realized it'd take some time to do my own. I just went to the Excel templates options and downloaded the nicest template that was available... then I realized it was from Vertex42 !!! Amazing!! same one as in the video hahhaa thanks your help!!
Best one I’ve seen in Excel. Plus I’ve seen how to use conditional formatting much more effectively. I’ll have to watch slowly and follow along in my own sheet. Thanks!!!
Thanks! For more ideas on how to use conditional formatting, you can take a look at this article: www.vertex42.com/blog/excel-tips/how-to-use-conditional-formatting-in-excel.html
This video has been super cool to follow along! I haven't finished yet, but I'm working through each step and I got stuck at 2:05 where he's linking the project start date to the start of the chart. *For any Mac users like me:* You want to first click the cell with "1", then clear the cell and put an equal sign. THEN do FN + F4. If you just tap F4 it will keep taking you back to the launch pad. Hope that helps
Didn't learn anything new about Excel, but I did learn some fantastic ways to implement some very common techniques in very creative ways. Thank You. This was excellent.
I truly admire your work, that's by far one of the most helpful videos on TH-cam, I enjoyed each and every second of this redo, you've added a lot to my knowledge, people like you worth appreciation and I give it all to you man.
Aal Andi well, that would’ve certain gotten a lot more clicks. 😄 I don’t know MS Project and can’t afford it atm, so it’s interesting that you mention it’s similar so I can use it without having a missing feeling.
Learnt a "few new things"? More like I learnt a lot, as if I have never used Excel. Thank you for this video. Instructions are clear and easy to follow :)
I Don't Know by what Miracle, I ended up getting Vertex web and I have been enjoying it so much. God bless your effort and all your time spent on these amazing works.
This class has been an absolute game-changer! So many lessons packed with eye-opening insights. Huge thanks to the instructor for sharing such valuable knowledge! Can't wait to apply these lessons in real life.
Great Video, Even I've considered myself above average at Excel for most of the time, But the ocean is more to swim & practice, Thankyou very much for simple, crisp & made my life more easier
This is the most detailed, yet most impressive Gantt chart tutorial video I’ve seen. I will need to watch a good few times at slower speed and do a few tests before I can claim I’m competent enough
I've seen a few of these, as I'm trying to learn how to do this. Yours just explains it in the best, simplest way (for me). It's a grateful "like" from me.
this video is amazing, but one of the things that make it better is the music!! Can't remember howmany times I have fallen asleep during excel and coding videos on youtube !
Videos like this, though few, are what make my youtube addiction worthwhile. Super clear presentation, perfect pace, great basic practices (e.g. using names) and a polished result. Thanks!
Fantastic video. Really. This could take several hours to explain to beginners what to do, step by step, and explaining why. But this is perfect for those who only need to get it done and knows the basics. Even as an advanced user, I learned new things like "relative cell names", clever solution, and easy to replicate.
I thought I already knew how creat a gantt chart in excel, but you put me to shame! excel habilities, didactics, video edition... everything is perfect! congratulations! You gained a new subscriber
Your explanation calls for respect, very precise and to the point. Was very useful. For sure will be subscribing for more models like this. Thanks mate.
One of the most concise and clear Excel vids I've watched; I have been looking for a way to incorporate progress within the Gantt chart in Excel; lost a tad on the formula, but got it to work! Cheers to you!
This is truly one of THE most amazing and informative tutorial videos I have ever seen in my entire life!! You have saved me so much time and energy and allowed me to accomplish things that would have taken years of trial and error. Thank you!!
This is the Platinum standard, hands down, for instructional Videos! Well done and thanks so much for producing and sharing. From a content perspective, the process is clear, logical and simple. Presentation is focused on content rather than the presenter as with most instructional videos. AMAZING work.. Thank you.
I had never built anything from the ground floor and this made the whole process easy step by step even with modifications I needed. I am truly appreciative of the help this was!
Excellent video, I followed it step by step with my second screen and now have a fully working Gantt Chart! Wonderful, I shall be watching more of your videos that's for certain. Thank you
~~~~~FAQ~~~~~ It is unlikely I will have time to answer your specific questions about this video. I'll include some answers in this FAQ, but if you are stuck at some point in the video: (1) check formulas, (2) check references or (3) download the templates instead.
1] Q: What version of Excel are you using in this video? A: Microsoft 365 (Excel 2016/2019)
2] Q: How do I display weeks or months instead of days (+100 other ways of asking that)? A: Watch the rest of the videos in this video series or download the files that come with the Pro version of the gantt chart template on my website.
www.vertex42.com/ExcelTips/how-to-make-a-gantt-chart-in-excel.html
There are also templates on the construction template page with timelines based on months or weeks:
www.vertex42.com/ExcelTemplates/construction-schedule.html
3] Q: What is the "Upper Left Cell in the Range" that is mentioned at 4:46? A: The range I'm talking about was selected at point 4:23 in the video, so the upper-left cell is E7. That means that your relative references within the formula should be created based on E7. That is why you use E$5, $B7 and $C7 when creating the formula. Column E and Row 7 are relative to cell E7 because they do not have the $ in front of them. Think of a conditional formatting rule as being "copied" to the other cells in the "Applies To" range, with relative and absolute references following the same rules for copying as when you create formulas within cells.
4] Q: Are there ways to show repeated/recurring tasks? A: Sure, create additional rows for each occurrence of the recurring task. In Part 2 of the video series, you'll see how to start creating dependencies between tasks (linking the start of one task to the end of another). Although it is possible to show recurring tasks on the same row (by creating a custom formula or CF rule), it becomes extremely complicated to create a dependency to a particular occurrence of a recurring task, unless each occurrence is on its own row with its own start and end date. So, although a lot of people like to show recurring project meetings, unless those meetings affect the timing of other tasks in the project, I would normally recommend leaving them off the gantt chart, or just making a note somewhere that says "Project Meetings: Every Tuesday at 10:00 am".
5] Regarding problems with the progress rule (referring to 11:18 in the video): Make sure that the formula is correct based on the upper-left cell in the Applies To range. Check for correct use of relative vs. absolute references. Make sure you are using the correct Applies To range. If all else fails, download the template.
6] Q: How can I show Planned vs. Actual?
A: See this blog post from a while back: www.vertex42.com/blog/help/gantt-chart-help/actual-dates-vs-planned-dates-in-a-gantt-chart.html
7] Q: Can this be done in Google Sheets?
A: Most of it. Watch this ... th-cam.com/video/8eKk0M2zGIk/w-d-xo.html
8] Q: How do I show delay or float time within the Gantt chart? A: See the answer to question #6. Another approach to show delay or float time as a different color is to create a new column for listing a second End Date. You'll then need to create a new conditional formatting rule that uses THAT end date instead of the original end date, and make sure that the new rule is listed AFTER the original rule in CF Rules Manager. See the following article if you need to learn more about conditional formatting: www.vertex42.com/blog/excel-tips/how-to-use-conditional-formatting-in-excel.html
9] Q: How do I add Milestones to the Gantt chart? Method 1: Watch the rest of the videos in the series, especially the one about using different colors for the bars, and then use a specific color for milestones (black is commonly used). Method 2 (really advanced): If you want a black diamond ◆ to show as a milestone, you can use your own formulas and custom number formatting and the black diamond unicode character. I don't have a video demonstrating this, but the latest version of Gantt Chart Template Pro includes an example.
10] Q: I can't get the conditional formatting to work. What am I doing wrong? A: Here is the process for resolving problems with conditional formatting ... (1) Check your Applies To range (2) Check that every reference in your formula is based on or relative to the upper left cell in your Applies To range (3) Check the formula (4) Download the template instead.
11] Q: Can you please slow down? A: The video was intentionally created to fit a LOT of stuff in a short time. It is expected that you'll need to pause very frequently or even rewind as needed if you want to ponder, and especially if you want to follow along in Excel. Note that I never said that this video would show you how to create your own Gantt chart in 13 minutes. It took me FAR longer to create than that, and even if you follow along exactly, it could take a few hours. I didn't originally design the video to be a follow-along tutorial, but rather a quick demo of some advanced techniques for intermediate and advanced Excel users, so a huge congratulations to those people who have commented and said they were able to create their own chart just from the tutorial (rather than downloading the template).
12] Q: Add 2:00 how do you link cell E2 to B1? A: Select cell E2 and type "=B1" then Enter (don't type the quotes). Google "how to create a formula in Excel" for more info. What you are doing here is creating a formula in cell E2 that returns the value in cell B1.
It's absolutely brilliant. Thanks.
i would like know if he can make the gantt chart in hours, rather than no of days. some projects are short and are calculated in hours. thanks for the excellent explanations
@@VikranthKumar4246the simple step by step building of cells to a form functioning chart.
Can we make a chart on Week basis instead of days?
@@mpandya1 Yes. I'll be demonstrating that in a future video.,
I've considered myself above average at Excel for some time. after watching this 1st video of the series, I put myself a lot floors down. What a great class. Thanks.
Dude, I know! This guy humbled me greatly.
Exactly same , in my case also. 🤩
I have the same thing :)
I too had the same feeling. This is why they say, be humble because everything you think that you understood is just a misunderstanding. There is a long way to go.
This video is mesmerizing. Hats off and great to know the possibilities of Excel, as common people like me are just scratching the surface since quite sometime.
@@BalakrishnanNair68 well put
Hi there, this is the most phenomenal video on the Internet for making a gantt chart, no bs, straight to the point. Legend.
True!!!!
Amazing
@Ot Chuckm This was great, thanks, I have been researching "how do you write current status of a project?" for a while now, and I think this has helped. Ever heard of - Peyictorier Imaginative Preeminence - (Have a quick look on google cant remember the place now ) ? It is an awesome one of a kind product for getting useful project management and business templates minus the headache. Ive heard some unbelievable things about it and my partner got cool results with it.
totally right!!!! amazing video, straight to the point! great!
totally agree!!
My eyes have never seen such a profound execution of elegance and swagger...... and yes I know I'm talking about an Excel tutorial...and yes I am closing my laptop for the night to reevaluate my existence
how do you link the date to the project start?
@@LimeTJL do you find it
I doubt you will see this, but I'm leading a very large project and I will using this and I just have to say. Thank you so much. I wish you all the success. Great narration, great to the point, not in your face. Please never change.
I can only repeat was others have said: this is the most straight to the point, no BS tutorial I have ever seen on YT. Thank you! Great work.
I considered myself an above-average Excel user, but boy, was I humbled.
Thank you so much for sharing this!
Excellent!
this is a hell of a skill. just realise that i don't even imagine how powerful excell is
It's like watching Bob Ross paint. Great techniques explained well. The pause button will be needed as I study this closely. TY for sharing.
Liked his skills and style to explain more than anything...
Wow, I’m a PMP and I have to say this is world class skills on display for all to benefit from. Thank you!
Words cannot describe how happy I'm feeling after finding your video. You Sir take a bow.
Thank you!!
I'm far from an Excel expert. This was outstanding content. Simple. Straight-forward. Less than an hour to create. A HUGE time saver for my business. Many thanks!
I liked how you showed each step in details, even the keyboard shortcuts. Learnt a lot of new things from this.
I've never been so satisfied with using Excel until I watched your video, thank you so much 😩
All I can say is wow! Great job. A pleasure to watch.
The most productive and concise TH-cam I've ever watched. I followed the project through from beginning to end and produced the Gantt chart that I needed in my current work. It took me two hours of carefully following every step, but the results speak for themselves.
My exact sentiments. This was very helpful and I have a beautiful chart now.
Excellent Video clip! Apologies for the intrusion, I am interested in your opinion. Have you ever tried - Teannah Psychic Sucker (search on google)? It is a good exclusive guide for finding the best project management and business templates minus the normal expense. Ive heard some interesting things about it and my cousin after many years got great success with it.
can u please share with me on mail id (ganjoo.vipin@gmai.com)
This is the level of brevity which is needed in every tutorial. It should be a benchmark for making "How to" videos. Verry educative video.
Any one else with goosebumps -- Skill of the guy and Power of the Excel
how do you link the date to the project start?
I've watched many videos about different things but this has got to be the easiest and clear-cut process to follow. Even someone who barely has 0 knowledge in excel can follow this
I just learned a ton, a metric ton. Your 12 min video has at least an hour of lessons in it for the average Excel user, and probably a week for a complete beginner. Thank you for putting this together and helping all of us "professionals " out. I will definitely be saving this as a template for future projects.
Thank you!
Lost confidence on my excel knowledge. Hats off
ahahaha the same dude!
Your comment made my day 🤣
I love the ebb and flow of the video. It is not drawn out. I've learned a lot in a short time. I love the way you explain why you are using a particular function and that you incorporate short cuts. I didn't feel you were talking above my head. A lot of your tips are useful for my other projects. Just a great video! Thank you.
Thanks for the feedback.
EXCELLENT! I am a below average Excel user and was blown away with this example of Gantt chart creation. A bit fast for me, but the cc and additional pop up controls helped. Would absolutely recommend
Great instruction!! Very clear and straight to the point!
Two quick questions,
1. How do you add the Week # above the dates?
2. How do you add columns (for additional weeks)?
I used to think i am good at excel. Oh boy! This video made me humble. This is gem.
Same here. OMG 😮
Had someone else make the gantt chart for a group project last year, I did NOT realise how difficult this could be. I've just spent 2 hours creating a rudimentary one thanks to you and I really appreciate what your doing here.
This is the level of an Excel expert I aspire to be
The fact that you even divided into section make it even more clearer to learn...OMGGG Thank you so much it helps me a lot
Just made all the Gannt chart templates (2) I am going to need in this life from this one video. Thank you Mr. Wizard
This is absolutely the definitive tutorial to learn to do a chart-diagramm! Best way to endure the quarantene. All the best from Italy!
Great explanation and to the point! I love when people just tell you exactly how to do something and if I am unclear on a step i can always just look up that step myself or refer to another video. Not bogged down by explaining every little detail in a 2 hour video. Thank you, great job!
Watched it step by step, absolutely genius. Worked like a charm for my assignment. Putting his name as a stakeholder in my report, he deserves a mention for delivering such high-quality work :D
hahaha true
Each second,a new concept is brought,now understood the scope and power of excel,Wow man one hell of a video
Same as the commentator Bruno, I also considered myself above average at Excel for quite some time, now you've given me a new bone to chew on :D Thank you very much sir
Finally found a channel that teaches and not sells you a "membership", thank you!
Semper Fi
THANK YOU! Everyone said it... One of the direct-to-the-point tutorials I have ever watched! Please continue to make more videos like this with topic: Macros, Visual Basics and Dash boardings. Looking forward to them already. God bless you!
my excel knowledge, from previous 70%, after seeing this vedio become 0.1%
I've been using Excel since 1995, but this class is great! Thank you!
Straight to the point.... just learn it ... or leave it forever ... thank you sir
Not gonna lie I can’t keep up with this but i am absolutely amazed
same here...hit pause every 10 sec at my end :)
I have discovered the true Excel Jedi Master. Thank you!
Hands down one of the best excel training videos I have seen! Clear, concise, articulate, practical with some great features! Well done! Thank you! An absolute pleasure to watch!
I Thought I knew a thing or two about excel but watching this video is like to be sitting at a Formula 1 race watching the cars at 200 mph!! Great information! Keep up this wondeful work!!
Your tutorial helped me finish a new team organization chart for the company that hired me as an intern. they loved it so much they are thinking about keeping me... thank you oh so much
I use spreadsheets daily at work, but I still managed to learn quite a lot in this 12 min video. Truly masterclass - thank you!
honestly, forget being the best video on gantt charts
*this is best video on excel, ever*
Thank you! :-)
Phew, 6 hours later and I am an expert at Excel. Thank you
great video @Vertex42. if you get stuck around 11:09 (show progress) when pasting the formula, make sure the (=) sign is not missing in the conditional formatting rule bar. took an hour to figure out. 2019 Excel Mac user here :)
Look I'm gonna be honest.... I was in a hurry to get a file like this done, I thought I could pull it out fast, but then I realized it'd take some time to do my own. I just went to the Excel templates options and downloaded the nicest template that was available... then I realized it was from Vertex42 !!! Amazing!! same one as in the video hahhaa thanks your help!!
Best one I’ve seen in Excel. Plus I’ve seen how to use conditional formatting much more effectively. I’ll have to watch slowly and follow along in my own sheet. Thanks!!!
Thanks! For more ideas on how to use conditional formatting, you can take a look at this article: www.vertex42.com/blog/excel-tips/how-to-use-conditional-formatting-in-excel.html
This video has been super cool to follow along! I haven't finished yet, but I'm working through each step and I got stuck at 2:05 where he's linking the project start date to the start of the chart. *For any Mac users like me:* You want to first click the cell with "1", then clear the cell and put an equal sign. THEN do FN + F4. If you just tap F4 it will keep taking you back to the launch pad. Hope that helps
I am humbled. I thought I was pretty skilled with Excel. How wrong I was. This is a Masterclass.
I was thinking the same while watching this video, this is ART.
Wow; blown away. Starting using your template and wanted to understand how you built it. This takes Excel to another level!
Didn't learn anything new about Excel, but I did learn some fantastic ways to implement some very common techniques in very creative ways. Thank You. This was excellent.
I truly admire your work, that's by far one of the most helpful videos on TH-cam, I enjoyed each and every second of this redo, you've added a lot to my knowledge, people like you worth appreciation and I give it all to you man.
My dude. Thanks ever so much! You just saved my an unnecessary software subscription. Thank you!!!
The caption for this video should be "How use excel as MS. Project" ,,, Great Job
Aal Andi well, that would’ve certain gotten a lot more clicks. 😄 I don’t know MS Project and can’t afford it atm, so it’s interesting that you mention it’s similar so I can use it without having a missing feeling.
I just want to appreciate this video, you are like Dumbledore but for Ms.Excel. Thanks again for sharing this with public!
You're a lifesaver! Now im stuck to insert delays work on this magic sheets. Oh my oh myy. You're genius!
Learnt a "few new things"? More like I learnt a lot, as if I have never used Excel. Thank you for this video. Instructions are clear and easy to follow :)
This is one of the best excel tutorials I've ever come across...kudos to you, man. you deserve more views
I have a certificate of specialization in Microsoft Office and I feel like I should rip it up now. Great video!
I am a self-taught user of excel and trying to figure out what I need to know. Awesome video!
Wow I'm amazed that this content is even free. This is the best tutorial on Gantt chart ever. Thank you so much!
This tutorial about gantt chart is by far the best that I've watched!!! Keep it up! it's very easy to follow 😉
Fantastic! Impressed with "just to the point" content and focus on aesthetics
I Don't Know by what Miracle, I ended up getting Vertex web and I have been enjoying it so much. God bless your effort and all your time spent on these amazing works.
This class has been an absolute game-changer! So many lessons packed with eye-opening insights. Huge thanks to the instructor for sharing such valuable knowledge! Can't wait to apply these lessons in real life.
Great Video, Even I've considered myself above average at Excel for most of the time, But the ocean is more to swim & practice, Thankyou very much for simple, crisp & made my life more easier
This is the most detailed, yet most impressive Gantt chart tutorial video I’ve seen. I will need to watch a good few times at slower speed and do a few tests before I can claim I’m competent enough
Vertex42 please let us know when you get into Quantum physics. I will be the first one to learn it from you :) Great job!
Beauty. Didn’t know excel can be used this way too.
best Gantt chart ever! Top-notch tutorial too! I am just a little bit lost in the last part before the print setup. Still, the best!
I've seen a few of these, as I'm trying to learn how to do this. Yours just explains it in the best, simplest way (for me). It's a grateful "like" from me.
this video is amazing, but one of the things that make it better is the music!! Can't remember howmany times I have fallen asleep during excel and coding videos on youtube !
Well this knocked me down a peg or twelve, and somehow that's a compliment. Excellent video.
This video is an absolute gem! The instructions are concise and easy to follow. Thank you so much.
Videos like this, though few, are what make my youtube addiction worthwhile. Super clear presentation, perfect pace, great basic practices (e.g. using names) and a polished result. Thanks!
I once made a Gantt chart manually, it was so tedious. But this makes Gantt chart look so easy.
Fantastic video. Really.
This could take several hours to explain to beginners what to do, step by step, and explaining why. But this is perfect for those who only need to get it done and knows the basics.
Even as an advanced user, I learned new things like "relative cell names", clever solution, and easy to replicate.
Thank you for teaching me skills WHILE I learned how to do this.
Very Good demonstration of the GANTT Charts.
Keep up the good work.
From the start to the end, I learned a lot functionality. Thanks 🙏.
After min 3 I don't understand a thing about those formulas. This is awesome!
I thought I already knew how creat a gantt chart in excel, but you put me to shame! excel habilities, didactics, video edition... everything is perfect! congratulations! You gained a new subscriber
Amazing ..... I have always underestimated EXCEL
Your explanation calls for respect, very precise and to the point. Was very useful. For sure will be subscribing for more models like this. Thanks mate.
i thought i am average user, actually i am close to ZERO. thank you for the GREAT video. i learnt a lot.
Oh my god. This chart shown is level 100. Mind blown.
Your tutorial about this is timeless! 2024 and still it rocks! thank you so much for sharing your knowledge to us :)
One of the most concise and clear Excel vids I've watched; I have been looking for a way to incorporate progress within the Gantt chart in Excel; lost a tad on the formula, but got it to work! Cheers to you!
Not sure who 'disliked' this video. People unable to follow along, perhaps? This was gold standard material.
This is truly one of THE most amazing and informative tutorial videos I have ever seen in my entire life!! You have saved me so much time and energy and allowed me to accomplish things that would have taken years of trial and error. Thank you!!
This is the Platinum standard, hands down, for instructional Videos! Well done and thanks so much for producing and sharing.
From a content perspective, the process is clear, logical and simple. Presentation is focused on content rather than the presenter as with most instructional videos. AMAZING work.. Thank you.
Wow, thanks!
Absolutely loved this video. For an excel rookie like me, this is a God-send.
I now know which channel to follow to upgrade my knowledge of Excel...
This was so well done. I haven’t had a chance to explore naming or scroll bars yet so i learned a lot. Thanks.
I had never built anything from the ground floor and this made the whole process easy step by step even with modifications I needed. I am truly appreciative of the help this was!
This is exactly what I wanted thanks so much for sharing.
Excellent video, I followed it step by step with my second screen and now have a fully working Gantt Chart! Wonderful, I shall be watching more of your videos that's for certain. Thank you