Select the cells from which you wish to make a PivotTable.
Select PivotTable from the Insert menu.
A PivotTable will be created based on an existing table or range.
Decide where the PivotTable report will be shown.
Click OK.
A PivotTable is a dynamic approach to summarise vast volumes of data rapidly. A PivotTable can be used to thoroughly evaluate numerical data and to answer unexpected inquiries about it. A PivotTable is ideal for: Querying big volumes of data in a variety of user-friendly methods.
A Pivot Table is a table that can be used to summarise, sort, reorganise, group, count, total, or average data. It allows us to change rows into columns and columns into rows. It lets you to organise your data by any field (column) and do complex calculations on it.
To open the editor, click anywhere in a pivot table. Add data—Click Add under Rows, Columns, or Values, depending on where you wish to add data. Change the name of a row or column by double-clicking it and typing a new name. Select the option or item under Order or Sort by.
Learner's Ratings
4.7
Overall Rating
82%
10%
4%
3%
1%
Reviews
S
Sudip Sadhukhan
5
Very good teaching technique. And it is totally free so who has only want to learn free so it is so much useful for them. Thank you
S
sadananda basak
5
Teaching technique is easy to understand. Thanks.
J
Joydeep
5
nice
U
Uttam Nandi
5
Very nice teaching.
R
RABIN DEY
5
REALLY HELPFUL COURSE
S
Subhasis Bosu
5
good
A
Anamul Huq
5
This is helpful how are zero to intermediate level.
S
Souvik Dutta
4
very good course
R
Raj
5
zero to hero course excel
K
KAUSHIK PAUL
5
outstanding class, mind-blowing practical class and concept. I just love it and thank you very so much.
again Thank you sir and Thank you Madam.
Share a personalized message with your friends.