Excel Formulas

How to Count Number of Cells with Dates in Excel (7 Ways)

Excel sheets can be used to keep track of time, and date, schedule events, and activities, keep track of objects and their prices, and much more. In ...

How to Calculate Accrued Interest on a Bond in Excel (5 Methods)

The accrued interest on a bond is specified as the amount of earning on a debt. Here, the bond is considered to be a debt. And when the owner of a ...

How to Calculate Production per Hour in Excel (4 Ways)

The calculation of the production per hour is a good way to monitor the production growth of a company. Based on the production per hour result, one ...

How to Bold Text in Concatenate Formula in Excel (2 Methods)

With the CONCATENATE function, you can join two or more texts altogether. Unfortunately, there is no way to bold text in the Concatenate formula ...

How to Add Percentage to Price with Excel Formula (2 Ways)

In this tutorial, I will show you how to add a percentage to a product’s price using an Excel formula. Luckily, adding percentages to a price is very ...

Concatenate Multiple Cells but Ignore Blanks in Excel (5 Ways)

In Microsoft Excel, you will encounter various situations where you will have to concatenate multiple cells. It is one of the crucial Excel tasks. ...

Carriage Return in Excel Formula to Concatenate (6 Examples)

Often, we insert Carriage Return in Excel formula concatenate to make our data more comprehensible. We can insert a Carriage Return in formula ...

How to Calculate Average Turnaround Time in Excel (4 Methods)

Turnaround time is a very common concept in various aspects such as Education, Work, etc. of our life. You can learn how to Compute Turnaround Time ...

How to Concatenate Date That Doesn’t Become Number in Excel (5 Ways)

When your dataset has values like dates, numbers, texts etc. and you want to concatenate them, Excel throws some random numbers at you. To ...

How to Convert Text Date and Time to Date Format in Excel (7 Easy Ways)

Very often we find time and date in text format in a worksheet. This may be a result of the wrong input format. This may also occur when we copy data ...

How to Count Filtered Cells with Text in Excel (3 Methods)

We may sometimes need to count the Excel cells with text for different purposes. That is not hard to do. But, things get complicated when we try to ...

How to Calculate Average Rating in Excel (7 Methods)

The average rating means the review of any product. We can calculate this average rating using the formulas in Excel. What Is Average Rating? ...

How to Calculate Turnaround Time in Excel Excluding Weekends (3 Ways)

Excel is undoubtedly one of the most useful tools. We can use Excel to do myriads of things. For example, we often need to calculate the turnaround ...

How to Subtract Hours from Time in Excel (2 Easy Ways)

In this article, we will explain how to subtract hours from time in Excel. If we want to subtract any amount of hours from a particular time we can ...

How to Add Leading Zeros in Excel by CONCATENATE Operation

In Excel, if you insert a number with leading zeros, the zeros will disappear. Excel does that because normally zeros in front of a number don’t ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo