In a fast-paced life, we're always looking for "time-savers" in order to increase our productivity and get more done in the least amount of time.
The Excel Challenge channel was created to share knowledge among the community of subscribers, by sharing tips utilizing the very popular and simple to use software Excel.
The Subscribers can send challenges they are facing in their day-to-day life and I will resolve the most common ones and share the solution in a KZread video.
It doesn't matter whether you are an engineer, an accountant, a student, a stay-at-home parent, etc., we all want to get more of our day, so in this channel I will try to help you by showing ways to automate tasks and replace tedious reports, etc. with formulas, macros, databases formatting, etc.
Excel is a great tool and it has many useful time-savers that not many people use, so we hope this channel is helpful, so you get more time in your life to do what you really enjoy doing.
The Excel Challenge
Пікірлер
Can you please share this exact free excel template to me😢
Great job! Thanks
how about if i needed to rank the lowest sales?
Thank you!
Hi sir, Your presentation is amazing but i notice something in your duration vs the number of bar which is not thesame for example in ID # 1 ,the duration is 4 but the bar showing is 5 which is not matching,what i did is i minus 1 in formula for the End date to have 4 bar .Thank you
Thank younfor this video. I have a comment about the duration of a task. For the duration you have to include the start date. So if a task starts at the first of may and the duration is 4 days, the end date is the third of may (and not the 4 of may as shown in rhis video).
The explanation was so straight forward and easy. Thanks a ton. Can you just tell me how can we add the condition in this formula itself where we can exclude the weekends on start dates and end dates so that our dates just fall on the weekdays??
This is amazing bro, thanks a lot.
Am trying the formula but isn't working for me. Please help
Wow nice
Thanks for this. But how best can you help me as a beginner? I have a project assignment for a duration of 15months. It's a construction project
That was perfect, thanks for teaching in a simple way, i have a question, is it possible to change the start day easily for each task separately just by typing simply the date or each time we have to change the code by sum the task duration + previous end date cell?
Oh thank you very much bro for the shot valuable and educative video. I am still thinking about how to establish the critical path on the schedule? Thank you very much
How can I select All Bar? I faced difficulty at this stage
Thank you so much for the simple and clear explanation. God bless you
How to remove weekends & holidays ing gantt chart?
great thanks 🎉
Can I your phone number
such a great tutorial. keep it up. thank you very much
Can some one please help me type me the IF formula am honestly stuck
Hello, is it possible to plot 2 schedules in 1 gantt chart ? 1st is the master plan ? and 2nd is the sub plan.
Excel is reading 2 days as three. 2 days…. 2/1 to 2/2 Excel is reading it as 2/1 to 2/3 I need it to count the first days as one. Is that possible?
Simply adjust the formulas to your needs: 2/1 to 2/3 can be considered three days (2/1, 2/2, 2/3) in some cases, or it can be considered two days from 2/1 to 2/3 in other cases. For that you can play with a +1, -1, etc. Just adjust per your needs. I hope that helps. Thank you for watching, T-E-CH
A million thank yous for this video. This quick process has cut down on my presentation prep by a lot. Thank you again!!
It was owesome...
You are a life saver bro! Thank you so much
Is there a way to autofill categories? I mean for example, gym every Wednesday filled in automatically in all months, or if I have volunteering only every first Sunday of the month, can I have that auto filled without me having to copy paste every time? Am trying to make a schedule for the whole year and it gets a lot if I have to copy paste every time over the weeks, months, years!
Hello @aholycalling. My recommendation would be that you create a first sheet (for example,one tab for one month) and format it the way you want it. After that, simply copy the tab, for example, for another 11 months and when you copy the tab, your format will be copied. I believe that’s probably the easiest way to achieve what you’re looking for. I hope that serves your needs. Thank you for your comment and thank you for watching. T-E-CH
Thank you very much
Very useful and easy to follow (slowly ofc lol). Thank you!
This was very helpfull and very short. I have a question, is the possibility that all the column can updated one row depending on how far is the date?
Thank you Clip. It make me Bright.
This has just helped me out so much! Thank you!
Nice
This helped me so so much !! Thank youu
What would be a good way to cross off the days as the month goes on?
Love this!! How would I convert this for customer service tracker? So, I would want to have this but then on another sheet I want only the progress bar? Everyone please chime in
This is awesome
Thank you so much for making things simple in a straight forward ways .
Can you do a monthly timeline, i try to it with your instruction, it didnt work, I learnt so much from this video
is there an easier way to do this, ie in google calendar or outlook calendar?
After changing days in task duration, my timeline is not changing. Am I missing anything? Can anybody please explain?
This is soooooooo cool!
Sir this formula is really helped us but only concern is Its not getting sort out when there is no proper Rank No. For example if there is no 3 no.(Rank) then the particular place shows ZERO.
Let me check it out. I’ve never heard of that error. Thanks for watching. T-E-CH
Please how do you lock the columns
Simply add a $ sign next to the column, for example: to lock column A, type $A. Thanks for watching T-E-CH
ដូកម្មវិធីវិញដាកកម្មវិធីទៀងសារ៉ាត់ចូលវិញទាំងអស់ដោនឡោតយកកម្មវិធីរបស់ខ្លួនអែងវិញ
Help please. The first row come out as one without any limit. The rest of the rows in the chat are good. What could I have done wrong. .... Anyone?
Hi..! Thanks for the interesting lesson. So what if instead of scheduling daily, I wish to schedule weekly? Say the project duration is 1 year, and I want to schedule it in 4 weeks, monthly...?
THIS WAS SOOOOOOOO HELPFUL! You can't imagine how happy I am to have been able to do this. And like the previous comment said, you were so succinct! Love it. 1 question though... My drag and drop formulas don't work. Will we have to do that manually when adding rows?
Fantastic ❤
Great! Excellent work!
Gracias! 😀