Assume we have a problem where we want to give students grades based on their grades, such as if they got 90 to 100 percent, give them an "O", and if they got less than 50 percent, give them "L" grades. If we try to do this manually, it could be a very time-consuming process. We can solve this problem by using the many formulas supported by Excel at a very rapid rate. Read this tutorial to understand how you can assign a value based on a number in Excel. This process can be completed using two methods: ... Read More

Let us assume we have collected the data from a public source and you want to add the ID to each result. To do that, first we need to know how many unique items are present in the sheet. This tutorial will help you understand how you can assign a serial number to duplicate or unique values in Excel. Here we will have two parts. The first part is about assigning serial numbers to unique values, and the next part is about assigning serial numbers to duplicate values. Assigning a Serial Number to Duplicate Values in Excel Here ... Read More

A macro in Excel is used to automate the process that we use repeatedly. Using macros helps save time by solving the repeated process very rapidly. This article helps you understand how we can assign a hotkey to a specified macro in Excel. Generally, we find macros under the Developer menu in the Excel ribbon. Most systems will not have it. By default, we can add the developer to the Excel ribbon by customising the ribbon. To customise the ribbon, right-click on the ribbon and select "customise ribbon." Then, in the pop-up window, select the checkbox beside "Developer" ... Read More

Filters can be applied to a single sheet in Excel, but applying the filter to multiple sheets at once is not possible by default. But we can make it happen with the help of the VBA application. Read this tutorial to learn how you can apply the same filter to multiple sheets in Excel. Applying a filter is simply gathering data based on a single entity.  Applying the Same Filter to Multiple Sheets In this case, we'll insert a VBA module and then run the code to apply filer. Let us see a simple process to understand ... Read More

Generally, when we try to find a particular sentence, we always try to find it by using the first words of the text, but if we clearly understand the data, we can see most of the sentences will start with the same words, but they always end with different words. So, by searching for sentences using the last words rather than the first words, we can return fewer results than if we used the first words. So, we can list the last words of the sentences using this process. Read this tutorial to learn how you can apply ... Read More

We frequently use the "spell check" feature in Word, but have you ever tried to apply spell check for textboxes in Excel? This is not an inbuilt process for Excel; hence, we need to modify the textbox in order to complete our process. The spell check can’t be applied to normal textboxes; it needs to be an ActiveX command textbox, which will be present under the developer option in Excel. Read this tutorial to understand how you can apply spell check in an Excel textbox. Applying Spell Check in Excel Textbox Here we will first insert ... Read More

When we are using Excel, we want to add different colours to cells to create a design that can improve the neatness of the data. This also makes the excel sheet look nicer and allows for faster data analysis. This article will help you understand how we can apply colour shading to odd or even rows or columns in Excel. This can be done using a simple method in Excel by using conditional formatting and applying different colours. Read this tutorial to learn how you can apply shading to odd or even rows or columns in Excel. ... Read More

We have tried to apply the same formula to multiple cells in Excel many times. This is the most commonly used process in Excel to get the outputs for multiple cells at once. In Excel, there are several methods for applying the same formula to multiple cells; one method is to select multiple cells while using the formula for formatting and data validation. Then the other way of applying the same formula to multiple cells is to drag the result. Then drag in any direction: up, down, left, right, or any combination of these. Read this tutorial to ... Read More

You could have tried to apply the VLOOkUP function to get the values from the right side using the positive numbers, but have you ever tried to get the values from the left side using the VLOOkUP function using the negative values? When we try to use the VLOOKUP for negative values, an error will occur. To solve this problem, we need to apply the VB code to the Excel sheet. Read this tutorial to learn how you can apply negative VLOOKUP to return the value on the left of the key field in Excel. Apply Negative VLOOKUP to ... Read More

Applying a single data validation to the cells in Excel is a very simple and frequently used process, but have you ever tried applying multiple data validations to a single cell at the same time? Read this tutorial to learn a simple way to apply multiple data validation rules in one cell in an Excel worksheet.  Applying Multiple Data Validation in One Cell We will use a single formula to perform multiple data validations. Let's look at a quick way to apply multiple data validations in one cell in Excel. The problem we solve in this article ... Read More