FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -On the Insert tab, in the Tables group, click the PivotTable command, then select PivotTable . In the Create PivotTable dialog box, verify that Excel has selected the correct range, select where you want the pivot table to show up (you will almost always want to select New Worksheet ), and click OK .

Detailed explanation-2: -Go to Insert > PivotTable. Excel will display the Create PivotTable dialog with your range or table name selected. In this case, we’re using a table called “tbl HouseholdExpenses". In the Choose where you want the PivotTable report to be placed section, select New Worksheet, or Existing Worksheet.

Detailed explanation-3: -To get the Pivot Table, just click Insert tab, and find out the PivotTable option in Tables group.

Detailed explanation-4: -Pivot tables help you summarize data, find patterns, and reorganize information. You can add pivot tables based on suggestions in Google Sheets or create them manually. After you create a pivot table, you can add and move data, add a filter, drill down to see details about a calculation, group data, and more.