Excel Pivot Tables can be used to calculate values as the Difference From previous months, years, day etc. Click here to read our step by step guide.