Тёмный
Vertex42
Vertex42
Vertex42
Подписаться
Spreadsheets are awesome and we want to help everybody learn how to use them. Vertex42 has been creating and providing professional spreadsheet templates since 2003. Our RU-vid channel provides demos and tutorials to help you use the templates. We are also creating tutorials to help you use both Excel and Google Sheets better.
How to Convert Excel to PDF
2:51
4 года назад
How to Make a Gantt Chart in Excel
12:54
4 года назад
Google Sheets Tutorial for Beginners
16:58
4 года назад
How to Use Flash Fill in Excel
6:10
4 года назад
Ghost in My Spreadsheet
1:29
4 года назад
How to use Shrink to Fit in Excel
1:45
4 года назад
How to Use AutoFill in Excel
2:47
4 года назад
How to Freeze Panes in Excel
1:24
4 года назад
Adding Columns to the Gantt Chart
2:06
5 лет назад
Money Management Spreadsheet Demo
3:03
6 лет назад
Home Mortgage Calculator Demo
3:57
6 лет назад
Create a Weekly Budget
7:28
6 лет назад
Комментарии
@crystennesseth3797
@crystennesseth3797 5 дней назад
Is there a way to exclude a day of the week or holidays from this?
@erika0626
@erika0626 5 дней назад
My question is, as you make payments do you change the balance and so on?
@user-mj8ry9wc6w
@user-mj8ry9wc6w 6 дней назад
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!
@unkownwalker8853
@unkownwalker8853 7 дней назад
How about ongoing, I want to make rhem ongoing
@praizeJC
@praizeJC 7 дней назад
Liked his skills and style to explain more than anything...
@amberjohnson6483
@amberjohnson6483 9 дней назад
Did not calculate correctly for me. I wish there was support.
@raheelzamir2597
@raheelzamir2597 10 дней назад
I was just in seeking of how to draw gantt chart but, you have teach alot in this video, thanks
@angelpantojacazares6071
@angelpantojacazares6071 12 дней назад
Thank you so much! It is a great video.
@BreannaAttipoe
@BreannaAttipoe 12 дней назад
I’m here beginning my snowball debt payoff including my house 🏠…thank you for the calculator!!!
@lesteradriatico5455
@lesteradriatico5455 14 дней назад
Do you have a free format?
@ThuyVuongThiNgoc
@ThuyVuongThiNgoc 15 дней назад
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?
@mwdasja1127
@mwdasja1127 15 дней назад
what a useful. Thanks for the video
@vertex42
@vertex42 17 дней назад
Working on a Part 2 video to address the most common question: how to handle weekends and non-work days
@prophetsamboateng3610
@prophetsamboateng3610 19 дней назад
How do I add a picture to it
@MattArma
@MattArma 23 дня назад
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.
@roulaal2617
@roulaal2617 24 дня назад
Excellent 👌!!! Thanks for sharing 🙏
@tonysong1106
@tonysong1106 26 дней назад
Instantly subscribed!
@oblj76
@oblj76 27 дней назад
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.
@benkimsem1
@benkimsem1 27 дней назад
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 ?
@meldoyle1476
@meldoyle1476 28 дней назад
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
@subhashisdas6232
@subhashisdas6232 29 дней назад
how do u adding F4 at 2.00 ?
@tarekmahmud7206
@tarekmahmud7206 29 дней назад
Your presentation is so good. You have ability to make complex subject easy to audience. Wish you a good health.
@kyse2
@kyse2 29 дней назад
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
@akaz50
@akaz50 Месяц назад
waw
@samuelbenson2381
@samuelbenson2381 Месяц назад
Wow
@LeFreak
@LeFreak Месяц назад
Thanks for this tutorial - really great. The text with tasks e.g. Task 1.1 in the bar chart is not using the indenting of row A - any ideas? the text is just aligned to the y-axis. This cannot be seen in your example because all tasks have the same name length
@katarinakrysmuller
@katarinakrysmuller Месяц назад
great video! I have one question, how would you configure the start/end dates to skip weekends & holidays?
@user-yr3hx8ft3o
@user-yr3hx8ft3o Месяц назад
this is great, How do i exclude weekends ?
@JustinFranzUy
@JustinFranzUy Месяц назад
Can I just say this is probably one of the best tutorial videos I've ever seen on youtube. Simple, easy to understand, straightforward, good video quality, not too long. It goes over each procedure in a way that is easy to understand and doesn't over explain. Learned so much from this one video. Thank you, I hope you make more videos in the future.
@brendanprice2780
@brendanprice2780 Месяц назад
You have got to be kidding me with this video. Are you sure you don't want to go over the origin of the pie?
@pradeepnair2119
@pradeepnair2119 Месяц назад
Very useFull❤❤❤❤
@najumshakeel225
@najumshakeel225 Месяц назад
Fantastic tutorial I use it as reference
@rachelnewby6940
@rachelnewby6940 Месяц назад
This is brilliant, but I must have missed something as the scroll function is only scrolling the first column and the rest are static.... argh!
@karlthefirst8690
@karlthefirst8690 Месяц назад
This video is incredible, THANK YOU. One question if anyone is still reading this thread: how can I add a 3rd and 4th phase or additional tasks within a phase without screwing up the formulas and formatting? Assuming there’s a way but I’m a total newbie to Sheets and can’t figure it out. Any help hugely appreciated, thank you!
@mysisthinksieathair4996
@mysisthinksieathair4996 Месяц назад
Is there a way to know where the position should be
@TheTeguhdinatazt
@TheTeguhdinatazt Месяц назад
very thankss to your channel and knowledge
@sana.maq1
@sana.maq1 Месяц назад
It is not picking my end date and the bar is extending to the end of the calendar. How to fix it.
@fienbon
@fienbon Месяц назад
Can you also represent a date in the GANTT if it is only one day?
@ManaChunsuttiwat
@ManaChunsuttiwat Месяц назад
You're amazing. This is the most helpful tutorial I've ever watched in my entire life. So effective and entertaining too. Thank you so much!!!
@andrewbrown1687
@andrewbrown1687 Месяц назад
This was incredibly helpful! Thank you so much!
@chicken29843
@chicken29843 Месяц назад
Audio is too fucking quiet you stupid fucking bitch
@MariaFernandaCelyMoreno
@MariaFernandaCelyMoreno 2 месяца назад
Hi guys, I applied the formula to make the timeline dynamic, however it doesn´t work well, when I change the display week only change the row with dates but not the complete data . Do you know what´s going on?
@rickglorie
@rickglorie 2 месяца назад
Fuuuuu. For non-english users; watch out with , used here, use ; instead.
@tootscarlson
@tootscarlson 2 месяца назад
The volume on this is so low - I noticed the same on other videos from this same source.
@adarshmehta5184
@adarshmehta5184 2 месяца назад
Need part 2
@munamacoffee
@munamacoffee 2 месяца назад
I need a help for my formula, I want color my column using conditional formating but exclude sunday and national holidays without reducing the number of working days, can you give me the right formula, please?
@aftabalam-qc7jh
@aftabalam-qc7jh 2 месяца назад
Very much useful videos
@kevin-mi2op
@kevin-mi2op 2 месяца назад
HOW TO TAKE PRINT FULL TEMPLATE
@jessjohnson6880
@jessjohnson6880 2 месяца назад
This was very helpful. Thank you.
@sureshsati7701
@sureshsati7701 2 месяца назад
Is * correct in the formula? If not correct, what is the correct one?