Excel Functions

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

How to Use Excel PPMT Function (3 Suitable Examples)

The Excel PPMT function falls in the financial functions category. PPMT calculates periodic payments on loans or investments that have a specified ...

How to Use GAMMA Function in Excel (With Example)

The Gamma function is widely used in science, business, and engineering. It is useful for the variables which are always positive. For example, the ...

How to Use FV Function in Excel (4 Easy Examples)

The FV function is a default function of Microsoft Excel which is categorized as a financial function. It helps to figure out the future value of an ...

How to Use EFFECT Function in Excel (2 Examples)

This EFFECT function is a financial function of Microsoft Excel. It is calculated based on the nominal rate of interest and compound periods in a ...

How to Use Excel GROWTH Function (4 Easy Methods)

The GROWTH function is a built-in function of Microsoft Excel. Besides, we can use this function in financial statistics, regression analysis, and ...

How to Use Excel PI Function (7 Examples)

In Microsoft Excel, the PI function returns the mathematical constant π (Pi). It is approximately equal to 3.1416. This article explains the PI ...

How to Use Excel SWITCH Function (5 Examples)

To switch a particular value with the value of your choice you can use the Excel SWITCH function. It is a comparison and referencing function in ...

How to Use Excel FREQUENCY Function (6 Examples)

In Excel sheets, we store various types of data to get the insight of data. Sometimes to analyze any data you may need to calculate the frequency of ...

How to Use TIMEVALUE Function in Excel (4 Examples)

Excel TIMEVALUE function (a date & time function) converts a text time in a decimal number between 0 (12:00:00 AM) to 0.999988426 (11:59:59 PM). ...

How to Use TREND Function in Excel (3 Examples)

The TREND function is a Statistical function in Excel. In this article, we will show you how to use Excel’s TREND function with 3 examples. ...

How to Use Excel NORMDIST Function (2 Applications)

In this article, we will get familiar with the Excel NORMDIST function. We can use this function in statistics as well as hypothesis testing. We will ...

ExcelDemy
Logo