How to Merge cells in Microsoft Excel? There are different methods we can merge cells in Excel. One of the most used methods is utilizing the Merge & Center option in the Home tab. The issue with using Merge & Center is that it can combine the cells, but not the text within these cells.…
Read more
How to create a drop-down list in Excel? A drop-down list is an outstanding way to give the client an option to choose from a pre-defined list. It very well may be utilized while getting a client to fill a structure or while making an intuitive excel dashboard. Drop-down lists are very regular on social…
Read more
How to Find and Remove Duplicates in Microsoft Excel? Finding Duplicates 1. For finding the duplicates, we will be utilizing the conditional formatting function. In this example, we need to discover if any name has been frequently. So first, we will choose the Name column. 2. Press on the conditional formatting option accessible at the…
Read more
Excel ISNA Function ISNA function helps to get rid of #N/A code error Using ISNA function we can tell Excel to leave the cell blank or to display any desired text like “not found” instead of displaying #N/A code error. See how the function is used in the example: The function is =if(isna(vlookup(E4,list1,2,false)),“”,vlookup(E4,list1,2,false)) =if(isna(vlookup(E4,list1,2,false)),””,vlookup(E4,list1,2,false))<br />…
Read more
What is a Pivot Table? A pivot table is a data summarization device that is utilized in the context of data handling. Pivot tables are utilize to summarize, sort, rearrange, group, check, aggregate, or standard record stored in a database. It permits its clients to change columns into rows and rows into segments. It permits…
Read more
Excel Vlookup Vlookup is an advanced Excel function that helps extract values from the database. Vlookup can filter large volume of data to provide the appropriate values based on the given conditions. V lookup can be used in two ways, to find an exact match and to find the closest match. In this example, it…
Read more
Excel sumif Function The SUMIF function is used to sum up the values of some specific cells of a column, the cells which meet certain criteria. The syntax of SUMIF function is: =SUMIF(range,criteria, [sum_range]) =SUMIF(range,criteria, [sum_range])<br /> So, the SUMIF function has three main parts: Range: It refers to range of cells that you want to…
Read more
Excel Macros By using Macro we can record a task. It is very useful when you have a task that you need to perform repeatedly. It speeds up the procedure and assures accuracy. How to open a macro: Open View tab. On the right end of the Ribbon you will find the macro button. Click…
Read more
Excel Advanced If Functions =IF (AND(B3>50,C3>50),B3+C3,B3*C3) The IF function says if values of both cells B3 and C3 are greater than 50 then add these cells else multiply these cells. See the image given below. =IF(B4>AVERAGE(C4:C9),”cell B4>average”,””) The IF function says if value in cell B4 is greater than the average of the cells from…
Read more
How to use COUNT, COUNTIF, and COUNTIFS Function? Excel COUNT The COUNT function returns the absolute number of cells that include numbers. This count contains both Numbers and Dates. Syntax COUNT (value1, [value2]…) COUNT (value1, [value2]…)<br /><br /> Where the parameters, value1, [value2], etc. can be any values or authority to cell ranges. Example 1: The following…
Read more