Best formulas for student who learn excel

Best formulas for student who learn excel

Concatenate

Concatenate

Use CONCATENATE, one of the text functions, to join two or more text strings into one string.

VLOOkUP

VLOOkUP

The VLOOKUP function is a premade function in Excel, which allows searches across columns.

LEN

LEN

LEN returns the number of characters in a text string.

SUMIFS

SUMIFS

The SUMIFS function, one of the math and trig functions, adds all of its arguments that meet multiple criteria.

SUBSTITUTE

SUBSTITUTE

The Excel SUBSTITUTE function can replace text by matching.

TRIM

TRIM

Removes all spaces from text except for single spaces between words.

COUNTIF

COUNTIF

The COUNTIF function is a premade function in Excel, which counts cells as specified.

LEFT/RIGHT

LEFT/RIGHT

Left returns the beginning characters of a string.

Right returns the ending characters of a string.