Xlookup formula, Sort formula, Filter formula, Xmatch formula and Unique formula you can learn all excel tricks for 2020 with all new formula in one video. Xlookup formula is the most new formula which Microsoft have launched in there office insider program. in this xlookup formula you can learn all kind of lookup like Vlookup , indexmatch and ever hlookup this xlookup formula is mix of all formula and can work on multiple criteria. if you want to use xlookup formula you can click on the link below to get free xlookup formula in excel.
Sort formula is one of the best formula which is launched by Microsoft and this is an array formula where in we just need to apply sort formula in one cell and it will automatically populate rest of the values. this sort formula can sort multiple columns in one click.
Filter formula is also introduce by Microsoft insider program , with the help of this formula you are not required to put manually filters, you can simply apply filter formula in one cell as this an array formula and so its not required to drag the formula on each cell. only one click and it will populate filter on each of the column accordingly.
Xmatch formula is also a new formula which is just launched by Microsoft office insider. this xmatch formula will help you to populate row number as per the requirement. this is an array formula which have many more feature than match function.
Unique formula is a new formula which is launched by Microsoft office insider program this formula is a replacement of unique function which we use to do manually. however now we just need to apply unique formula and it will gives us the unique values.
#Xlookup
#Filter
#Xmatch
#Sort
#Uniqueformula
Download link :-
*****************************FOLLOW ON*************************
Facebook :-
Twitter -
Youtube-
Follow me on Instagram :-
______________________
How to Use concatenate in excel || Replace vlookup and IndexMatch formula ⚡⚡ || Tutorial in hindi :-
New vlookup formula in excel || textjoin function in excel || index match function in excel :-
indexmatch excel || How to use index match formula from Basic to advance. :-
combination formula || How to make big formula in excel in hindi || combined variance formula :-
Xlookup for Free || New formulas for free || Xlookup and Filter formula in hindi :-
compress excel file || reduce #excel file size || how to reduce excel file size in hindi :-
How to use Xlookup in excel 😮 || xlookup formula in hindi 😮|| vlookup formula in excel :-
Array formula excel || array function in excel || Excel Vlookup ❌|| index Match Excel ❌ :-
xlookup in excel in hindi || Xlookup A to Z in details || New Xlookup with Search Mode :-
Xmatch formula in excel || Xmatch formula in excel in hindi || Xmatch with Index formula:-
filter formula in excel || how to use filter formula in excel in hindi 😮 filter formula in hindi :-
Top 10 excel formulas 😮|| excel formulas and functions || excel functions and formulas :-
How to use excel unique function || Excel unique formula in hindi || Remove duplicate values:-
3D Pivot Graph in excel in hindi || Lean Pivot from beginner to advanced || lean pivot table:-
Sort formula in excel || array formula in excel || how to use sort formula in excel :-
interview questions and answers || interview questions || advanced Excel || Excel Interview 7 :-
Job Interviews question !! Excel interview question in Hindi !! Job Interviews question part 3 :-
Job Interviews question !! Excel interview question in Hindi !! Job Interviews question part 2 :-
Excel Interview Question 😮 MIS Interview Question in Excel in Hindi 😮 Excel Interview :-
Interview question how to get first and last name in excel 😮 First and Last name in Excel in Hindi. :-
Serial Number auto populate 😮सीरियल नंबर औटो पॉपुलटे कैसे करें 😮rows formula to populate serial no :-
Advance Excel - Top 5 Excel Time Saving tricks 2018-2019 :-
How to Separate all text available in a cell :-
**********(Gyan On Tube)************
0 Comments