How to calculate relative frequencies in Excel

To understand how to calculate the relative frequencies of a frequency distribution, let’s consider this dataset in the picture above. Our dataset consists of the scores of some students and […]

How to change x and y axes in Excel

In our dataset we have a series of numbers and its cube values. These are shown above.

How to add long division symbol in Excel

How to convert number of days between two dates to months in Excel

Structure of DATEDIF The standard syntax of countif function in excel is shown below; =DATEDIF(start_date, end_date, unit) Could be any date earlier than the second parameter end date. Otherwise errors […]

How to calculate a min per km to min per mile in Excel

One such requirement can be conversion of minutes per km to minutes per miles. Let’s start with an example. Suppose we have data in minutes per kilometers within a column […]

How to get a 4th Degree Polynomial in Excel

We have a data set with x and y values along with the associated chart as shown and we need to identify its 4th degree polynomial.

How to use Power Query Concatenate to join data in Excel

Let’s consider the following data set which contains the details about the soccer team players. We’ll use the custom query on this data to combine data from two columns to […]

How to use Countif to count the rows containing specific word in Excel

Structure of COUNTIF The standard syntax of countif function in excel is shown below; = COUNTIF(range,criteria) A range can be a single column with multiple rows or it could consist […]

How to use IF with MATCH function in Excel

In this tutorial, we’ll learn how to use IF with the MATCH function in Excel. First of all we’ll understand the syntax of both functions and then we’ll use an […]

What ALT + ENTER does in Excel (+How to use it)

Like Microsoft Word, while typing we can easily shift to the below line just by pressing enter key. While typing text in Excel we face a challenge, we can’t shift […]

How to round to the nearest penny in Excel

Suppose we have a value we want to round off to the nearest penny as shown above.

How to find today’s date in Google Sheet

In this tutorial we’ll learn to find out today’s date in Google sheets by using a simple formula. Let’s see how to do it;

How to use IFS in Google Sheets

We have marks obtained in a subject as our dataset and we need to provide grades. The dataset is shown below.

How to add cells to an Excel Worksheet

Adding a cell in excel is easy. There can be four options. So here we have a worksheet with different cells marked according to rows and columns.

How to subtract time in Excel

It may appear to be a simple notion to subtract some hours from a time value in Excel, but it is not as straightforward as it appears. This article will […]