Tag: Basic Excel

The IPMT Function is categorized under Financial functions in MS Excel. The IPMT function in Excel is used to calculate the interest payment of an …

The SUBSTITUTE function in Excel is a text function that allows you to replace instances of a specific text string within another text string. This …

The REPT function in Excel is a text function that allows you to repeat a given text string a specified number of times Syntax =REPT(text, …

In Microsoft Excel, the keyboard shortcut CTRL+E is used to activate the Flash Fill feature. Flash Fill is a tool that automatically fills values in …

The FIND function in Excel is a text function that allows you to find the position of a specified substring within a text string. It …

MID Function splits the data from the middle of the character. If you want to remove any character from left or right from a cell …

The RIGHT function in Excel is a text function that allows you to extract a specified number of characters from the right side of a …

The LEFT function in Excel is a text function that allows you to extract a specified number of characters from the left side of a …

The PRODUCT function in Excel is used to multiply numbers together. It takes one or more arguments, separated by commas, that represent the numbers or …

The SUMPRODUCT function in Excel is used to multiply corresponding elements in two or more arrays, and then sum the results. It can be used …