How to add new sheet in workbook by using shortcut

Microsoft Excel is a very useful and powerful data analyzing software developed by a famous company named Microsoft Corporation. It can perform various tasks from basic simple arithmetic operations to […]

How to use SUMIFS greater than in Excel

In today’s tutorial we’ll learn how to use the SUMIFS function in Excel to add all those values which are greater than a particular value. Let’s look at the dataset […]

How to use SUMIF less than in Excel

In today’s tutorial we’ll learn how to use the SUMIF function in Excel to sum all those values which are lesser than a specific value. Let’s look at the dataset […]

How to use SUMIF greater than in Excel

In today’s tutorial we’ll learn how to use the SUMIF function in Excel for all those values which are greater than a specific value. Let’s look at the dataset given […]

How to calculate average of percentages in Microsoft Excel

In today’s tutorial, we’ll learn how to calculate the average of the percentages of given data. Let’s begin by looking at the dataset below. It contains information about students regarding […]

How to collapse all pivot table fields in Excel

A pivot table is a tool in Excel that allows you to summarize and organize large amounts of data. It allows you to rotate rows and columns to see different […]

How to sum colored cells in Excel

We are going to learn how to Sum Colored cells by all below mentioned methods in Excel. Let’s take a look at the following sales dataset shown above.

How to generate random name pairs in Excel

Here is the dataset and it contains two lists of names and we’ll learn to create a method using Excel’s built-in functions to generate a list of random name pairs.

How to generate random numbers without repetition in Excel

In today’s tutorial we’ll learn how to generate random numbers from 1 to 100 without any repeats or duplicates. We’ll use the following functions of Excel one by one.

How to remove filters in Excel

In today’s tutorial we’ll learn how to remove filters from the data. Let’s see the dataset above on which the filters have already been applied. Now when we talk about […]

How to use ISBLANK in Google Sheets

How to use Absolute Reference in Google Sheets

The “$” sign is also one of these special characters and it is used in formulas to create an Absolute Reference to the cell. Absolute Reference, when used with a […]

How to edit named range in Excel

In today’s tutorial we’ll learn how to edit the named range in Excel. Let’s see the dataset below which has two named ranges i.e., “Islamabad” and “Multan”. Now we’ll see […]

How to move Excel rows

You can watch a video tutorial here. Excel is a popular spreadsheet application in which the workspace is arranged as rows and columns in the form of a grid. Each […]

How to move everything down one row in Excel

You can watch a video tutorial here. Excel is a popular spreadsheet application in which the workspace is arranged as rows and columns in the form of a grid. Each […]