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.

Read More

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.

Read More

Adding functionality to Excel using VBA can greatly enhance your productivity and automate repetitive tasks. Thanks to this free vba code, you will insert an ActiveX Control which will add rows to your table automatically. Your worksheet gains some code and you will save a lot of time.

Read More

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.

Read More

Sorting a PivotTable in Excel can help you visualize data better, whether it’s identifying top buyers or analyzing other trends.

Read More

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.

Read More

In this Excel tutorial, you learn how to refresh pivot table with new data. You need this to analyze the data after the update.

Read More

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.

Read More

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.

Read More