Md. Araf Bin Jayed

Conditional Formatting is a must-be-used feature of Microsoft Excel for better statistical analysis and visualization of data. This feature is mainly used for ...

Many times, in Excel, users use formulas to show desired values. The results from this formula depend on other cell values on that particular sheet or on ...

Microsoft Excel is mainly used for statistical analysis, keeping and tracking records, making and analyzing reports, etc. Apart from these, users can solve ...

Clearing cells with a certain value means finding a specific value and erasing the cell content. While working in a large data set, clearing certain values by ...

While working in Excel, users may have to reverse the data in the worksheet’s cells for working purposes. But there are no integrated options in Excel to do ...

There are many graphical features available in Microsoft Excel. Users use those features to represent statistical data. The Excel bar chart is one of them. ...

To select a winner from a lottery, we need to do a raffle draw. Drawing raffles manually is time-consuming and tedious if there are many participants. But this ...

While working in Microsoft Excel, sometimes you need to create new tabs based on various criteria. Also, various companies or institutions need separate Excel ...

While working in Excel, users may sometimes have to deal with duplicate values. Sometimes, these values might not be necessary for working purposes. So ...

For better analysis in many surveys and questionnaires, a reverse score is used. Generally, in the reverse score, we transform 1 = 5, 2 = 4 and so on. Doing ...

It is a common case while working in Excel to get negative values in the calculation. By default, Excel will put a negative sign before such values. But if you ...

While working in Excel, users have to reconcile two data sets for various working purposes. If the two data sets are in the same worksheet, then it is easy to ...

While working with various numbers in Excel, sometimes it is necessary to add a 0 or 00 at the beginning of the numbers. But by default, Excel will not keep ...

An annuity is a term that is mainly associated with retirement. By following some simple steps in Excel, one can easily calculate a growing annuity for one's ...

Cost of funds is a term of finance and banking. Many times, financial institutions have to calculate the cost of funds for their working purposes. This ...