How to Keep track of projects with a Gantt chart in MS Excel
New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 626th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a Gantt Chart to show the amount of time a project takes during a day.
Beyond that, you'll learn about each of the following:
1) Time Math
2) Conditional Formatting using the OR function in a logical formula to hide numbers
3) Data Validation using the Custom option with a logical formula that uses the ROUND functions and comparative operators to prevent too many hours being entered into formula.
4) Conditional Formatting using the AND function to create a Gantt chart in the cells.