Ravindra BagaleCourses & study guides

7. PivotTables and PivotCharts

By Last updated:

Chala mitrano, aaj aapan Excel cha "jaadu" shikuya – PivotTable. Hazaro rows cha data kahi secondat city-wise, month-wise, platform-wise summary madhe! Field areas, Show Values As, grouping, calculated fields, slicers, timelines, GETPIVOTDATA aani PivotCharts – sagla aaj. Interview madhe PivotTable nahi vicharla asa hot nahi, mhanun he module khup important aahe.

What you will learn in this module

  • Creating a PivotTable from a Table, and the four field areas
  • Summarize Values By (Sum, Count, Average, Distinct Count) and Show Values As (% of total, running total, difference)
  • Grouping dates and numbers; calculated fields and items
  • Sorting, filtering and Top 10; slicers, timelines and report connections
  • Refreshing, GETPIVOTDATA and PivotCharts

Concepts in this chapter

  1. 7.1Creating a PivotTable
  2. 7.2Field Areas: Rows, Columns, Values and Filters
  3. 7.3Summarize Values By
  4. 7.4Show Values As
  5. 7.5Grouping Dates and Numbers
  6. 7.6Calculated Fields and Calculated Items
  7. 7.7Sorting, Filtering and Top 10
  8. 7.8Slicers and Timelines
  9. 7.9Report Connections, Refresh and Data Source
  10. 7.10GETPIVOTDATA
  11. 7.11PivotCharts

The chapter recap is at the end of the last concept page.