DATEDIF function is very useful, it’s the easiest way to calculate any kind of date comparisons in a breeze. For…
It is a common operation that fill a new cell that concatenates a cell with string and a cell with…
In this tutorial, you will learn how to add a line break and clean strange characters in Excel. Add Line…
Often, the work you do with Excel involves not only calculating numbers but also transforming and shaping data to fit…
If you work in a company and everyday you need to know how many cups are needed to fill an…
Excel provides several functions to count the values in a range: COUNT, COUNTA and COUNTBLANK. Each of these functions provides…
Decimal values and unnecessary digits under some situation can make your excel report harder to read, For this reason, Excel…
Division by zero in mathematics is impossible. When you do this in excel, you get the #DIV/0! error. To avoid…
When applying a price increase to a product, you usually raise the original price by a certain percent and when…
Some companies or organizations like to see a running total as a mechanism to analyze the changes in a metric…
