Hello Friends, Welcome to dptutorials. In this video, let's learn about one of Excel's most powerful and creative tool that is called as Pivot Table, when you work with large amounts of data, i.e list type data. Pivot table is great for coming up with quick summary information. Watch this video completely for better understanding of the awesome new trick which will make you more productive and efficient. In this example, I am considering a small amount of data for clear understanding. I am going to create a Pivot table based on this data now. It has got some multiple rows of data that we are tracking sales, amount, customer count, population by state and region wise. Generally we go to insert tab in the ribbon and create a pivot table in excel. but I would suggest you a new trick of using the new feature called " Recommended Pivot tables" because sometimes the layouts that you see here might be the exact or at least close to something that you want.
A Project Management Blog with free video tutorials and setups on various tools to enrich your knowledge in project management skills and much more softwares