Excel Functions

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 ...

How to Use Excel LOG Function (5 Easy Methods)

The LOG function is categorized as a Math & Trigonometry function in Excel. Besides that, it is also a worksheet function; which means it can be ...

How to Use CODE Function in Excel (5 Examples)

The CODE function, an Excel Text function returns a numeric code for the first character of a text string. The returned numeric code is based on the ...

How to Use DCOUNTA Function in Excel (5 Examples)

When you need to count the number of non-empty cells in a given database, you may utilize the Excel DCOUNTA function. In this article, I’ll exhibit ...

How to Use Excel STDEV Function (3 Easy Examples)

The standard deviation of any data collection can be calculated using the STDEV function in excel. The standard deviation displays how far one value ...

ExcelDemy
Logo