Understanding of Pivot Table in Excel - very simple tips

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

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