Big Data Analytics With Excel

5. Pivot Tables

• 5.1. Introducing Pivot Tables Page
• 5.2. Recommended Pivot Tables Page
• 5.3. Use Named Ranges And Rename Column Headings Page
• 5.4. Change The Data Function And Format The Numbers Page
• 5.5. Moving And Or Removing A Pivot Table Page
• 5.6. The Report Filter Option Page
• 5.7. Sorting And Filtering By Pivot Table Columns Page
• 5.8. Refreshing A Pivot Table Page
• 5.9. Drilldown Behind Pivot Table Numbers Page
• 5.10. Using Pivot Table Styles Page
• 5.11. Use Of Multiple Fields In Rows And Columns Page
• 5.12. Grand And Sub Totals Page
• 5.13. Filtering Columns And Rows Within A Pivot Table Page
• 5.14. Exploring Additional Options Page
• 5.15. Using The Data Slicer Page
• 5.16. Connecting To A SQL Server Database Page
• 5.17. Using External Connection Files Page