Project tracker
The company "project tracker": color-coded status and priority, budget vs. spent, each project's automatic health and a doughnut chart of statuses.
Area: Project management. Level: Intermediate.
Functions used: IF, COUNTIF, COUNTA, SUM.