Best one 🙏🏼

Thank you. this video saved my day

Excel.will be destroyed and accounting in future

God bless you,you just helped my soul in an assignment

Almost feel defeated. Great work! I am in awe

Thanks so much.

So easy to follow!! Thank you!

I don’t understand anything

This kind of Gantt chart is very useful, what do I need to make some modifications on it to change the duration units in hours , to use it in the weekly production plan , how could this be done ?

Extremely helpful. Thanks a lot, I will finish the series.

When i enter the overpayment, it just reduces the amount of future payments rather than reducing the term of the loan. What am i doing wrong?

Amazing tutorial ~ now I just need to practice !

All I can say is wow! Great job. A pleasure to watch.

Date of this vid is 4yo, this guy definitely has High Level skills to know how to make this Google Sheet so Responsive with no AI help

QUESTION. Do you change the DATE at the top of the worksheet on a monthly basis?

When I want to add the bars, the formula give me a error. it adds a plus before the second part of the formula. Any advice ?

Thank u❤

In the rate column, I take that this is APR divided by 12 since we are paying monthly??

I use this formula for fixing the problem in a process for making workdays as an input but excel doesn't take it as a formula, why its can be happen =AND(task_start<>'';H$5>=$D7;H$5<=$E7)

Very helpfull, i need 14 rows, how can i add it? thanks

❤ wow I've been doing things the hard way this is so awesome I'm happy I came across this

my progress colour started 2 days before the actual start days.. please help

Anyone in 2024

Straight to the point.... just learn it ... or leave it forever ... thank you sir

Thank you very much, you helped many of us.

Converting from boolean to 1's and 0's is where I got stuck. It kept returning FALSE and then 0 after adding 1* no matter what the progress is set to. I've tried other formulas for double negative formulas and I got the same results. I started that section over several times and followed the formula and steps exactly, afaik. Is there another way to set up conditional formatting for showing progress on the bar?

Is there a way to exclude a day of the week or holidays from this?

My question is, as you make payments do you change the balance and so on?

This is awesome! I have a bunch of software already for my company and really didn't want to add on another subscription just for scheduling. This is invaluable and will help me a ton in future projects thank you for posting such a great, comprehensive guide on building it!

How about ongoing, I want to make rhem ongoing

Liked his skills and style to explain more than anything...

Did not calculate correctly for me. I wish there was support.

I was just in seeking of how to draw gantt chart but, you have teach alot in this video, thanks

Thank you so much! It is a great video.

I’m here beginning my snowball debt payoff including my house 🏠…thank you for the calculator!!!

Do you have a free format?

thank you for your wonderful tutorial. Excellent and I really love it!!! Just 1 question: when the duration is plus 0.5, how do you calculate the right end date?

what a useful. Thanks for the video

Working on a Part 2 video to address the most common question: how to handle weekends and non-work days

How do I add a picture to it

How to exclude saturday and sunday in the bar? For example, if the duration is 6 then the result is 1 week plus 1 day because it excludes the sat and sun.

Excellent 👌!!! Thanks for sharing 🙏

Instantly subscribed!

Great work. However I cannot get the formula for progress bar to work. All I get displayed is "0". No "1". Not even changing the numbers in the progress bar does the trick.

hello, I want to give colour type of task, For example , Design = "D" and I want to my code, check it "D" for all dates and bar color is black for all D types. How can I do it ?

There are not enough categories... I need all the categories from version 1 to be added to version 2. Please give me step by step instructions to "Unhide the hidden rows in the Budget and Report worksheets if you need more categories" I need to add the 50 hidden rows to do so, please help. Thanks

how do u adding F4 at 2.00 ?

Your presentation is so good. You have ability to make complex subject easy to audience. Wish you a good health.

we need an updated video on this because my excel does not look like this 6 year old one and makes it really hard for me to follow it

waw