MS Excel Formulas

The PV function in Excel is used to calculate the present value of an investment based on a series of […]

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

The IPMT Function is categorized under Financial functions in MS Excel. The IPMT function in Excel is used to calculate

The SUBSTITUTE function in Excel is a text function that allows you to replace instances of a specific text string

The REPT function in Excel is a text function that allows you to repeat a given text string a specified

In Microsoft Excel, the keyboard shortcut CTRL+E is used to activate the Flash Fill feature. Flash Fill is a tool

The FIND function in Excel is a text function that allows you to find the position of a specified substring

MID Function splits the data from the middle of the character. If you want to remove any character from left

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

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