Md. Abdul Kader

Consider a dataset, there are 6 AD timestamps which need to be converted to readable dates. To do that, the example will use Sequential Serial Numbers in which ...

String and Double are two major data types used in VBA. Often you may need to convert the string to double. In this article, I’ll show you 5 methods to convert ...

In some cases especially in financial analysis, you may need to calculate continuous compound interest. In this article, I’ll show you 6 methods as well as ...

Calculating average and standard deviation are often necessary while doing data analysis. However, the manual method of calculating those is not only ...

In many cases, you have to unhide unnecessary rows to make particular rows more presentable. Unfortunately, you may get troubled if unhiding all rows is not ...

In many cases, we need to change the default row height in Excel. Again, we may need to recover the previous default row height. In this article, I’ll discuss ...

For specific purposes (e.g. phone number, lottery, statistical sampling), we have to generate random numbers without repetition. However, you may get ...

Whenever you want to print any documents or any things in Excel, you may adjust the default print settings for getting the best output based on your input. In ...

Sometimes we need to merge multiple cells into one to get the desired output. Undoubtedly, Excel provides some quickest features to do that. In this article, ...

Without a doubt, charts in Excel are an outstanding tool to portray any data graphically instead of showing a complex table with lots of fields. More ...

Often we need to use AutoFill for filling the cell or cell range downwards, upwards, and so on instead of entering the data repeatedly. How would you feel if ...

When you have a larger dataset and you need to sort the dataset based on unique values, that is to say, you want to skip duplicate values. Getting such type of ...

A header is a significant tool for presenting a dataset by adding a title, date, page no., or anything else at the top of the sheets in Excel. But ...

This is our dataset where the Product Category is given with an Order Date, Quantity, and Sales based on the States of the U.S. We created a Pivot Table ...

When you need to find the position of a character inside a string or the occurrence of a substring inside a string, the VBA InStrRev function might be the best ...