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 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:    • TECH-005 - Create a quick and simple ...  

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
   • TECH-017 - Create a presentation in E...  

* TECH-016 - Create a countdown calendar and combine it with conditional formatting for each task
   • TECH-016 - Create a countdown calenda...  

* TECH-015 - Count total days by day of the week in a calendar in Excel
   • TECH-015 - Count total days by day of...  

* TECH-014 - Create a progress tracker with check box buttons in Excel
   • TECH-014 - Create a progress tracker ...