HR dashboard

HR metrics in 2 tabs: length of service, active and departed staff by department with COUNTIFS, turnover, average salary with AVERAGEIFS, a color scale and a chart.

Area: Human resources. Level: Advanced.

Functions used: ROUNDDOWN, COUNTIFS, AVERAGEIFS, SUM, AVERAGEIF, SUMIF.

• Next project: Investment portfolio
• All projects
• Lessons