Page 45 - Computer_Genius_v2.1_C7_flipbook
P. 45
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:
2 Click on the Insert tab.
3 Click on the
Pivot Table
command.
1 Select the data on which you want to apply Pivot Table 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 Row Labels box. drop into Values box.
Your report will appear on the worksheet.
Let's REFRESH
A database implies that organising the data in a manner which helps to store and retrieve a large
amount of data efficiently.
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 Pivot Table feature of Excel 2016 allows you to analyse the large amount of data.
Advanced Features of Excel 2016 43

