Microsoft Excel data consolidation feature allows multiple tables to be consolidated ( Combine ) into a single summary report. The Excel consolidation ?is very easy and useful tools for printing and viewing the single report of more then one data sheet.

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.

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.

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

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.

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

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.

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 )

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.

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.