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 RU-vid 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.
Thanks for the video, explanation, and file download. i would like to understand, 1. how can i change it from days to weekly or Monthly status 2. how to remove off days i .e Saturdays and Sundays from overall timelines. the days column is want to change to weeks, as my projects duration is normally 3-4 months long and viewing no of days make the file view not acceptable.
I found this to be very helpful. However, I tried to work the unsorted data on one tab, and the sorted data on the next tab. I linked them very well upto the last point when empty spaces replace some names of values. I am stuck on this.
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.
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??
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
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
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
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
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.