Excel Functions

How to Count Rows with Formula in Excel (5 Quick Methods)

In this tutorial, I will explain some methods to count the number of rows using Excel Formula.  Usually, we can get the row count by simply clicking ...

How to Use ADDRESS Function in Excel (7 Suitable Examples)

The ADDRESS function in MS Excel is under the Lookup and Reference functions category. We use the ADDRESS function to get the address of a cell (e.g. ...

How to Use MMULT Function in Excel (6 Examples)

The MMULT function stands for “Matrix Multiplication”. It is a math and trigonometry function available in Microsoft Excel. The MMULT function ...

How to Use DCOUNT Function in Excel (5 Suitable Examples)

The DCOUNT function is a built-in function in Excel that is categorized as a Database Function. The DCOUNT function of Microsoft Excel is one of the ...

How to Use SLN Function in Excel (3 Examples)

The SLN function, an Excel Financial function, calculates the depreciation of an asset for one time period using the straight line method for ...

How to Use TRUNC Function in Excel (4 Examples)

The TRUNC function in Excel truncates a number to a specified number of digits. It is under the category of Excel Math and Trigonometry function. The ...

How to Use DGET Function in Excel (4 Examples)

For looking up values we often use the VLOOKUP or XLOOKUP functions but there are some limitations like we can’t look up a value based on multiple ...

How to Use TAN Function in Excel (6 Examples)

The TAN function is in the Trigonometry Functions list under the Math and Trig Functions category that calculates the slope of a tangent of an angle ...

How to Use NPV Function in Excel (3 Easy Examples)

The NPV Function is an Excel Financial function that calculates the Net Present Value (NPV) for a series of cash flows and a given discount rate. The ...

How to Use MODE Function in Excel (4 Examples)

The MODE function, an Excel Statistical function returns the most frequently occurring number from an array or set of numbers. MODE.SNGL function ...

How to Use Excel PMT Function (4 Quick Examples)

The PMT function is a Financial function in excel. Interestingly, the name PMT stands for ‘payment’. We can use this function to get the periodic ...

How to Use VAR Function in Excel (4 Examples)

The Excel VAR function is categorized as a Statistical function of Microsoft Excel. It determines the risk of any investment, hence, is important for ...

How to Use Excel QUOTIENT Function (4 Suitable Examples)

Excel QUOTIENT function falls under the Math & Trig category. The function takes two arguments: numerator (i.e., dividend) and denominator (i.e., ...

How to Use PROB Function in Excel (3 Examples)

In many real-life situations in business or games, we need to predict the result or output. The PROB function in Excel is a quite useful tool to do ...

How to Use SKEW Function in Excel (2 Examples)

The SKEW function in Excel calculates the skewness of a range of data. The skewness is the deviation of the normal distribution which is a ...

ExcelDemy
Logo