How to Quickly Calculate Ratio in Excel
A ratio is one of the common methods to compare two values with each other. And it can help you to compare variation between those two values. Even in our daily life,
Formulas
How to Get QUARTER from a Date in Excel
In Excel, there is no direct function to get a quarter from a date. But you can create a formula for this. Yes, you can use a formula to calculate a
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 need to calculate. You can calculate simple to most complex things
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 […]
How to Calculate Age in Excel using Date of Birth
Let’s say you are preparing a data where user’s age is one of the important things to capture. The thing is, if you ask every user to enter his/her age, chances are they can give you an approx number.