Itech Education

Showing posts with the label Ex AppShow all

Divide Function in excel

To do this task, use the / (forward slash) arithmetic operator. For example, if you type =10/5 in a…

Multiplication in excel

Multiply a column of numbers by a constant number Type =A2*$B$2 and press enter.

Subtract Function in Excel | Subtract numbers in excel

There is no specific function for SUBTRACT value in Excel. Use the SUM function and convert any num…

Mixed Cell References in Excel?

Mixed cell references are more-tricky than the absolute cell references if we compare. There can be…

Absolute Cell References in Excel?

Absolute cell references are useful when you don’t want the cell reference to change as you copy or…

FV Function in Excel | Financial Formula

FV, one of the financial functions which is calculates the future value of an investment based on a…

PV Function in Excel | Financial Function in Excel

PV, one of the financial functions in excel, calculates the present value of a loan or an investmen…

PPMT Function in excel | Financial Formula

The PPMT Function is categorized under Excel Financial functions. The Excel PPMT function can be u…

IPMT Function in Excel | Excel Financial Formula

What is the IPMT Function? The IPMT Function is categorized under Financial functions in MS Exce…

PMT Function in Excel | Advance Excel Course

"PMT" stands for "payment", hence the function's name. The PMT Function is …

REPT Function in Excel | Advance Excel Course

The REPT Function is categorized under Logical functions in MS Excel. The function will repeat char…

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…

Index and Match Function in Excel | Advance Excel Course

The INDEX MATCH Formula is the combination of two functions in Excel which is INDEX and MATCH. INDE…

HLOOKUP Function in Excel | Advance Excel Course

HLOOKUP stands for ‘Horizontal Lookup’. It is a function in Excel that makes search for a certain v…

VLOOKUP Function In Excel | Advance Excel Course

VLOOKUP stands for Vertical Lookup, The VLOOKUP function performs a vertical lookup by searching fo…

LOOKUP Function in excel | Advance Excel Course

The Microsoft Excel LOOKUP function is one of the most popular functions of MS Excel. This Functio…

Frequency Function in Excel | Advance Excel Course

The FREQUENCY function in Excel help you to calculating the frequency (no of repeated value) of a d…

SUBSTITUTE function in Excel | Advance Excel Course

The SUBSTITUTE function in Excel replaces text in a given string by the matching string. The SUBSTI…

PRODUCT and SUMPRODUCT Function in Excel | Advance Excel Course

This Excel tutorial explains how to use PRODUCT and SUMPRODUCT function in Excel with syntax and ex…

SUBTOTAL Function in Excel | Itech Education

The SUBTOTAL function in Excel is very helpful to analyze data of provided range. The SUBTOTAL Fu…