The Excel Challenge
The Excel Challenge
  • Видео 18
  • Просмотров 5 434 263
TECH-018 - Compare Estimated Time vs Actual Time in a Time Line (Gantt Chart) in Excel
YOU CAN DOWNLOAD ALL MY FILES FOR FREE AT www.theexcelchallenge.com
Learn how to compare Estimated Time vs Actual Time in a quick and simple Time Line (Gantt Chart) in Excel.
In a previous video I showed how to create a quick and simple Time Line (Gantt Chart) in Excel and here is the link to that video: ruclips.net/video/00s5efQWrgU/видео.html
In this video I continued where I left off in the previous one, and I used the IF formula, the AND formula, as well as 'Greater Than' and 'Less Than' conditions to create the Actual Time Line (Gantt Chart) in your spreadsheet. I also used Conditional Formatting to enhance the looks of the Time Line.
I hope this concept is something you can use in your ...
Просмотров: 271 153

Видео

TECH-017 - Create a presentation in Excel and navigate through it like a website
Просмотров 140 тыс.6 лет назад
YOU CAN DOWNLOAD ALL MY FILES FOR FREE AT www.theexcelchallenge.com Learn how to create a spreadsheet that you can navigate through the same way you do in a website. Prepare your presentation in Excel in case you are going to be modifying data and you do not want to be going back and forth from and to power point. For this exercise we will be using hyperlinks. I highly recommend you check out o...
TECH-016 - Create a countdown calendar and combine it with conditional formatting for each task
Просмотров 61 тыс.6 лет назад
YOU CAN DOWNLOAD ALL MY FILES FOR FREE AT www.theexcelchallenge.com Learn how to create a countdown calendar that allows you to know the days left to a specific date. You will also learn how to combine the countdown calendar with cells that have conditional formatting according to the countdown. The cells can be modified, and the conditional formatting remained untouched. Both the countdown cal...
TECH-015 - Count total days by day of the week in a calendar in Excel
Просмотров 10 тыс.6 лет назад
YOU CAN DOWNLOAD ALL MY FILES FOR FREE AT www.theexcelchallenge.com Learn how to count total days by day of the week in a calendar in Excel and how to sum a total value if a value is assigned to each day of the week. You will use the WEEKDAY formula, the VLOOKUP formula, the COUNT formula and the SUM formula, plus other regular Excel tips and tricks. This is a video that shows the answer to one...
TECH-014 - Create a progress tracker with check boxes in Excel
Просмотров 480 тыс.6 лет назад
YOU CAN DOWNLOAD ALL MY FILES FOR FREE AT www.theexcelchallenge.com Learn a quick trick to create a progress tracker in Excel with check boxes. I hope this concept is something you can use in your daily routine so you get more with less effort. If you have an Excel challenge that you need help with, whether it is at work, at home, or at school, please write it in the comments below. I try to re...
TECH-013 - Create a bar chart with conditional formatting in Excel
Просмотров 78 тыс.6 лет назад
YOU CAN DOWNLOAD ALL MY FILES FOR FREE AT www.theexcelchallenge.com Learn a quick way to put a conditional format to your charts using the IF formula, and the "greater than" and "less than" conditions. I hope this concept is something you can use in your daily routine so you get more with less effort. If you have an Excel challenge that you need help with, whether it is at work, at home, or at ...
TECH-012 - Create links in Excel to places within your spreadsheet and outside of your spreadsheet
Просмотров 10 тыс.7 лет назад
YOU CAN DOWNLOAD ALL MY FILES FOR FREE AT www.theexcelchallenge.com Learn a quick way to insert links (also known as hyperlinks) in Excel to places within your spreadsheet and to places outside of your spreadsheet. Learn how to insert links using the right-click menu, the ribbon, and the shortcut Ctrl K. Learn how cells are created by the intersections of rows and columns and how those cells ar...
TECH-011 - Create a calendar in Excel that automatically updates colors by event category
Просмотров 865 тыс.7 лет назад
YOU CAN DOWNLOAD ALL MY FILES FOR FREE AT www.theexcelchallenge.com Learn a quick trick to automatically change the event colors in your calendar, accordingly to the text you are entering in the different cells. You will use simple concepts like autofill, select all, and conditional formatting. I hope this trick is something you can use in your projects so you get more with less effort. If you ...
TECH-010 - Fill several blank cells (empty cells) all at once
Просмотров 5 тыс.7 лет назад
YOU CAN DOWNLOAD ALL MY FILES FOR FREE AT www.theexcelchallenge.com Learn a quick trick to fill out several blank cells (empty cells) all at once by using the Replace command. It can be annoying for the reader of your information to see blank cells, only causing the reader to wonder whether the values are actually zeros, or are actually "not applicable", or the cells were left blank by mistake....
TECH-009 - Create a TOP 5 Chart (Pareto) in Excel that updates and sorts automatically
Просмотров 41 тыс.7 лет назад
YOU CAN DOWNLOAD ALL MY FILES FOR FREE AT www.theexcelchallenge.com Learn how to create a Top 5 Chart (or a Pareto Chart) that automatically updates and sorts data (descending) as you enter the data in Excel. In this video you will use the SUM formula, the COUNTIF formula, the MATCH formula, the INDEX formula, the RANK.EQ formula, as well as a Bar Chart, etc. I hope this tool is something you c...
TECH-008 - Create a bar chart with stacked images
Просмотров 10 тыс.7 лет назад
YOU CAN DOWNLOAD ALL MY FILES FOR FREE AT www.theexcelchallenge.com Learn how to create bar chart in Excel with stacked images. I hope you can use this example to come up with ideas of your own and you can use this tool in your daily routine so you get more with less effort. If you have a challenge with Excel that you need help with, whether it is at work, at home, or at school, please write it...
TECH-007 - Create a survey in Excel using Option Buttons (a.k.a. Radio Buttons)
Просмотров 97 тыс.7 лет назад
YOU CAN DOWNLOAD ALL MY FILES FOR FREE AT www.theexcelchallenge.com Learn how to create a survey in Excel using Option Buttons (a.k.a. Radio Buttons) and Group Boxes. In this video you will use the AVERAGE formula, Option Buttons (Radio Buttons), Group Boxes, etc. You will also activate your Developer tab in case it is not active in your Excel. I hope you can use this example to come up with id...
TECH-006 - Create a list that automatically sorts data (alphabetically) as you enter data in Excel
Просмотров 110 тыс.7 лет назад
YOU CAN DOWNLOAD ALL MY FILES FOR FREE AT www.theexcelchallenge.com Learn how to create a spreadsheet that automatically sorts data (alphabetically) as you enter data in Excel In this video you will use the COUNTIF formula, the MATCH formula, the INDEX formula, the IFERROR formula, as well as 'Less Than' conditions, etc. I hope this tool is something you can use in your daily routine so you get...
TECH-005 - Create a quick and simple Time Line (Gantt Chart) in Excel
Просмотров 3,2 млн7 лет назад
YOU CAN DOWNLOAD ALL MY FILES FOR FREE AT www.theexcelchallenge.com Learn how to create a quick and simple Time Line (Gantt Chart) in Excel. In this video you will use the MIN formula, the MAX formula, the IF formula, the AND formula, as well as 'Greater Than' and 'Less Than' conditions to create the Time Line (Gantt Chart) in your spreadsheet. You will also use Conditional Formatting to enhanc...
TECH-004 Calculate total days between two dates in Excel
Просмотров 15 тыс.7 лет назад
TECH-004 Calculate total days between two dates in Excel
TECH-003 - Insert images in comments in Excel
Просмотров 7 тыс.7 лет назад
TECH-003 - Insert images in comments in Excel
TECH-002 - Find a value in intersecting rows and columns in Excel
Просмотров 66 тыс.7 лет назад
TECH-002 - Find a value in intersecting rows and columns in Excel
TECH-001 - Compare data in charts selecting values from dropdown menus
Просмотров 13 тыс.7 лет назад
TECH-001 - Compare data in charts selecting values from dropdown menus

