MSPTDA 25: Budget vs Actual, Excel Formula Solution with SUMIFS & EOMONTH

Download files for videos #26 & 26: http://bit.ly/2QgUgll
Class web site with individual file downloads: http://bit.ly/2GF25Ni
pdf notes for Video #25-26: http://bit.ly/2QgUj0v

In this video learn about how create formulas to compare month product budgeted amounts to actual amounts. Then calculate variances.

Comprehensive Microsoft Power Tools for Data Analysis Class, BI 348, taught by Mike Girvin, Excel MVP and Highline College Professor.

View on YouTube