How to use Wildcards with VLOOKUP in Excel
I'm sure you want to make VLOOKUP more powerful.Well, using wildcards with VLOOKUP can do this for you.It [...]
How to Convert Negative Number into Positive in Excel
Last week, I got an email from one of my subscribers with a question.Hey Puneet, how many methods [...]
How to Quickly Calculate Ratio in Excel
How to Calculate Ratio in Excel A ratio is one of the common methods to compare two [...]
How to Calculate SQUARE ROOT in Excel + Insert Symbol
Excel is like a Swiss army knife for calculations.From mathematical to financial, it’s for every single thing you [...]
How to Remove First Character from a Cell in Excel
And after that, I told him about five different methods for this but then he got confused about which method is easy. Even I have created a small UDF to make it super easy for him to remove n number of characters from the start of a string.
How to Calculate Time Difference Between Two Times in Excel
As you know, a time value is a numeric value which is formatted as a time but when you deduct one value from another it returns a decimal number and you need format it again as time [...]