As mentioned in title, In this article I will be explaining Excel Index and Match Function. You can use these two function and perform multiple tasks by combining them. These functions can do…
Read more
Introduction _ XLOOKUP The Excel Xlookup function is the latest function which only available for Office 365 users. If you have ever used Vlookup function then It would be easy for you to…
Read more
There are several ways to change text case in excel which you can use easily to change text case. In Microsoft Word we can easily change text case as we get built-in options…
Read more
Why do you need to merge cells in excel? There are several reasons you might need to merge cells in excel. It could be for table heading, improve formatting or to combine data…
Read more
Want to create barcodes for your products but don’t know how? Don’t worry in this excel tutorial we will see the whole process how to make standard barcodes in excel which you can…
Read more
If you are using excel you might have used an Excel basic filter which we use to filter any specific data or some other criteria but when it comes to filter multiple columns…
Read more
You might be looking a way to convert numbers into words in excel as excel does not have a default function for that so therefore, I will be explaining both methods (without VBA…
Read more