How to Sort data in Microsoft Excel

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...

Consolidating Lists While Adding Links to the Source Data in Microsoft Excel

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 ...

Adding Additional Functions to Subtotals in Microsoft Excel 2010

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...

Shortcut to open drop down filter in Excel

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...

PivotTable report - Grouping the Date Field by Week Number in Excel 2010

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...

Summing Stock Lists

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...

Pivot Table-Setting the Number of Fields Displayed in the Page Layout in Microsoft Excel 2010

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...

Terms and Conditions of use

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.