Page 69 - modular4.0
P. 69
Chapter Profile
Perform the following steps to use the Subtotal command:
2 Click on Data tab.
3 Click on the
Subtotal command
in the Outline
group.
1 Select the data on
which you want to apply
Subtotal command.
4 Select the column T-Shirt Size from
the At each change in drop-down list.
5 Select the
Count function
from the Use
function drop-
down list.
6 Check the
T-Shirt Size
column name
in the Add
subtotal to list.
7 Click on 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 2019 allows you to analyse the large amount of data. It consolidates,
summarises and presents data.
Excel as Database 67

