Add Your Doubts: Click Here
Add Your Doubts: Click Here
Pivot table (Part 1)
Summary: In this class, you will learn to make pivot tables. It is used to generate reports. A pivot table is a table of grouped values that collects the individual items of a more large table within one or more discrete categories. This summary might include averages, sums, or other statistics.
Formula:
To find Pivot table: Cllr A+ Insert tab → Pivot table → select a table from range → New Worksheet
To Remove blank cell: click on blank call → Pivot table options → for empty cells → entry 0/x
To make the Report more Presentable: Report Layout → Show in any Form
To bring First Name & Last Name together = Click on tabular Form
