Let’s say you are working with multiple worksheets, and for you, it’s hard to navigate to a sheet using tab. In this situation, you can use a VBA code to activate any worksheet. And, to write a VBA code for this you need to use Worksheet.Activate Method. In this post, I’d like to share with you a simple […]

Let’s say you have a date from that date you want to get the day name i.e. Sat, Sunday. This can be done with a formula, in fact, there is more than one formula can be used.Get Day Name With TEXT FunctionYou can use TEXT function for extracting day name from a date. Let’s say you […]

How to Average TOP 5 Values in ExcelLet say you have a line-up of 20 products in your company and you have data for monthly sales of all the 20 products. From that data, you want to calculate the average of top 5 products. In short, you want to get the average of top 5 values […]

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 […]

How to Convert a Formula to Value in ExcelFrom the starting days of my job, I have learned one thing hard way: Before sending a report (In Excel) to someone we must convert a formula to value. It simply means to replace a formula with its result value.Just think this way, when you send a report to […]