Count Cells that are Not Blank in Excel (Formulas)
Sometimes we need to count cells that are not empty. While you may be able to do it manually with a small dataset, it could be quite difficult to do …
Excel Tips
Here you will find common Excel tips and tutorials that can help you speed up your work and get stuff done faster.
How to Apply Long Date Format in Excel?
Dates in Excel are saved as serial numbers where the date January 1, 1900, is stored as the number 1, and each following day is stored as the following consecutive …
Count Cells Less than a Value in Excel (COUNTIF Less)
Microsoft Excel is a powerful tool for data management and analysis. Sometimes in Excel, we want to count cells that meet some predefined criteria, such as counting cells less than …
Calculate the Coefficient of Variation in Excel
The coefficient of variation is one of the relative measures of dispersion. The ratio between the standard deviation and the mean is known as the coefficient of variation. This is …
How to Sum a Column in Excel?
One of the essential operations in Excel is summing numbers in a column. So, for example, we can calculate a column to determine the total tuition fees paid in by …
3D Reference in Excel – What is it and How to Use it?
When working with Excel, most Excel users refer to cells/ranges in the same worksheet and sometimes may have to refer to other cells or ranges of cells in one or …
How to Count Cells with Text in Excel?
One of the essential Excel operations to summarize data is counting the number of cells in a dataset containing particular data types. It’s a common task for many Excel users …
How to Add Minutes to Time in Excel?
Sometimes we may need to add minutes to time in Excel, for example, when creating a schedule of times of departures and arrivals for a bus company or planning a …
How to Remove Password From Excel?
While passwords in Excel are intended to protect our data, sometimes we may need to remove them to facilitate required operations such as changing the workbook’s structure or modifying data. …
How to Select Visible Cells Only in Excel?
In Microsoft Excel, we can easily copy the range of cells and paste it to some destination. This can simply be done using the following steps. But imagine a situation …
How to Add Hours to Time in Excel?
You may find that while doing payroll or working with other time-related calculations, you need to add hours to a time value in Excel. So in this tutorial, we will …
How to Clear Cache in Excel?
Think of a cache as a temporary storage space on your computer that Excel uses to store files. These files help Excel to perform better by storing information such as …