1. Drag and drop up to 5 row fields and/or 5 column fields by which you need to group and aggregate your data. 
   
   
2. Have 1 data field and aggregate it based on its Sum / Count / Maximum / Minimum / Product. We will be supporting more than 1 data field very soon.
   
   
3. Date fields in Rows/Columns could be grouped by Year / Quarter / Month / Day / Day of Week / Quarter by Year / Month by Year.
   
   
4. Add up to 5 filter fields to filter your Pivot Table.
   
   
5. Sort and Filter the Pivot Table based on the row/column fields.
   
   
6. Dress up your Pivot Tables with different colored styles readily available.
   
   
7. A Pivot Table can be in a separate worksheet or it can reside in an existing worksheet. A single worksheet can contain multiple Pivot Tables.
   
   
8. As the Pivot Table is more native to the spreadsheet now, they can be treated as normal cells in your spreadsheet. For example, you can refer to cells of a Pivot Table in a formula or Draw charts on top of a Pivot Table or Print the spreadsheet along with the Pivot Table. 
   
   
9. Move your Pivot Table to a different location or change the source range when needed.
   
   
10. When you import your spreadsheet, the Pivot Tables in it get imported as well. Export of Pivot Tables is also supported, except for the xlsx format where the data gets exported, but it won't be recognized as a Pivot Table.
    
    
11. Use Refresh / Refresh All to refresh your Pivot Table when existing data is modified or new data is added to the source range.

Important Note: If you have the old ​Pivot Tables and Pivot Charts on your existing spreadsheets, ​we recommend you to recreate your Pivot Tables and Charts by October 15th 2015. The old Pivot Tables and Pivot Charts will not be rendered after that. For more information on this, refer this post.