Channel Title: The Excel Challenge Channel Description: 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 YouTube 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 <video> TECH-005 - Create a quick and simple Time Line (Gantt Chart) in Excel Description: YOU CAN DOWNLOAD ALL MY FILES FOR FREE AT http://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 enhance the looks of your Time Line. I hope this tool is something you can use 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 in the comments below. I try to resolve common Excel challenges from our viewers and subscribers. Thank you for watching. Check out some of our previous videos in the links below: * TECH-004 - Calculate total days between dates in Excel https://www.youtube.com/watch?v=5q_hBywbKys * TECH-003 - Display images in comments https://www.youtube.com/watch?v=nVdNMXp-bSU * TECH-002 - Find intersecting values in a table in Excel https://www.youtube.com/watch?v=UfvhhbMBDO8 </video> <video> TECH-015 - Count total days by day of the week in a calendar in Excel Description: YOU CAN DOWNLOAD ALL MY FILES FOR FREE AT http://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 of the challenges that one of our subscribers was facing. 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 resolve common Excel challenges from our viewers and subscribers. Thank you for watching. Check out some of our previous videos in the links below: * TECH-014 - Create a progress tracker with check box buttons in Excel https://www.youtube.com/watch?v=gbDKwYPC4MI&t=12s * TECH-013 - Create a bar chart with conditional formatting in Excel https://www.youtube.com/watch?v=HVo8lxtZtM0 * TECH-012 - Create links in Excel within your spreadsheet and outside of your spreadsheet https://www.youtube.com/watch?v=EE7pF1TQb7k&t=22s * TECH-011 - Create a calendar in Excel that automatically updates colors by event category https://www.youtube.com/watch?v=gt6vOwFShLM&t=69s </video> <video> TECH-017 - Create a presentation in Excel and navigate through it like a website Description: YOU CAN DOWNLOAD ALL MY FILES FOR FREE AT http://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 our previous video TECH-012 - Create links in Excel within your spreadsheet and outside of your spreadsheet https://www.youtube.com/watch?v=EE7pF1TQb7k&t=22s 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 resolve common Excel challenges from our viewers and subscribers. Thank you for watching. Check out some of our previous videos in the links below: * TECH-016 - Create a countdown calendar and combine it with conditional formatting for each task https://www.youtube.com/edit?o=U&video_id=KSHLjf9qo6M * TECH-015 - Count total days by day of the week in a calendar in Excel https://www.youtube.com/watch?v=1l1Bz7Nz9AE * TECH-014 - Create a progress tracker with check box buttons in Excel https://www.youtube.com/watch?v=gbDKwYPC4MI&t=12s * TECH-013 - Create a bar chart with conditional formatting in Excel https://www.youtube.com/watch?v=HVo8lxtZtM0 </video> <video> TECH-009 - Create a TOP 5 Chart (Pareto) in Excel that updates and sorts automatically Description: YOU CAN DOWNLOAD ALL MY FILES FOR FREE AT http://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 can use 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 in the comments below. I try to resolve common Excel challenges from our viewers and subscribers. Thank you for watching. Check out some of our previous videos in the links below: * TECH-008 - Create a chart with stacked pictures https://www.youtube.com/watch?v=K7bAL5tkSMw * TECH-007 - Create a survey in Excel using option buttons (a.k.a. radio buttons) https://www.youtube.com/watch?v=HnlmqZilcKU * TECH-006 - Create a list that automatically sorts alphabetically as you enter data https://www.youtube.com/watch?v=V_zd81h_4hY </video> <video> TECH-012 - Create links in Excel to places within your spreadsheet and outside of your spreadsheet Description: YOU CAN DOWNLOAD ALL MY FILES FOR FREE AT http://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 are used to refer from links. Insert links in cells, shapes, and/or pictures and other images. 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 resolve common Excel challenges from our viewers and subscribers. Thank you for watching. Check out some of our previous videos in the links below: * TECH-011 - Create a calendar in Excel that automatically updates colors by event category https://www.youtube.com/watch?v=gt6vOwFShLM&t=69s * TECH-010 - Fill several blank cells (empty cells) all at once https://www.youtube.com/watch?v=lToTs9q-9Ow&t=3s * TECH-009 - Create a TOP 5 chart (Pareto) that updates automatically https://www.youtube.com/watch?v=8jzHJ_kxxOA&t=15s </video> <video> TECH-014 - Create a progress tracker with check boxes in Excel Description: YOU CAN DOWNLOAD ALL MY FILES FOR FREE AT http://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 resolve common Excel challenges from our viewers and subscribers. Thank you for watching. Check out some of our previous videos in the links below: * TECH-013 - Create a bar chart with conditional formatting in Excel https://www.youtube.com/watch?v=HVo8lxtZtM0 * TECH-012 - Create links in Excel to places within your spreadsheet and outside of your spreadsheet https://www.youtube.com/watch?v=EE7pF1TQb7k&t=5s * TECH-011 - Create a calendar in Excel that automatically updates colors by event category https://www.youtube.com/watch?v=gt6vOwFShLM&t=69s </video> <video> TECH-011 - Create a calendar in Excel that automatically updates colors by event category Description: YOU CAN DOWNLOAD ALL MY FILES FOR FREE AT http://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 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 resolve common Excel challenges of our viewers and subscribers. Thank you for watching. Check out some of our previous videos in the links below: * TECH-010 - Fill several blank cells (empty cells) all at once https://www.youtube.com/watch?v=lToTs9q-9Ow&t=3s * TECH-009 - Create a TOP 5 chart (Pareto) that updates automatically https://www.youtube.com/watch?v=8jzHJ_kxxOA&t=15s * TECH-008 - Create a chart with stacked pictures https://www.youtube.com/watch?v=K7bAL5tkSMw </video> <video> TECH-007 - Create a survey in Excel using Option Buttons (a.k.a. Radio Buttons) Description: YOU CAN DOWNLOAD ALL MY FILES FOR FREE AT http://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 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 in the comments below. I try to resolve common Excel challenges from our viewers and subscribers. Thank you for watching. Check out some of our previous videos in the links below: * TECH-006 - Create a list that automatically sorts alphabetically as you enter data https://www.youtube.com/watch?v=V_zd81h_4hY * TECH-005 - Create a quick and simple Time Line (Gantt Chart) in Excel https://www.youtube.com/watch?v=00s5efQWrgU * TECH-004 - Calculate total days between dates in Excel https://www.youtube.com/watch?v=5q_hBywbKys </video> <video> TECH-013 - Create a bar chart with conditional formatting in Excel Description: YOU CAN DOWNLOAD ALL MY FILES FOR FREE AT http://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 school, please write it in the comments below. I try to resolve common Excel challenges from our viewers and subscribers. Thank you for watching. Check out some of our previous videos in the links below: * TECH-012 - Create links in Excel within your spreadsheet and outside of your spreadsheet https://www.youtube.com/watch?v=EE7pF1TQb7k&t=22s * TECH-011 - Create a calendar in Excel that automatically updates colors by event category https://www.youtube.com/watch?v=gt6vOwFShLM&t=69s * TECH-010 - Fill several blank cells (empty cells) all at once https://www.youtube.com/watch?v=lToTs9q-9Ow&t=3s </video> <video> The Excel Challenge Live Stream Description: </video> <video> TECH-008 - Create a bar chart with stacked images Description: YOU CAN DOWNLOAD ALL MY FILES FOR FREE AT http://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 in the comments below. I try to resolve common Excel challenges from our viewers and subscribers. Thank you for watching. Check out some of our previous videos in the links below: * TECH-007 - Create a survey in Excel using option buttons (a.k.a. radio buttons) https://www.youtube.com/watch?v=HnlmqZilcKU * TECH-006 - Create a list that automatically sorts alphabetically as you enter data https://www.youtube.com/watch?v=V_zd81h_4hY * TECH-005 - Create a quick and simple Time Line (Gantt Chart) in Excel https://www.youtube.com/watch?v=00s5efQWrgU </video> <video> TECH-016 - Create a countdown calendar and combine it with conditional formatting for each task Description: YOU CAN DOWNLOAD ALL MY FILES FOR FREE AT http://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 calendar and the conditional formatting pivot around the TODAY formula, which we use in this video. This video also shows an example of conditional formatting values vs. conditional formatting formulas. 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 resolve common Excel challenges from our viewers and subscribers. Thank you for watching. Check out some of our previous videos in the links below: * TECH-015 - Count total days by day of the week in a calendar in Excel https://www.youtube.com/watch?v=1l1Bz7Nz9AE * TECH-014 - Create a progress tracker with check box buttons in Excel https://www.youtube.com/watch?v=gbDKwYPC4MI&t=12s * TECH-013 - Create a bar chart with conditional formatting in Excel https://www.youtube.com/watch?v=HVo8lxtZtM0 * TECH-012 - Create links in Excel within your spreadsheet and outside of your spreadsheet https://www.youtube.com/watch?v=EE7pF1TQb7k&t=22s </video> <video> TECH-010 - Fill several blank cells (empty cells) all at once Description: YOU CAN DOWNLOAD ALL MY FILES FOR FREE AT http://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. If you have a few cells, you may just want to correct one by one manually, but if you have hundreds or thousands of empty cells you would like to fill out all at once, then this trick will come in handy. I hope this trick 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 resolve common Excel challenges from our viewers and subscribers. Thank you for watching. Check out some of our previous videos in the links below: * TECH-009 - Create a TOP 5 chart (Pareto) that updates automatically https://www.youtube.com/watch?v=8jzHJ_kxxOA&t=15s * TECH-008 - Create a chart with stacked pictures https://www.youtube.com/watch?v=K7bAL5tkSMw * TECH-007 - Create a survey in Excel using option buttons (a.k.a. radio buttons) https://www.youtube.com/watch?v=HnlmqZilcKU </video> <video> TECH-006 - Create a list that automatically sorts data (alphabetically) as you enter data in Excel Description: YOU CAN DOWNLOAD ALL MY FILES FOR FREE AT http://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 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 in the comments below. I try to resolve common Excel challenges from our viewers and subscribers. Thank you for watching. Check out some of our previous videos in the links below: * TECH-005 - Create a quick and simple Time Line (Gantt Chart) in Excel https://www.youtube.com/watch?v=00s5efQWrgU * TECH-004 - Calculate total days between dates in Excel https://www.youtube.com/watch?v=5q_hBywbKys * TECH-003 - Display images in comments https://www.youtube.com/watch?v=nVdNMXp-bSU </video> <video> TECH-018 - Compare Estimated Time vs Actual Time in a Time Line (Gantt Chart) in Excel Description: YOU CAN DOWNLOAD ALL MY FILES FOR FREE AT http://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: https://www.youtube.com/watch?v=00s5efQWrgU 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 daily routine so you get more with less effort. 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 resolve common Excel challenges from our viewers and subscribers. Thank you for watching. Check out some of our previous videos in the links below: * TECH-017 - Create a presentation in Excel and navigate through it like a website https://www.youtube.com/watch?v=3Wi_rnCrrJM * TECH-016 - Create a countdown calendar and combine it with conditional formatting for each task https://www.youtube.com/watch?v=KSHLjf9qo6M * TECH-015 - Count total days by day of the week in a calendar in Excel https://www.youtube.com/watch?v=1l1Bz7Nz9AE * TECH-014 - Create a progress tracker with check box buttons in Excel https://www.youtube.com/watch?v=gbDKwYPC4MI&t=12s </video>

Contacts and Links

Description

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

Videos from channel