EXCEL PIVOT TABLE & PIVOT CHART

• Pivot Table - Excel provides us with a wonderful analysis tool called "Pivot table" which allow us to pivot our data by drag and drop to produce meaningful information. This makes Pivot Tables interactive in a way that once the table is complete it allows you to play around with data by dragging and dropping and see how it effects your information.
• Among other functions, Pivot-table tools can automatically sort, count, and total the data stored in one table or spreadsheet and create a second table (called a "pivot table") displaying the summarized data.

• Pivot Charts - Pivot Charts allow us to create professional interactive charts that were previously not possible without either VBA or using Excel's Controls. It is a powerful data analysis tool that enables one to visualize a pivot table.
• These charts are read from the table created using the Pivot Table Wizard and can be created along with the pivot table with no extra efforts.

•  Using the Pivot Table Wizard
•  Changing the pivot table layout
•  Formatting
•  Grouping items
•  Inserting calculated fields
•  Pivot Table Options
•  Display and hide data in fields
•  Lay out reports directly on worksheet
•  Pivot Chart