Page 54 - Dig_CodeAI_V2.1_Class_7
P. 54
Using PivotTable
The PivotTable 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 PivotTable:
2 Click on the Insert tab.
3 Click on the
PivotTable
command.
1 Select the data on which you want to apply PivotTable command. 4 Click on the OK button.
6 Drag the Department
field from Choose fields
to add to report box
and drop into Column
Labels box.
7 Drag the Total field
from Choose fields to
5 Drag the Employee Name field from Choose fields add to report box and
to add to report box and drop into ROWS box. drop into VALUES box.
Your report will appear on the worksheet.
REFRESH
A spreadsheet is a digital tool that organises data in a grid of rows and columns.
A form is a window used to display or enter a record in an Excel worksheet.
Excel can apply filters to show only required information and hide the unwanted information.
Conditional Formatting can be applied on the basis of various criteria.
Data validation means to restrict the user to enter a specific range of values in a particular cell or a
range of cells.
The Subtotal command allows you to calculate group-wise sum.
The PivotTable feature of Excel 2016 allows you to analyse the large amount of data.
52 DigiCode AI (Ver. 2.1)-VII

