A pivot table is a table of grouped values that aggregates the individual items of a more extensive table (such as from a database, spreadsheet, or business intelligence program) within one or more discrete categories. By using Pivot Table you will be able to summarize the data from any sheet even without actually studying the data. You are also given the option to have different views on the data using Pivot Table. In this video on Pivot table we learn What is Pivot table, Its importance and the different ways to summarize the data using pivot table. We also learn about the various tools in Pivot table.

• 00:00 - Introduction
• 01:29 - Agenda
• 02:35 - Pivot Table and Its Importance
• 04:29 - How to create Pivot Table?
• 09:50 - Different ways to summarize data
• 15:28 - Various Tools in Pivot Table
• 17:35 - Layout
• 20:22 - Style Options
• 21:03 - Insert Slicer
• 23:04 - Change Data Source
• 24:07 - Refresh
• 25:16 - Summary

Shirts and Gifts for You, Your Friends & Loved ☞ https://bit.ly/36PHvXY

#pivot #excel