How to remove drop down lists in Excel

Sometimes we need to remove the drop down lists from our data sets. In this tutorial we’ll learn how to remove the drop down list from single or multiple cells. […]

How to convert pst to est

How to use difference formula in excel

In this tutorial, we will learn how to find the difference between two complex numeric values. We will use the subtraction method to find the difference. It subtracts the bigger […]

How to count cells with value Greater than Zero in Excel

In this tutorial we will learn how we can use Excel’s built-in “COUNTIF” function to calculate the number of cells greater than Zero. A better way to understand how countif […]

How to find max number of rows in Excel

The older version of Microsoft Excel had a lower range of columns and rows. With the advancement of Technology Microsoft Excel also increased the range of columns and rows. If […]

How to calculate the date of 52 weeks ago (one Year) from now in Excel

Break down of the formula: We used the DATE function of Excel and the format of the DATE function is as follows; DATE (year, month, day) This function is used […]

How to count cells Greater than a particular value in Excel

In this tutorial we will learn how we can use Excel’s built-in “COUNTIF” function to calculate the number of cells greater than a particular value. The best way to understand […]

How to use Checkboxes in Google Sheets

In this tutorial we are going to learn how to add and then use the checkboxes (tick boxes) in Google sheets. Google Sheets has termed Check boxes as “Tick boxes” […]

How to calculate percentage difference of two numbers in Excel

In our data set we wish to find out the percentage increase or decrease in the cost of some items. Standard formula to calculate the percentage difference between two values […]

How to use greater or equal to in Excel

Excel provides a variety of operators to check various logical conditions and Greater or Equal >= is also one of those operators which can be used to check if a […]

How to count date difference in Excel

Excel has the built-in function to calculate the date difference through the “DATEDIF” function. The best way to understand how DATEDIF works is to first understand the structure of the […]

How to delete rows above active row or specific text within a cell in Excel

How to insert pdf into excel

How to make Excel in dark mode

How to fix excel formula is not calculating upon changing values issue

Suppose we have a sheet with different formulas implemented for a pair of values in the sheet such as the arithmetic operations i.e. addition, subtraction, division and multiplication. The dataset […]