 |
What is a Pivot Table? |
 |
Where and when to use Pivot Table? |
 |
Preparing data for Pivot Table |
 |
Top 3 Important guidelines for creating Pivot Table |
 |
Understanding Pivot Table Fields |
 |
Modifying layout and appearance of Pivot Table |
 |
Handing NULL and ERROR in Pivot Table |
 |
Filtering data in row and column |
 |
Grouping data by Data, Time or Values |
 |
Handling with Subtotals, Grand Totals in Pivot Table |
 |
Changing Data Source in Pivot Table |
 |
Updating Data Source in Pivot Table |
 |
Some Dos and Don'ts in Pivot Table |
 |
Case Study in Pivot Table in business |
 |
Class Exercise |