In this article, we will show you some methods to count unique values in Excel worksheet based on different criteria. The Excel worksheet can be used to count ...

This article will show you how you can ignore blank cells in Excel sum. In the spreadsheet, sometimes we have to sum a data range that has blank cells. So, ...

Excel spreadsheet can be used for custom autofilter for more than 2 criteria. This filter option is particularly useful for sorting a dataset. In this article ...

Absolute Deviation is a useful tool that indicates the variability of a dataset. It gives a sense of idea about a dataset whether it is clustered or spread or ...

The DMAX function is used for finding the maximum value of a column or field under multiple criteria. In this article we will show you how you can use the DMAX ...

Charts are useful tools that can be used for representing data in an Excel worksheet. We can also use Area Charts to display the data charts in a proportional ...

Error 509 in Excel also known as runtime error(bug). Before releasing the final product to the public, Software developers generally work through different ...

The properties dialog box reveals the basic information about an Excel file. The file size, its location, name of the author and many other elementary ...

For scientific analysis we may have to calculate vector multiplication. We can use the Excel spreadsheet for this multiplication. In this article, we will show ...

We can perform employee scheduling algorithm in Excel using the in-built Solver feature. This algorithm is particularly handy when it comes to efficient ...

In this article, we will show you how you can perform custom scaling in Excel to control the print area. When it comes to printing an Excel spreadsheet, many ...

Excel spreadsheet is extensively used for data analysis. Also Excel provides many inbuilt features for insightful data visualisation. In this article, we are ...

The maximum likelihood analysis is widely performed in statistical and scientific analysis. This estimation is used for finding the likelihood of a certain ...

For building a house, it is important to estimate the total cost. This estimation can be very complicated if you try it manually. You can use an Excel sheet ...

A timer in Excel is used for counting down time. For practical purposes you may need to create this timer event option in Excel. There are several ways for ...