A Gantt chart is a project management tool to help you manage multi-task projects.
There are many online apps that will help you create one but I thought I would use a Gantt chart as a way to demonstrate how to use many of Excel’s features together to create a reporting model.
The techniques covered include
- date formulas
- text formulas
- conditional formats
- scroll bar control
- formatted tables
- range names
- data validation
Plus a few others and extra tips along the way.