Every product has its barcode label. But we need to create our own product code and barcode in our product so Here I show you how to create barcode…
Read moreHere I am showing you how to convert number to word using VB code. here I used VBA function. the function name is SpellNumber which take on argume…
Read moreIn default developer tab is hide in the excel, Developer tab is very useful for the macro user, excel developer can use developer tab using develop…
Read moreSyntax =EXACT(string1,string2) If you want to compare two string in excel for the finding is they are same or not you can use EXACT function, for…
Read moreSometimes you need to decrease a number by a certain percentage, that means you decrease percentage which is given you can use a simple formula …
Read moreThere is two major function in excel to find the random number. The RAND() and RANDBETWEEN() function return the random number in excel RAND ()…
Read moreHere in the first part, I am calculating the monthly payment i.e monthly installment payment for the loan. in the second part, I am going to calcula…
Read moreThe product function in excel gives result as product of given number provide as number. The product help us when we need to multily multiple cells …
Read moreIn the previous article is about highlight duplicate values in excel only show you duplicate data. But we have huge data which contain many duplica…
Read moreHow to create cascading dropdowns Cascading dropdown lists also called the dependent dropdown lists. Its called cascading dropdown because there …
Read moreSometimes we need to hide our result in excel, yes we applied formula but we don't want to display it. yes, you can format cell to hide your res…
Read more
Social Plugin