## SUMIF FUNCTION In MS EXCEL

 The Microsoft Excel SUMIFS function adds all numbers in a range of cells, based on a single or multiple criteria. we can say that SUMIF Sum all the number which meet with our given criteria in the selected range. Where criteria is any logical expression.

## Convert Excel Data in to a Table

 In This Tutorial you can learn how we create excel Table and what are the benefit of Excel Table. Why we create Table in Excel. These tables have useful features, like sorting and filtering, to help organize and view data.Read more.......

## Remove Duplicate Value In MS Excel

 Removing duplicate values are are very important task in MS Excel. . A duplicate value is one where all values in the row are an exact match of all the values in another row. After deleting duplicate values you can get unique data in the table or Simple in List. Excel 2007 and excel 2010 has a powerful data function that allows you to simply select a set of data and remove duplicate rows. The data function approach is probably both the simplest and the fastest way to remove duplicate values in Excel.

## How we Write Excel Formulas

 In this tutorials we discuses the general formula. Basically general formula is user define formula which is collection of cell references , values , and arithmetic operator. When you enter formulas into your Excel worksheet, the formulas can calculate automatically.

## VLOOKUP Function In MS Excel

 The Excel VLOOKUP function is used when we want to search the value in one column (left most column) and return (display) the value form other column from the same row. in simple word we say that VLOOKUP function is used for a vertical lookup for the purpose of searching for a value in the left-most column of table and return a value from the same row in the index number position. where index number is the column number from which result display.

## VLOOKUP Function In MS Excel

 The Excel VLOOKUP function is used when we want to search the value in one column (left most column) and return (display) the value form other column from the same row. in simple word we say that VLOOKUP function is used for a vertical lookup for the purpose of searching for a value in the left-most column of table and return a value from the same row in the index number position. where index number is the column number from which result display.

## PMT() Financial Functions

 In this tutorials we are discuses the one of the most important function of MS excel financial function. This function called and use with name of PMT( ) function. This function is used for calculation like that monthly payment amounts on a loan Read More about this function.......

## Calculate the Sum of a Range Using AutoSum function

 In this tutorial we learn that how w calculate the sum of any given data in shape of cell range using AutoSum function. We take an example of the following table in excel:

## Pivot Table In MS Excel

 The Excel Pivot table ?is called summarize table which is created form an other complicated table. A pivot table is a great reporting tool that sorts and sums independent of the original data layout in the spreadsheet. in this tutorials we explain that how a pivot table is created ? and how we summarize, analyze, explore and present your data.

## Relative and Absolute Cell Reference in MS Excel

 The Cell reference which some time also called Relative Cell reference. Normally, if you copy a formula which involves a cell reference to another location, then the cell reference is adjusted relative to its starting point. For example, copying a formula which calculates the sum of a column of numbers to an adjacent cell will sum the adjacent column of cells.  The formula has updated automatically to reference adjacent cells.