Latest Posts From Mahbubur Rahman
Here, we have a sample dataset containing Customer Name, Gender, Loan Purpose, Job, and Credit Risk. As we can see, there is repetition in the dataset. Snoop, ...
Mahbubur Rahman
In this article, we will know, how to calculate the average if within a date range. We will use a sample dataset containing Date, Region, and Sales. We want to ...
To count characters in a cell without spaces in Excel, follow the steps below: Select the blank cell. Insert the formula: =LEN(SUBSTITUTE(C5," ","")) ...
While working in Excel, Excel might not correct all the spelling mistakes but it offers some methods to automatically check spelling mistakes. We will see 3 ...
To protect our spreadsheet, we need to know how to lock certain cells in Excel. Locking the whole spreadsheet or certain cells in Excel allows us to protect ...
Sometimes while working in Excel we need to copy cells. But sometimes while copying the format of the cells may change which will make our task difficult if we ...
When performing calculations in Excel, sometimes we want the results to be displayed as a blank cell if the computation does not meet our needs. When we use ...
Advanced Filter in Excel is one of the coolest options in Excel. Advanced Filter can do many complex filtering that AutoFilter can not do. In this article, we ...
Sometimes, while using Excel we have to deal with different sizes of datasets which may contain blank cells at the bottom or in between rows. Here, we will ...
Coloring cells is a popular method to visualize data in an Excel worksheet. Sadly, there is no in-built function in Excel to do it. We're going to show you ...
Let's use a sample dataset containing Name, Gender, and Date of Birth to showcase how you can count how many cells contain dates in Excel. Method 1 ...
Copying merged and filtered cells in Excel can be a frustrating process. Merged and filtered cells are notorious in spreadsheets for producing problems, ...
When you have data in two separate columns, you may need to compare them to discover what information is missing in one and what data is available in both. ...
If you know how to track the performance of your business finances, you'll have a better idea of what you should do next. For anyone running their own ...
The amount of interest you earn on a loan is known as accrued interest. It is, however, the Sum that has yet to be collected or paid. It accrues on loans such ...
