![The Excel Challenge](/img/default-banner.jpg)
- Видео 18
- Просмотров 5 434 263
The Excel Challenge
Добавлен 15 сен 2016
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 RUclips 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
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 RUclips 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
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 ...
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
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! 😀
Amazzzzing, so simple and easy to follow, but the last step (the copy and then Ctrl + R) does not work. thank you soo much
When you made the timeline how did you extend you're dates to the end of the month?
Thank you, You have explained very simply 👌👍
Thank you so much this is a great explanation and it helped me a lot! 👍🏻