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 to make the necessary calculations for your data analysis needs.

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

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.

Read More

What to do when you have ngative values? Read this tutorial to learn how to insert a chart with negative values in Excel.

Read More

Thanks to Excel, you can easily calculate. Here you have a free retirement calculator to find out how much you will get as a senior.

Read More