User Posts: Mahbubur Rahman
0

## How to Convert String to Long Using VBA in Excel (3 Ways)

You'll learn how to convert Strings to Long in this VBA tutorial. This VBA tutorial comes with an Excel worksheet that contains all of the macros, data, and ...

0

## How to Compare Two Columns in Excel for Missing Values

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. ...

0

## How to Add Time in Excel Over 24 Hours (4 ways)

I'll explain to you how to add time in Excel over 24 hours in an efficient and easy way. We will use a sample dataset, where names and weekly hours are given. ...

0

## How to Use Profit and Loss Percentage Formula in Excel (4 Ways)

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 ...

0

## How to Calculate Accrued Interest on a Loan in Excel (3 ways)

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 ...

0

## Average Attendance Formula in Excel (5 Ways)

The AVERAGE function is part of the Excel Statistical functions category. The AVERAGE function in Excel computes the average (arithmetic mean) of two or more ...

0

## How to Group Rows by Cell Value in Excel (3 Simple Ways)

In this article, we will see how to group rows by cell value in Excel. For your better understanding, I am going to use a sample dataset. Here, the dataset ...

0

## How to Freeze Top Two Rows in Excel (4 ways)

Sometimes, we have to deal with a huge number of data in Excel. The data may contain lots of rows and columns. That's why, when we scroll down, the header gets ...

0

## How to Remove Duplicate Names in Excel (6 Simple Methods)

In this article, we are going to cover some easy and effective tricks on how to remove duplicate names in Excel. Sometimes, we store the same names or data in ...

0

## How to Multiply Two Columns in Excel (5 Easiest Methods)

Microsoft Excel has several functions that may be used to do simple Arithmetic Operations as well as more complex calculations. Multiplication is one of the ...

0

## Combine Texts from Two Columns in Excel (6 Easy Tips)

Sometimes while using Excel we feel the need to combine columns containing text. There are some quick and easy methods to combine texts from two columns in ...

Browsing All Comments By: Mahbubur Rahman

Advanced Excel Exercises with Solutions PDF