A pivot desk is a strong instrument in Microsoft Excel that means that you can summarize and analyze information in a wide range of methods. One of the crucial helpful options of pivot tables is the flexibility to subtract counterparts. This may be useful for a wide range of duties, similar to calculating the distinction between two units of information or discovering the online change over time.
To create a pivot desk that subtracts counterparts, you have to to first choose the info that you just wish to analyze. After you have 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 information that you just wish to use after which click on on the “OK” button.