COUNTA Function

It use to calculate cells,but empty cells are not included. You may use it, according to your own purposes.

Vlookup Function

Vlookup use for search specific information in spreadsheet.Form example in below picture we want to search a product price.

How to fix a cell's value while copying cell

Following picture is an example for fix a value while copying formula and drag it to down.In below picture I want to multiply all values of Qty with 100 for this I used formula =C5*D$4,Dollar sign fix the value and it can't change while copying cell.

Isnumber Function

Isnumber function returns true if value is a number,otherwise returns falls

How to Show Largest Value In MS.Excel

With the help of LARGE function we can show largest value. It may be  1st,2nd,3rd etc largest value.

In this image 1st largest value is return.

If we want to show 2nd largest value then below's image is an example.Formula will be same,we just have to change last value of formula like,1 will return 1st largest and 2 will show 2nd largest value.

Concatenate Function in Excel

In Concatenate function we can compose text of multiple cells.