Page 65 - TP_Modular_V2.1_Class7
P. 65
Step 5 Select the column in which you want to add subtotal from the Add subtotal to
drop-down list.
Step 6 Click on the OK button. The subtotal and grand total will appear.
Tech Funda
To remove subtotals, click on Subtotal command and click on the Remove All button.
USING PIVOT TABLE
The Pivot Table feature of Excel 2016 allows you to analyse the large amount of data. It
consolidates, summarises and presents data. Perform the following steps to use the Pivot Table:
Step 1 Select the data on which you want to apply Pivot Table command.
Step 2 Click on the Pivot Table command from the Tables group of the Insert tab.
Step 3 The Create Pivot Table dialog box appears displaying the range you have selected.
Using Pivot Table feature Create Pivot Table dialog box
Step 4 Click on the OK button. A new worksheet will appear with Pivot Table Field List pane.
Step 5 Drag the desired column from Choose fields to add to report box and drop into Row
Labels box. In this case, we have dragged and dropped the Employee Name field.
Step 6 Drag the desired column from Choose fields to add to report box and drop into
Column Labels box. In this case,
we have dragged and dropped
the Department field.
Step 7 Drag the desired column from
Choose fields to add to report
box and drop into Values box.
In this case, we have dragged
and dropped the Total field.
Your report will appear on the
worksheet.
Summarising data using Pivot Table
Excel as Database 63

