The Excel Challenge

The Excel Challenge

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

Пікірлер

  • @suchitrasart2249
    @suchitrasart2249Күн бұрын

    Can you please share this exact free excel template to me😢

  • @md.jahirulislam7787
    @md.jahirulislam77874 күн бұрын

    Great job! Thanks

  • @sheramaymarquino856
    @sheramaymarquino8567 күн бұрын

    how about if i needed to rank the lowest sales?

  • @rmcantrell85
    @rmcantrell857 күн бұрын

    Thank you!

  • @rondoncoballes994
    @rondoncoballes99417 күн бұрын

    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

  • @bblurker2
    @bblurker217 күн бұрын

    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).

  • @sagnikbiswas9655
    @sagnikbiswas965529 күн бұрын

    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??

  • @hiamkace171
    @hiamkace17129 күн бұрын

    This is amazing bro, thanks a lot.

  • @TormkohFamousKwame
    @TormkohFamousKwameАй бұрын

    Am trying the formula but isn't working for me. Please help

  • @lehlohonololemphane124
    @lehlohonololemphane124Ай бұрын

    Wow nice

  • @TormkohFamousKwame
    @TormkohFamousKwameАй бұрын

    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

  • @mehrnooshyaghmori
    @mehrnooshyaghmoriАй бұрын

    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?

  • @Rogers_trouble_fighter
    @Rogers_trouble_fighterАй бұрын

    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

  • @Shumon23
    @Shumon23Ай бұрын

    How can I select All Bar? I faced difficulty at this stage

  • @anjuy8413
    @anjuy8413Ай бұрын

    Thank you so much for the simple and clear explanation. God bless you

  • @ermieguese9759
    @ermieguese9759Ай бұрын

    How to remove weekends & holidays ing gantt chart?

  • @abidaliqasim1209
    @abidaliqasim1209Ай бұрын

    great thanks 🎉

  • @moujammalhoque3295
    @moujammalhoque3295Ай бұрын

    Can I your phone number

  • @ermieguese9759
    @ermieguese9759Ай бұрын

    such a great tutorial. keep it up. thank you very much

  • @senitertushabe9614
    @senitertushabe9614Ай бұрын

    Can some one please help me type me the IF formula am honestly stuck

  • @bretttabanas3855
    @bretttabanas3855Ай бұрын

    Hello, is it possible to plot 2 schedules in 1 gantt chart ? 1st is the master plan ? and 2nd is the sub plan.

  • @GCHandle
    @GCHandle2 ай бұрын

    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?

  • @TheExcelChallenge
    @TheExcelChallenge2 ай бұрын

    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

  • @alexiscolonlopez9282
    @alexiscolonlopez92822 ай бұрын

    A million thank yous for this video. This quick process has cut down on my presentation prep by a lot. Thank you again!!

  • @md.shahidakhtar6503
    @md.shahidakhtar65032 ай бұрын

    It was owesome...

  • @justforlaughs12310
    @justforlaughs123102 ай бұрын

    You are a life saver bro! Thank you so much

  • @aholycalling
    @aholycalling2 ай бұрын

    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!

  • @TheExcelChallenge
    @TheExcelChallenge2 ай бұрын

    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

  • @lateeckabhosekar4576
    @lateeckabhosekar45762 ай бұрын

    Thank you very much

  • @simatapalu8017
    @simatapalu80172 ай бұрын

    Very useful and easy to follow (slowly ofc lol). Thank you!

  • @eikky2
    @eikky23 ай бұрын

    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?

  • @prayuttoalaithet2096
    @prayuttoalaithet20963 ай бұрын

    Thank you Clip. It make me Bright.

  • @nathandrake3752
    @nathandrake37523 ай бұрын

    This has just helped me out so much! Thank you!

  • @phirojshaikh5720
    @phirojshaikh57203 ай бұрын

    Nice

  • @MarySelly1809
    @MarySelly18093 ай бұрын

    This helped me so so much !! Thank youu

  • @noeno17
    @noeno173 ай бұрын

    What would be a good way to cross off the days as the month goes on?

  • @rosapadilla1009
    @rosapadilla10093 ай бұрын

    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

  • @enobakhareosarugue1162
    @enobakhareosarugue11624 ай бұрын

    This is awesome

  • @JustFun257
    @JustFun2574 ай бұрын

    Thank you so much for making things simple in a straight forward ways .

  • @misspaulaalexandra
    @misspaulaalexandra4 ай бұрын

    Can you do a monthly timeline, i try to it with your instruction, it didnt work, I learnt so much from this video

  • @SeekerFitness
    @SeekerFitness4 ай бұрын

    is there an easier way to do this, ie in google calendar or outlook calendar?

  • @vikaschikane4179
    @vikaschikane41794 ай бұрын

    After changing days in task duration, my timeline is not changing. Am I missing anything? Can anybody please explain?

  • @jackieo7113
    @jackieo71134 ай бұрын

    This is soooooooo cool!

  • @user-hz9rc6gv9u
    @user-hz9rc6gv9u4 ай бұрын

    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.

  • @TheExcelChallenge
    @TheExcelChallenge4 ай бұрын

    Let me check it out. I’ve never heard of that error. Thanks for watching. T-E-CH

  • @maltoblaxkilyofas1026
    @maltoblaxkilyofas10264 ай бұрын

    Please how do you lock the columns

  • @TheExcelChallenge
    @TheExcelChallenge4 ай бұрын

    Simply add a $ sign next to the column, for example: to lock column A, type $A. Thanks for watching T-E-CH

  • @nymak-td8gy
    @nymak-td8gy4 ай бұрын

    ដូកម្មវិធីវិញដាកកម្មវិធីទៀងសារ៉ាត់ចូលវិញទាំងអស់ដោនឡោតយកកម្មវិធីរបស់ខ្លួនអែងវិញ

  • @ciai7317
    @ciai73174 ай бұрын

    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?

  • @josephflaviantarimo6376
    @josephflaviantarimo63764 ай бұрын

    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...?

  • @senitacraigen9480
    @senitacraigen94804 ай бұрын

    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?

  • @AR-hj6vx
    @AR-hj6vx4 ай бұрын

    Fantastic ❤

  • @touhidurr855
    @touhidurr8554 ай бұрын

    Great! Excellent work!

  • @alexaencasa1024
    @alexaencasa10245 ай бұрын

    Gracias! 😀