MicroSoft's excel has become must have skill for the tech aspirants.
We need many short cut or formulas to speed up tricky works.
Let's see some day to day use formula's that really makes work faster..
SUM: Returns the sum of a range of numbers. Syntax: =SUM(range of numbers).
AVERAGE: Returns the average of a range of numbers. Syntax: =AVERAGE(range of numbers).
COUNT: Returns the number of cells in a range that contain numbers. Syntax: =COUNT(range of numbers).
MIN: Returns the smallest number in a range.Syntax: =MIN(range of numbers).
MAX: Returns the largest number in a range. Syntax: =MAX(range of numbers).
IF: Returns one value if a condition is true and another value if it's false. Syntax: =IF(condition, value if true, value if false).
VLOOKUP: Searches for a value in the first column of a table and returns a value in the same row from a specified column. Syntax: =VLOOKUP(lookup value, table range, column number, [exact match]).
INDEX: Returns the value of a cell in a specified row and column of a table. Syntax: =INDEX(table range, row number, column number).
MATCH: Searches for a value in a range of cells and returns the relative position of the value within the range. Syntax: =MATCH(lookup value, range, [exact match]).
CONCATENATE: Joins two or more strings of text into a single string. Syntax: =CONCATENATE(string1, [string2, ...]).