A pivot desk is a robust software in Microsoft Excel that permits you to summarize and analyze knowledge in quite a lot of methods. One of the crucial helpful options of pivot tables is the power to subtract counterparts. This may be useful for quite a lot of duties, comparable to calculating the distinction between two units of knowledge or discovering the web change over time.
To create a pivot desk that subtracts counterparts, you have to to first choose the info that you simply wish 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 simply wish to use after which click on on the “OK” button.