Page 59 - ModularV1.1 _c7_flipbook
P. 59
Tech
Funda
To remove subtotals, click on the Subtotal command and click on the
Remove All button.
USING PIVOT TABLE
The Pivot Table feature of MS Excel allows you to analyse 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 the Pivot Table command.
Step 2 Click on the Pivot Table command from the Tables group of the Insert tab.
A drop-down list appears.
Step 3 Select the Pivot Table option. 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 57

