A pivot desk is a strong device in Microsoft Excel that lets you summarize and analyze information in quite a lot of methods. Some of the helpful options of pivot tables is the power to subtract counterparts. This may be useful for quite a lot of duties, reminiscent of calculating the distinction between two units of knowledge or discovering the online change over time.
To create a pivot desk that subtracts counterparts, you will want to first choose the info that you just need to analyze. After getting chosen the info, click on on the “Insert” tab after which click on on the “PivotTable” button. Within the “Create PivotTable” dialog field, choose the vary of knowledge that you just need to use after which click on on the “OK” button.