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
The Largest Excel Knowledge Base ✅ The Best Place to Learn Excel Online ❤️
Adding average to the pivot table
In this Excel tutorial, you will learn how to add average column to the pivot table in Excel. This is a very useful and simple trick.
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. You need this to make proper calculation which you need at the moment.
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 Create Graph from Csv File
In this Excel charting lesson, you will learn how to create a chart from a csv file. It’s useful when you import csv files from other applications or the internet.
How to Calculate Savings in Excel
Use the Excel application to calculate how much money you will save. Here’s an example of how to set up a savings calculator in Excel.
How to Break Y Axis in Excel
In this Excel charting tutorial, you will learn how to break Y axis in chart. It is useful in the case of problems with the axis scale. When your data is really differential, just use this trick.