Search for:

MS Excel Tutorial

One of the best tutorials on MS Excel. This is the only tutorial that contains from basic topics to advance.

Use of % of Parent Total

Learn how to use the “% of Parent Total,” “% of Parent Column Total,” and “% of Parent Row Total”.

the “% Of” feature allows you to express values as a percentage of another value within the table.

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

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

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

Learn about the Layout & Print Tab in Field Settings of Row Label, How to set the Subtotal at the top of each group? etc…

learn about the Subtotals & Filters tab in Field Settings of Row Label in PivotTable

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

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

earn the Layout & Format Tab of PivotTable Options