Index Function in Excel | Advance Excel Course
INDEX() returns the value of a cell in a table based on the column and row number. The INDEX funct…
Read more
MID Function in Excel | Advance Excel Course
MID Function splits the data from the middle of the character. If you want to remove any characte…
Read more
Right Function in Excel | Advance Excel Course
The RIGHT function in Excel is a text function that allows you to extract a specified number of cha…
Read more
Left Function in Excel | Advance Excel Course
The LEFT function in Excel is a text function that allows you to extract a specified number of char…
Read more
Lower Function in Excel | Advance Excel Course
You can convert your text into deferments cases such as upper case, lower case and proper case if y…
Read more
Proper Function in Excel | Advance Excel Course
You can convert your text into deferments cases such as upper case, lower case and proper case if y…
Read more
UPPER Function in Excel | Advance Excel Cours
You can convert your text into deferments cases such as upper case, lower case and proper case if y…
Read more
PRODUCT function in Excel
The PRODUCT function in Excel is used to multiply numbers together. It takes one or more arguments,…
Read more
Divide Function in excel
In Excel, the "Divide" function is not available as a pre built-in function. However, you…
Read more
Multiplication Operator in excel
in excel, there are two method to find out multiplication of the numbers. To multiply two or more …
Read more
Subtract Function in Excel | Subtract numbers in excel
There is no specific function for SUBTRACT value in Excel, The subtract operator in Excel is used t…
Read more
Mixed Cell References in Excel?
Mixed cell references are more-tricky than the absolute cell references if we compare. There can be…
Read more
Absolute Cell References in Excel?
Absolute cell references are useful when you don’t want the cell reference to change as you copy or…
Read more
FV Function in Excel | Financial Formula
FV, one of the financial functions which is calculates the future value of an investment based on a…
Read more
PV Function in Excel | Financial Function in Excel
The PV function in Excel is used to calculate the present value of an investment based on a series …
Read more
PPMT Function in Excel | Financial Formula
The PPMT Function is categorized under Excel Financial functions. The PPMT function in Excel is us…
Read more
IPMT Function in Excel | Excel Financial Formula
The IPMT Function is categorized under Financial functions in MS Excel. The IPMT function in Exce…
Read more
PMT Function in Excel | Advance Excel Course
"PMT" stands for "payment", hence the function's name. The PMT Function is …
Read more
REPT Function in Excel | Advance Excel Course
The REPT Function is categorized under Logical functions in MS Excel. The function will repeat char…
Read more
FIND Function in Excel | Advance Excel Course
FIND function in Excel returns the position (as a number) of one text string inside another cell an…
Read more
