Counting unique values in pivot table
In this lesson, you will teach yourself how to do counting only distinct values in pivot table. Do you think it is difficult? You will be suprised.
Best Excel Tutorial
Excel Skills Simplified: Tutorials That Actually Work
Adding an Average Calculation to Your Pivot Table
In this Excel tutorial, you will learn how to add an average column to your pivot table. This is a very useful and simple trick for calculating averages in Excel and making your data analysis more effective.
Display Data as Percentage of Total in Pivot Table
In this lesson, you will learn how to display pivot table data as percentage of total. To display data as a percentage of the total in a pivot table, you can use the “Show Values As” feature in Microsoft Excel. It is really easy and it might be helpful for you.
Modifying a calculated field in a pivot table
In this lesson, you will learn how to modify a calculated field in your pivot table to make the necessary calculations for your data analysis needs.
How to Refresh Data in Pivot Table
In this Excel tutorial, you learn how to refresh pivot table with new data. You need this to analyze the data after the update.
How to Filter Top 10 Values in a Pivot Table in Excel
Pivot tables are a powerful tool in Excel that can be used to summarize and analyze data. One of the features of pivot tables is the ability to filter the data. This can be useful for finding the top 10 values in a particular field.
We will show you how to filter the top 10 values in a pivot table in Excel.
How to Stop Excel from Changing Numbers to Dates
Excel has autocorrect data input turned on by default. After pasting the number into the cell, it is automatically replaced with the date. If the Excel number has a similar length as the date, it will go crazy and change the number to a date.
This changes the contents of the cell. A strange date appears instead of a number. These are often dates from hundreds of years ago or from the future.