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 )


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:


Fill In Excel

Fill Cells Automatically The following process show the Automatically filling. In this example we fill the The SNO from 1 to 10 in Column:
Select any cell where you want to write the first Number. In my example A3 in above image.
Type 1 in cell A3.


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.


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




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 )


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.


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.


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.


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