CA CS CIMA Prakash Somani (Landmark Group) (23512 Points)
23 June 2010Understanding of Pivot Table in Excel - Tips in very simple way
let me know if any concern
CA CS CIMA Prakash Somani
(Landmark Group)
(23512 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
Babita Jain
(Personal Assistant)
(308 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
Live Course on Python for Financial Analysis: Unlocking Efficiency in Accounting and Finance
Live Course on EPF & ESI Act - Mastercourse(With Govt Certificate)
CAclubindia
