Microsoft Excel Tutorials
VLOOKUP is very handy When you have a particular data in hand, and you need to find something in relation to it, it becomes nearly impossible to look after it by going through each and every data …
Continue Reading about How to use VLOOKUP with multiple criteria in excel? →
While you are working in excel, a time comes when you need to work at a fast pace, but you are unable to do so or there are some features that you want to utilize yet they come under conditional …
Continue Reading about Conditional Formatting in Excel (Step-by-Step Tutorial) →
If you want to find out the name from an email address, you have walked into the right placeš. To find the same, all you need is the LEFT Function and FIND Function. Letās take an example for the …
Continue Reading about How to get the name from email address QUICKLY in excel? →
If you want to count the unique values in a range, you can do the same with the help of SUMPRODUCT Function and COUNTIF Function. In excel, when we talk about unique values, it means that we are …
Continue Reading about How to count unique values in a range? →
If you want to check on the formula or the function that you used over a data, you can use another function i.e. FORMULATEXT Function. Itās quite simple, hereās an example where the topic is …
Continue Reading about How to show formula text with FORMULATEXT Function? →
Next largest match with MATCH Functionš¤ is basically a way to find your data but with a different approach. Here, a different approachš¤ means, when you have a limit or an approx. number in your mind …
Continue Reading about Find Next largest match with MATCH Formula →
