T&E Dashboard: Monthly Totals, Budget Variance, a Stacked Chart and Red Flags
This lesson is part of the course
In this lesson
You total six months of T&E spend, compare it with the budget, show the category mix in a stacked column chart and highlight the overspent months with conditional formatting.
Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.
Lessons in this course
- Expense Report Totals by Category & Employee Locked
- Policy Compliance: Hotel Caps by City and Class of Travel Locked
- Per Diems: Travel Days, City Rates and 75 % Partial Days Locked
- Booking Lead Time vs Airfare: Buckets, CORREL and a Scatter Locked
- Duplicate & Suspicious Claims: COUNTIFS Keys and Weekend Flags Locked
- Mileage Reimbursement: Round Trips, Commute Deduction and a Rental Break-Even Locked
- Savings Opportunities: Advance Booking and Preferred Hotels Locked
- T&E Dashboard: Monthly Totals, Budget Variance, a Stacked Chart and Red Flags Locked