11 Excel Formulas To Increase Your Productivity:

1. XLOOKUP

Use the XLOOKUP function to find things in a table or range by row.

This is an upgrade compare to VLOOKUP.

I'm looking for revenue of a given product for multiple years. Unlike VLOOKUP, adding a column won't break the formula.

The formula: =XLOOKUP(A11,A2:A8,B2:H8)

2.LAMBDA

Use a LAMBDA function to create custom, reusable functions and call them by a friendly name.

This is a powerful function to create your own calculations.

In our case, we wanted to calculate the income after deducting tax.

The formula: = LAMBDA(x,y,x*(1-y))

3. CONCATENATE

Use this function to join two or more text strings into one string.

I'm trying to combine the first name and last name in one cell.

Don't forget the “ ” and the space in the middle if it to separate the two texts.

The formula: =CONCATENATE (A2,“ ”,B2)

4. COUNTIF

Use COUNTIF to count the number of cells that meet a criterion.

I'm counting the numbers of times these companies have been the best companies in different years.

The formula:=COUNTIF(A2:B22,A25)