Microsoft Excel

The IFERROR function is designed to handle errors resulting from formulas in Excel. The IFERROR function is a logical formula that is used to detect errors in formulas and returns an alternate value or performs another calculation in place of the error. If the formula nested inside the IFERROR function results in an error, the IFERROR function catches that error and returns a specified value in its place.

Excel shows errors whenever there’s something wrong with the formula or the cell it’s referencing, however, sometimes the error is unavoidable. Having an error not only makes your spreadsheet

When working with a large spreadsheet, there are times when you may want to count the number of unique values in an Excel range. For instance, when you want to make a report of the number of customers who purchased your products only once or a number of students who only won in one event or remove duplicates from the order list and count only the unique items. Whatever the cases, it can be helpful to know how many unique values (or distinct) are in a column.

Although Excel does not have any pre-defined formula or options to count unique

The Search function is a text function that searches for a specific character or sub-string within another string or text and returns its position. In other words, it locates a word within another word and its position in the cell as an integer.

For instance, if you use the SEARCH function to find the position of the letter ‘s’ or the text ‘son’ in the word “Jackson”, it will return 5. It will only return the starting position of the search string in the searched cell.

The SEARCH function is rarely used alone, it is often used along with FIND,

The INDEX function is one of the most used functions in Excel that is categorized as a Lookup/Reference Function. The INDEX function is used to extract a value or reference of a cell in an array or range based on the row number and column number you specified. It can also be used to extract entire rows and columns in a table.

For instance, we have a table of 700 rows and 100 columns and we want to return the value at the 522nd row and 50th column. To do this you don’t need to scroll down hundreds

Formatting is a great way to make the contents of Excel cells more striking and stand out from the rest of the content. When you are working with large Excel sheets, you may apply various formatting to the cells such as changing cell color, font color, borders, alignment, number formatting, date formatting, conditional formatting, and others to customize your spreadsheet’s appearance.

Also, if someone shared a worksheet or you acquired your worksheet online, it’s more likely to be formatted. In such cases, you may like to apply different formatting or remove existing formatting from the sheet. However,