Budget vs. actual

The corporate budget control: actuals by quarter, variance in $ and %, status with a tolerance (ABS and IF), a color scale and a budget vs. actual chart.

Area: Business finance. Level: Advanced.

Functions used: SUM, IF, ABS, COUNTIF.

• Next project: Payroll
• All projects
• Lessons