Using Format Painter Feature in Excel

In this blog, we would learn an amazing excel feature called Format Painter. The Format Painter feature is a tool that can help you to quickly apply the formatting of the range of cells to some other location in Excel. This would save a lot of your time.

AutoFit Column Width and Row Height in Excel

This amazing blog aims at unlocking various techniques to AutoFit the row height and column width of Rows and Column in Excel. There are various methods available in Excel using which you can AutoFit the row height and column width in Excel.

Using =IF() Function For Partial Match in Excel

In one of our previous blogs, we learned how to use the =VLOOKUP() function for Partial Match in Excel. To explore it, follow our previous blog on “Using =VLOOKUP() Function for Partial Match in Excel“. In this blog, we would explore and unlock the technique to use the =IF() function for a partial match in Excel. Many a time, you have an excel worksheet where you want to use the =IF() function in such a way that it should return the values even for a partial match of string in Excel.

All About Circular Reference in Excel

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, we would learn bits and pieces of “Circular Reference” in Excel.

2 Ways to Use Transpose Function in Excel

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 excel. There are 2 ways of using Transpose in Excel.

In this blog, we would unlock the ways to change the orientation of dataset.

Sort Rows in Excel – Sort from Left to Right

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 to bottom. But, many a time, you may a table where the headings are on the left of the table. That means instead of the column heading, you have row headings. You cannot sort by the rows in excel directly. Then, how can you achieve this? In this tutorial, we would learn to sort the table by rows in Excel. To sort the table from left to right, we need to first make some changes in the settings so that excel can sort the table from left to right.

How to Sort a Table or Data in Excel

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 about which I am taking is the “Sorting” feature of Excel. There are multiple ways in which you can sort a table or data in Excel.