Formatting a Value Field in Pivot Tables in Microsoft excel

In this article, we will learn Formatting a Value Field in Pivot Tables in Microsoft excel. Pivot table Scenario: Pivot table is one of the ...

Convert Text to Numbers in Microsoft Excel

In this article we will learn about how to convert text to numbers in Microsoft Excel. We all knows that in Excel by default numbers are aligned ri...

"Waterfall" Chart in Microsoft Excel 2010

In this article we will learn how we can make waterfall chart in Microsoft Excel 2010. This chart is also known as the flying bricks chart or as th...

Transpose function in Microsoft Excel

In this article we will learn how we can use Transpose in Microsoft Excel. The Transpose function is an array function which is used to rotate the co...

Line Graph in Microsoft Excel

The line charts are fantastic tools in Excel to visualize records over time. And while working with line charts, we get the need to add a vertical...

How to Remove Duplicates in Excel

In this article we will learn about how we can remove the duplicates items in Excel. If our data is having large no. of data with duplicate entries...

How to use the Purchase Order template in Microsoft Excel

In this article we will learn about how to prepare the Invoice template in Microsoft Excel. Purchase order template is an extremely simple business a...

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.