Exceleration 15 - Estimates, Actuals, and all the Columns in Between aka Reporting On A Budget

Sales/expense data reported at the daily level, estimates/budgets reported at the monthly level. You want to compare two.

This should be easy right? This is the age of computers right? This should take less time than microwaving popcorn right? In vanilla Excel this is more involved than it should be, but with PowerPivot you can solve the problem in no time flat.

In the next 3 videos I'll show you a easy, quick, and dirty method for making this happen pronto, along with some methods to keep the report looking sharp when users try and drill down just a little too far.

(BTW despite using "estimates" instead of "budgets" for comparison I liked the name for the budget version better so I kind of just went with it)