Category: MS Advance Excel Course

The PPMT Function is categorized under Excel Financial functions.  The PPMT function in Excel is used to calculate the principal payment of an investment in a specific payment …

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 …