Why Are My Excel Charts Blank
Sometimes we can stumble upon different problems in Excel, and it is important to know how to handle them once we get to…
Author: Harun Spahic
Count Cells Ignoring Zeros or Blank Cells in Excel
In Excel, there is always a possibility to include or exclude a particular type, text, or figure from the calculations. We will show…
Conditional Formatting Order in Excel
Conditional Formatting is a great tool in Excel for highlighting the data that we want to show and formatting the cells based on…
Conditional Formatting Based on Date in Excel
Conditional Formatting is one of the best tools that can help us to highlight our cells and help us visually represent our data….
Concatenate Double Quotation Marks in Excel
Excel is a great tool for presenting numbers, figures, and data. It is probably not the best option to manipulate the text, as…
Protect Worksheet but Allow Sorting in Excel
When dealing with things in Excel, you must remember that there is almost always a solution for every problem. Locking and securing the…
Ignore Zero when Calculating the Average Number in Excel
If you ever get stuck and think that you cannot resolve a certain issue with Excel, just remember that combining formulas can be…
Calculate the Average Time Between Dates
As you might be aware, times and dates in Excel are basically just numbers. Having that in mind, we can use the same…
Average Only Visible Cells in Excel
When we talk about the calculations in Excel, we have a lot of options at our disposal. We can restrict ourselves in calculations…
Calculate Harmonic Mean in Excel
There are different ways to calculate averages in Excel, and usually, people are using formulas such as arithmetic mean and median. Sometimes, these…
