Excel sorts data according to specific sort order rules. We can sort the number data as per ascending order and descending order. And sort the text ac...
If you have data in the same cells in multiple sheets that need to be summed up together, you can do this using a very simple technique. And if you ...
In this article, we will learn about how we can add the additional functions to Subtotal in Microsoft Excel 2010. Subtotal: - This option is used t...
In this article, we will learn the shortcut to open a filter drop-down list and the filter in Ribbon in Microsoft Excel. “Auto Filter” option all...
In a pivot table, in order to group the dates, number and text fields or group dates by year and month. We can manually select the items in a pivot ta...
In order to calculate sum of stock lists we will multiply the quantity with price of stock, we will use SUM & SUMPRODUCT function to get the outpu...
In this article we will learn how we can setting the number of fields displayed in the page layout- Pivot table. You can manually set the number of...
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.