Functions

Many a time, while entering any formula in excel, you may have come across an error that says something about “Circular Reference”. In this blog,… Read Article

Have you wondered how to convert the rows into columns and columns into rows in Excel? This is what is called the “Transpose” function in… Read Article

Generally, tables in Excel have headings on the top (i.e. column headings). In that case, it is very easy to sort the data from top… Read Article

In this tutorial, we would learn one of the most important features of Excel that allows you to organize your Excel data table. The feature… Read Article

In this blog, we would learn how to create a drop-down list in excel. This tool is a very user-friendly tool and helps us in… Read Article

Do you know how to wrap a text in an excel cell? What is the purpose of Wrap text function in excel?… Read Article

Many times you have excel data where you want to do a partial match of the data. To perform a partial match of data in… Read Article

You might have heard about an amazing Excel Fill Handle Tool? Do you know what exactly is this Excel Fill Handle Tool? What benefit does… Read Article