Distinct Count in Pivot Table
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.
Pivot Table Summarize Value By
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
Field Settings in PivotTable | Layout & Print Tab
MS-EXCEL-59-Field Settings in PivotTable - Layout & Print Tab - Display Total at Top - Repeat Labels
Learn about the Layout & Print Tab in Field Settings of Row Label, How to set the Subtotal at the top of each group? etc…
Field Settings in PivotTable – Subtotals and Filters Tab
MS-EXCEL-58-Field Settings in PivotTable | Subtotals & Filters Tab | Custom Subtotal in PivotTable
learn about the Subtotals & Filters tab in Field Settings of Row Label in PivotTable
PivotTable Option – Data Tab
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
Printing Tab in PivotTable Option
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
Pivot Table Options – Layout and Format Tab
MS-EXCEL-53-Pivot Table Options - Layout and Format Tab - How to Merge Cell in PivotTable - In Hindi
earn the Layout & Format Tab of PivotTable Options
Pivot Table Introduction
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
Data Entry Using Form in Excel – Without VBA Form
MS-EXCEL-51-Data Entry Using Form in Microsoft Excel - Without VBA Form - Data Entry Work in Excel
Learn How to Create a “Data-Entry Form” in Excel, without using VBA? Website from where people can contact you for Data entry tasks.
