Microsoft Excel has the basic features of all spreadsheets, using a grid of

*cells*arranged in numbered**rows**and letter-named**columns****to organize data manipulations like arithmetic operations. It has a battery of supplied functions to answer statistical, engineering and financial needs. In addition, it can display data as line graphs, histograms and charts, and with a very limited three-dimensional graphical display.**
Here are some useful commands to use excel more efficiently with less time consuming work

**A]**

__Commands for Excel Text Functions__:

1] Len() : Returns the number of characters of a string.

Syntax: =len(String). Here string means the position of cell

2] Rept() : Repeat given characters (S) specified number of times

Syntax: =rept(string, number of times). Here number of times means the Repeat value of Character.

Syntax: =rept(string, number of times). Here number of times means the Repeat value of Character.

3] Concatenate() : Join multiple strings in one string

Syntax: =concatenate ( String1, String2, String3,.......)

**B]**

__Commands for Excel Mathematical Functions__:

1] Sum() : Adds all the numbers given as an argument

Syntax: =sum(numerical argument).

2] Product() : Multiply all the numbers given as an argument.

Syntax: =product( numerical argument)

3] SQRT() : Return Square root of a number.

Syntax: =sqrt(number).

4] MOD() : Returns Reminder

Syntax: =mod(number,divisor)

5] Fact() : Returns the factorial value of a number.

Syntax: =fact(number)

**C]**

__Commands for Excel Statistical Functions__:

1] MIN() : Returns the smallest value from a list of supplied numbers.

Syntax: =min(number1,number2,.......)

2] Max() : Returns the largest value from a list of supplied numbers.

Syntax: = max(number1,number2,.......)

3] Large(): Returns the kth largest value from a list of supplied numbers for given value k.

Syntax: =large(datatable,k)

4] Small(): Returns the kth smallest value from a list of supplied numbers for given value k.

Syntax: =small(datatable,k)

5] Count() : Returns the number of numerical value in a supplied set of cells or values

Syntax: =count(value1, value2,.....)

6] CountA() : Returns the number of blank cells in a supplied set of values

Syntax: =countA(value1, value2,.....)

7] Count Blank() : Returns the number of cells that satisfy a given criteria.

Syntax: =Countblank(data range)

8] Count If() : Returns the number of cells that satisfy a given criteria

Syntax: =countif(criteria range, criteria).

9] Countifs() : Returns the number of cells that satisfy a set of given criteria

Syntax: =countifs(criteria range1, criteria, criteria range2, criteria.......).

10] Average () : Returns the avg of list of supplied numbers

Syntax: =Average(number1,number2....)

Thus to use excel in effective manner we should go through the advance excel course.

Thank you so much buddy.. for sharing such an informative knowledge with all of us.

ReplyDelete