MS Advance Excel Course

“PMT” stands for “payment”, hence the function’s name. The PMT Function is categorized under financial functions in MS Excel. This function helps you to calculate the EMI (principal and interest) required to settle a loan or an investment with a fixed interest rate over a specific time period. Syntax: =PMT(rate, nper, pv, [fv], [type]) Arguments: […]

The PROPER function in Microsoft Excel is used to capitalize the first letter of each word in a given text string. It converts the rest of the letters in each word to lowercase. This function is especially useful for formatting names, titles, or any text where proper capitalization is required.   Syntax =PROPER(text) text: This

The LOWER function is a text function used to convert all the letters in a text string to lowercase. This function is helpful when you need to ensure that text is consistently in lowercase format, regardless of how it was originally entered. Syntax =LOWER(text) text: This is the text string that you want to convert

Learn how to easily convert text to capital letters using Excel’s UPPER function. 🧠 क्या सीखेंगे: What is UPPER Function? Why is it useful? How to use it with examples? Practice Assignments The UPPER function is a text function that is used to convert all the letters in a text string to uppercase. This can

When you invest your money such, you can earn interest on your investment amount. for example, you invest $3,000 with a 10% annual interest rate, compounded annually. One year from the initial investment (called the principal), you earn $300 ($3,000 x 0.10) in interest, so your investment is worth $3,300 ($3,000 + $300). For the

Len function is used to measure the length of text in excel. Len function… measures the length of the text by counting all the characters. Along with the characters inside the Len function, if any space is given in the cell or special characters, symbols or numbers, then it also counts them. Syntax- =Len(text) Argument-

TRIM () Function In Excel This is a Pre-Defined Function of Excel and it is used to remove extra space from Text or Characters in Excel. The TRIM function keeps only one space between the text or characters and finds and removes all the extra blank space. Syntax- =TRIM(text) Arguments- Text– In this argument, we

Concatenate Function in Excel is placed under Text Category and this function is used to join two or more values ​​(Characters, Strings or Numbers) together. Like- First Name and Last Name are given in two different columns and if you want to merge them in one column then you can use Concatenate function in excel

IF ERROR Function In Excel In Hindi, Microsoft – IF ERROR in Excel is a pre-defined functions IF ERROR Function is placed under the category of logical function in Excel. IF ERROR FUNCTION is used to display the correct result or message in response to the error of a FUNCTION. IF ERROR Function in Excel

FV, one of the financial functions which is calculates the future value of an investment based on a constant interest rate. You can use the FV function to get the future value of an investment assuming periodic, constant payments with a constant interest rate. Syntax =FV(rate, nper, pmt, [pv], [type])   Arguments rate – The