Excel Functions

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 and, hence, is important ...

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)

Here's an overview of the PROB function in Excel. What Is Probability? Probability defines the chance of occurrence of an event. There ...

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 LOG Function in Excel: 10 Methods

Method 1 - Using LOG Function in Excel with Default Base Argument (Log10) Apply the LOG function without specifying the base argument; then it is ...

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 we need to count the number of non-empty cells in a given database, the Excel DCOUNTA function is the perfect function for the job. In this ...

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 the Excel GROWTH Function – 4 Methods

The GROWTH Function in Excel Summary The GROWTH function is a statistical function in Excel. It is used to calculate predictive exponential ...

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 the Excel SWITCH Function (5 Examples)

Method 1 - Using the Excel SWITCH Function to Switch Corresponding Cell Values Steps: Enter the following formula in cell F4: ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo