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.


Macros In Excel

This tutorial show you that how we create macros and how we use these macros when we need. Below we describe a complete process:
In macro basically we define a series of action and when we Run the macro then Excel perform these action one by one.
First Step is:
Record a new Macro
Read more and share with you friends.


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.


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.


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


Page Setting and printing In MS Excel

In This Tutorial you can learn that how you can setup your page in MS Excel. There are many thing to do before you print your Excel sheet .The first Step you decide the page orientation. There are two page orientations portrait and landscape. Read more.......


COUNTIF Function In MS Excel

The COUNTIF function, one of Excel's COUNT functions, is used to count up the number of cells in a selected range that meet specified criteria. Where criteria is anylogical expression.


COUNTBLANK Function In MS Excel

The Excel Countblank function is one of the count function in MS excel. The Countblank function count the blank cell in a given range.
The syntax of the function is :
COUNTBLANK( range )


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.


Rounding The Numbers MS Excel

In Excel there are different way to round the number. The Round function Rounding the decimal value by comparing the number on the Right of Rounding digit. if this digit is grater then 5 then the rounding digit increase one time if not then it remain the same. On the other hand Roundup always increase the number on the right side of the rounding digit one time. where ROUNDDOWN function always leaves the rounding digit unchanged regardless of the value of the number to its right.