## IF

This post is an excerpt fromÂ Popular Functions in Excel: Lesson 1 â€“ â€śIF.â€ť

â€śIFâ€ť checks whether a condition is met and then returns different values based on whether itâ€™s TRUE or FALSE.

## SUM

This post is an excerpt fromÂ Popular Functions in Excel: Lesson 2 â€“ â€śSUM.”

â€śSUMâ€ť adds values together and really becomes invaluable when working with large data sets.

## COUNTIF

This post is an excerpt fromÂ Popular Functions in Excel: Lesson 3 â€“ â€śCOUNTIF.”

The “COUNTIFâ€ť function counts the number of cells that meet a certain criteria. You can gather a tally of certain types of cells using a logical IF condition as part of the function.

## VLOOKUP

This post is an excerpt fromÂ Popular Functions in Excel: Lesson 4 â€“ â€śVLOOKUP.â€ť

Ah, VLOOKUP. This function, short for “vertical lookup,” is very useful for finding specific information in your worksheet.

## SUMIF

This post is an excerpt fromÂ Popular Functions in Excel: Lesson 5 â€“ â€śSUMIF.â€ť

The â€śSUMIFâ€ť function adds values in a range that meet a specified criteria. ItÂ offers the functionality of the SUM command but allows you to combine it with conditional termsâ€“i.e., only IF your specific criteria is met will Excel go ahead and execute the sum.

## LOOKUP

This post is an excerpt fromÂ Popular Functions in Excel: Lesson 6 â€“ â€śLOOKUP.â€ť

“LOOKUP” is useful when you want to search only a single row or column, and find the information in a corresponding spot from somewhere else in your spreadsheet.

## CONCATENATE

This post is an excerpt fromÂ Popular Functions in Excel: Lesson 7 â€“ â€śCONCATENATE.â€ť

The “CONCATENATEâ€ť function combines text from different cells into one cell.

## MATCH

This post is an excerpt fromÂ Popular Functions in Excel: Lesson 8 â€“ â€śMATCH.â€ť

The â€śMATCHâ€ť function gives you the position of an item in a range.