Excel formulas and tricks
What’s conditional analysis? In its primary meaning, when Excel performs different actions depending on whether a condition is met, this…
It’s beneficial and useful to display the percent of the year that has elapsed and what percent remains in Excel…
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…
