Excel Magic Trick 1066: PivotTable: Month Over Month Sales Calculations From Transactional Data Set



Download Excel File: http://people.highline.edu/mgirvin/ExcelIsFun.htm
See MOM calculations:
1. (00:18 min) Use PivotTable to calculate Month Over Month Sales Calculations From Transactional Data Set
2. (00:50 min) PivotTable to group by month
3. (00:50 min) PivotTable to add month sales
4. (01:11 min) Show in Tabular Format
5. (01:18 min) Number Formatting, Not Format Cells
6. (01:36 min) PivotTable to Calculate Percentage Change for each month (% Difference From Calculations: Show Values As Calculation).

source