Excel Functions Archives

How to Use SLN Function in Excel (3 Examples)

Jan 13, 2022 Excel Functions

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)

Jan 12, 2022 Excel Functions

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)

Jan 11, 2022 Excel Functions

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)

Jan 12, 2022 Excel Functions

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)

Jan 11, 2022 Excel Functions

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)

Jan 13, 2022 Excel Functions

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)

Jan 10, 2022 Excel Functions

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)

Jan 10, 2022 Excel Functions

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)

Jan 10, 2022 Excel Functions

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)

Jan 9, 2022 Excel Functions

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)

Jan 9, 2022 Excel Functions

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)

Jan 9, 2022 Excel Functions

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)

Jan 10, 2022 Excel Functions

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)

Jan 9, 2022 Excel Functions

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)

Jan 9, 2022 Excel Functions

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