If you want to locate the placement of the lookup value then you need to use Excel Match function. The Match function will offer you an approximate and exact match whereas wildcards are used for partial matches. When you want to retrieve the value of the position which is

Read More

In our previous post, we have already cover Excel Match function. The Match function in excel returns the position of an item in array whereas the Index function in Excel returns the value present in that position in the array. Hence if you want to extract any value from an

Read More

Here we have provided the step by step process on how to find duplicates in excel. When you are working on a large number of data then you will encounter few duplicate entries. Sometimes these duplicate values are very useful but many times you want to remove the duplicate

Read More

There are various excel formulas basic including excel subtraction formula and advanced available in Microsoft Excel that you can use for different purposes. You might have used sum and average functions in excel as its icon is available at Excel ribbon. But you will not

Read More

Here you can see how to insert bullets in Excel. If you are a daily user of Microsoft tools, then surely, you must have seen bullets in MS Word. Like bullet points in Word, Excel does not offer a direct and bullet point shortcut method to add a bullet. But to add the bullet

Read More

To know everything about excel slicer, continue reading this page. In Excel, you will find numerous functions and formulas available like excel macros, vlookup, hlookup, and many others. Slicers are basically used to filter pivot tables easily and quickly. The Slicer is the

Read More

There are various ways to use Excel Hyperlink. Similarly like MS Word or a website, you can also create a hyperlink in Excel. The hyperlink is used whenever you want to switch the sheet or you want to show things that are not available at the same place. Here you can check

Read More

Here you can check how you can perform filtering in excel to sort the data and to find the data. You can filter your excel data whichever meet the certain criteria and displays the records that you want to show. Along with filtering of data, you can also check the sorting of

Read More