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

PivotTable Report - Inserting a Chart in Microsoft Excel 2010

A pivot chart is the graphical representation of pivot table in Excel. Pivot tables & pivot charts are both linked with each other in Microsoft Ex...

"PivotTable" report - Grouping Text Fields in Microsoft Excel 2010

"Pivot Table Report" is a great feature of Excel that allows the users to make customization in report as per their requirement. If you are already us...

Retrieving Data using GetPivotData from a PivotTable Report in Excel 2010

The GETPIVOTDATA function extracts the data stored in a PivotTable report. You can use this function to retrieve data as long as it is visible in the ...

Quickly Removing Subtotals in Microsoft Excel

In this article we will learn about how to quickly remove subtotals in Microsoft Excel. We use the subtotals feature to summarize different groups ...

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.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube