MS-EXCEL-62- % of Grand Total - % of Column Total - % of Row Total - Show Value As in Pivot Table

Learn how to use the “% of Grand Total,” “% of Column Total,” and “% of Row Total” functions to gain valuable insights from your data.

Read more ›

MS-EXCEL-61-Distinct Count in Pivot Table - Count Unique Value in Pivot Table - Data Model - Excel

Distinct Count in Pivot Tables using the Data Model Option and how to use it effectively.

Read more ›

MS-EXCEL-60-Pivot Table Summarize Value By - Sum, Count, StdDev, Varp - Value Field Setting - Excel

Learn about the Summarize Value By Tab in Field Settings / Value Field Settings of Value in Pivot Table

Read more ›

MS-EXCEL-57-PivotTable Option - Data Tab - PivotTable without Source Data - Refresh Automatically

learn about the Data Tab of PivotTable Options, Save Source data with File, Use of Enable show details, Refresh data when Opening the file

Read more ›

MS-EXCEL-56-PivotTable Option - Printing Tab - Print setup for PivotTable - Print title on each page

learn about the Printing Tab of PivotTable Options. Set Print Titles. Print Titles on each page Repeat row labels on each printed page

Read more ›

MS-EXCEL-52-What is Pivot Table - Use of Pivot Table - All Parts of Pivot Table Panel - in Hindi

learn very basic things about Pivot Table. Important thins to keep in mind while creating Pivot Table

Read more ›