LIVE GST Certification Course by CA Arun Chhajer begins 21st April. Register Now!!

Understanding of Pivot Table in Excel - very simple tips

CA CS CIMA Prakash Somani (Landmark Group) (23502 Points)

23 June 2010

Understanding of Pivot Table in Excel - Tips in very simple way

let me know if any concern

Reply
Follow
Share

2 Replies

CA CS CIMA Prakash Somani (Landmark Group) (23502 Points)
Replied 23 June 2010

GUIDE ON PIVOT TABLE / CHART

1. Open the data file for which you want to create pivot
2. Check all columns has headings
3. go to the cell where you want to insert the pivot table
4. go to insert > click on pivot table
5. select the data for which you want to make pivot table
6. click ok
7. Drag the data in report filter , row filter, column filter & value

1 Like

Babita Jain (Personal Assistant) (235 Points)
Replied 10 May 2021

Excel is the most powerful tool to manage and analyze various types of Data. This Microsoft Excel tutorial for beginners covers in-depth lessons for Excel learning and how to use various Excel formulas, tables and charts for managing small to large scale business process.

This free Excel videos for beginners course will help you learn Excel basics.

Click to see Videos - Excel Insert Pivot Table | Excel Full Tutorials