Pivot Tables In-depth- Reports & Dashboards-Chapter 6


discussion on pivots.



  • Complete in-depth discussion on Pivots.
  • Data rules to Data design
  • Pivot formulas- Calculated fields use and other hidden options in Pivots
  • Use of Dates by grouping them
  • Summarizing┬áthe data like finding the average sales region wise
  • Using the custom formats
  • Filtering ,sorting , drilling -down the data in reports
  • Listing unique items in any column
  • Creating slicers and role of Pivots in Dashboards.
  • Creating Pivot charts and how are they different from normal charts
  • Classwork files and practice files are available
  • Online and phone support available


There are no reviews yet.

Be the first to review “Pivot Tables In-depth- Reports & Dashboards-Chapter 6”