Excel Functions

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 Methods

Method 1 - Using the DGET Function with One Criterion in Excel Steps: Activate Cell C12. Type the following formula- ...

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 the Excel PMT Function – 4 Examples

Introduction to the Excel PMT Function Summary The PMT function calculates the payment for a loan based on a constant interest rate. For ...

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 INDIRECT Range (8 Easiest Ways)

To explain the INDIRECT function, we'll use a dataset that represents sales information for 4 quarters. The dataset has 5 columns: Salesperson, ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo