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.

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

User Define Function (UDF) In Excel

 In This tutorial we learn that how we create User define function in Excel with very simple example. For example if you have student exam record and you want to calculate the Percentage of the students then in excel there is no proper pre define function . you can calculate the percentage of student using manual formula like that =marks obtained * 100 / total marks but you can also create your own function for calculating percentage and you can use it as pre define function.

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 )

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.

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 )

Components of Excel 2007 Environment

 in this tutorials we learn about the different components of Excel 2007 Spreadsheet. Excel 2007 is Spread sheet application of Microsoft office in which data is orgnized in form of table which contain column and rows. each combination of row and column is called cell where the particular value store. below we discuse one by one each components in detail.

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.