We have always formatted the cells in Excel based on the formula that is dependent on its own row or column, but have you ever tried formatting the rows or columns that are dependent on the other row or column? It is possible by making some simple changes to the ... Read More

Assume we have a list of texts where each cell contains multiple words and another list that contains words from the other list, and you want to highlight the cells where these words are present so we can use conditional formatting searches for multiple words to solve the problem in ... Read More

Have you ever tried comparing the data on two different work sheets? Yes, it is possible to compare data from two different sheets in Excel. Let us assume we have two lists that contain the current prices of stocks and the price of a stock last month for a list ... Read More

You could have used conditional formatting in Excel very frequently, but have you ever tried applying conditional formatting across different work sheets in Excel? Yes, it is possible to apply conditional formatting across worksheets or workbooks in Excel; it is a very simple process. This tutorial will help you understand ... Read More

You could have added different colours to cells in Excel, but have you tried adding different shades of the same colour to the cells? It is possible to add shades of the same colour to the spreadsheet cells. Adding shades of the same colour will look better than using different ... 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 color-banded ... Read More

We could have created many types of charts in Excel and customised them to get our output, but the customization of charts could be a time-consuming process. If there is any type of chart that we will be using more frequently and which is not the default type in Excel, ... Read More

Have you ever tried to access the data in two workbooks at once? You could have compared data in two sheets of the same workbook using the VLOOKUP function. We can also connect the two worksheets in Excel. This process can’t be completed using the formulas; we will need to ... Read More

Maintaining the value of a particular item at every instance of time is a very crucial process if the prices of the item change very frequently. If we want to note the value of an item in particular intervals, then we need to create a list that contains the time ... Read More

An email address of a person, in most cases, is generally a combination of the first and last name, ending with the host details such as @gmail.com, @yahoo.com, etc. Suppose we have an Excel sheet with two columns containing the first and last names of employees, then we can easily ... Read More