Sometimes you need to calculate the total number of days in a month to use in the further calculation.It happens specifically when you work on templates and dashboards. So today, let me show a simple formula which can do this for you.To calculate the number of days in a given month from a date, we […]

From the starting days of my job, I have learned one thing hard way that before sending a report to someone we must convert a formula to value.It simply means to replace a formula with its result.Just think this way, when you send a report to someone, they are not concerned with formulas but result.Why […]

It happens sometimes you send Excel files to others and they made some changes into formulasOr, sometimes you simply don’t want to show a formula to others.Hiding a formula is a simple way to do this so that others can’t able to see which formula you have used and how they get calculated.Now the question […]

Yesterday I was working on some temperature data for weather forecast with one of my friends.For this, one of the important things was to use degree symbol in data to show numbers in Celsius and Fahrenheit.If you use a laptop like me, you’ll find that there is no key to type a degree symbol.While working […]

Using a filter in Excel is not a #rocketscience. Everyone knows that they can do a lot of things with filter option.But, the bad news is they are not actually using it to the best or maybe they forget to make a habit to use it.And, the good news is you can be one of […]