Комментарии

  • @rondoncoballes994
    @rondoncoballes994 3 дня назад

    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
    @bblurker2 3 дня назад

    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
    @sagnikbiswas9655 15 дней назад

    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
    @hiamkace171 16 дней назад

    This is amazing bro, thanks a lot.

  • @TormkohFamousKwame
    @TormkohFamousKwame 23 дня назад

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

  • @lehlohonololemphane124
    @lehlohonololemphane124 23 дня назад

    Wow nice

  • @TormkohFamousKwame
    @TormkohFamousKwame 26 дней назад

    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
    @GCHandle Месяц назад

    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
      @TheExcelChallenge Месяц назад

      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
    @alexiscolonlopez9282 Месяц назад

    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.shahidakhtar6503 Месяц назад

    It was owesome...

  • @justforlaughs12310
    @justforlaughs12310 2 месяца назад

    You are a life saver bro! Thank you so much

  • @aholycalling
    @aholycalling 2 месяца назад

    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
      @TheExcelChallenge 2 месяца назад

      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
    @lateeckabhosekar4576 2 месяца назад

    Thank you very much

  • @simatapalu8017
    @simatapalu8017 2 месяца назад

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

  • @eikky2
    @eikky2 2 месяца назад

    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
    @prayuttoalaithet2096 2 месяца назад

    Thank you Clip. It make me Bright.

  • @nathandrake3752
    @nathandrake3752 3 месяца назад

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

  • @phirojshaikh5720
    @phirojshaikh5720 3 месяца назад

    Nice

  • @MarySelly1809
    @MarySelly1809 3 месяца назад

    This helped me so so much !! Thank youu

  • @noeno17
    @noeno17 3 месяца назад

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

  • @rosapadilla1009
    @rosapadilla1009 3 месяца назад

    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
    @enobakhareosarugue1162 3 месяца назад

    This is awesome

  • @JustFun257
    @JustFun257 3 месяца назад

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

  • @misspaulaalexandra
    @misspaulaalexandra 3 месяца назад

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

  • @SeekerFitness
    @SeekerFitness 3 месяца назад

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

  • @vikaschikane4179
    @vikaschikane4179 4 месяца назад

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

  • @jackieo7113
    @jackieo7113 4 месяца назад

    This is soooooooo cool!

  • @user-hz9rc6gv9u
    @user-hz9rc6gv9u 4 месяца назад

    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
      @TheExcelChallenge 4 месяца назад

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

  • @maltoblaxkilyofas1026
    @maltoblaxkilyofas1026 4 месяца назад

    Please how do you lock the columns

    • @TheExcelChallenge
      @TheExcelChallenge 4 месяца назад

      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-td8gy 4 месяца назад

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

  • @ciai7317
    @ciai7317 4 месяца назад

    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
    @josephflaviantarimo6376 4 месяца назад

    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
    @senitacraigen9480 4 месяца назад

    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-hj6vx 4 месяца назад

    Fantastic ❤

  • @touhidurr855
    @touhidurr855 4 месяца назад

    Great! Excellent work!

  • @alexaencasa1024
    @alexaencasa1024 4 месяца назад

    Gracias! 😀

  • @user-gj7rl2wg8d
    @user-gj7rl2wg8d 4 месяца назад

    Amazzzzing, so simple and easy to follow, but the last step (the copy and then Ctrl + R) does not work. thank you soo much

  • @TerryMassengale
    @TerryMassengale 4 месяца назад

    When you made the timeline how did you extend you're dates to the end of the month?

  • @AkMusiclover-uw1xw
    @AkMusiclover-uw1xw 4 месяца назад

    Thank you, You have explained very simply 👌👍

  • @ghadiassiri
    @ghadiassiri 5 месяцев назад

    Thank you so much this is a great explanation and it helped me a lot! 👍🏻