Recently, one of my students raise the query “How to compare two columns in excel?” There are many ways to perform compare two columns in excel including Vlookup function in excel, Conditional formatting, If Statement, and other simple methods. Depending on your

Read More

The SumIf function returns the summation of all the numbers who met the particular criteria. You have to use this SUMIF function in Excel which is also known as worksheet function. The function is used to add the value of all the cells depending on date, text, and numbers.

Read More

Microsoft Excel has many in-built Excel functions list that let you perform calculations and return information about the spreadsheet. These in-built functions are used for performing complex calculations. Here you can see in-built functions for MS Excel that you can use for

Read More

Excel Formulas Basic Function: The formula is a unique code which you can enter into the cell. The formulas will let you perform calculations and will give you an exact outcome. In formulas, you will find various operators and functions that you can use on values and text.

Read More

With the drop-down list, you can help people work efficiently. He or she can pick items from the list easily. So if you want to create dropdown list in excel, then do follow the step-by-step process and create the drop-down list easily. In fact, you can add and remove items

Read More

The table converts your data list into Excel tables that consist of many features by which you can sort or filter data set according to your preference. You can organize your data efficiently as well as view your data whenever you want to see. This is an excellent source to

Read More

If you are protecting a worksheet, then that means you are locking all the cells. You cannot perform any editing on those cells. To perform the editing of the cells, you need to unlock those cells. Now you must be in a hurry to know how to lock cells in Excel so they don’t

Read More

When you want to perform any decision-making task then you always thought of If statement. If the statement is used to make the decision on the basis of certain criteria, it evaluates an expression and gives you an outcome. In the post, you will be going to see how to use

Read More