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)