Excel Functions

How to Use DELTA Function in Excel (3 Practical Examples)

Indeed, Microsoft Excel is a highly effective program. We can execute continuous operations on a given dataset using Excel's tools and capabilities. ...

How to Find Inverse Cosine of a Number in Excel (3 Easy Methods)

We may want to find the value of the inverse cosine of a number which gives an angle as a result. The result can be in radian or degrees. We can ...

How to Arcsine Transform Data in Excel (4 Handy Methods)

If you want to know about how to arcsine transform data in Excel, this article is for you. Here, we will walk you through 4 handy and effective ...

FIND and SEARCH Function in Excel (2 Comparison Studies)

It is a very common occurrence to find the position of a particular character or text within a string. This is helpful for data analysis purposes ...

44 Mathematical Functions in Excel (Download Free PDF)

1. The AVERAGE Function Function Objective: The AVERAGE function calculates the average of numbers in a range of cells. Syntax: ...

How to Use ADDRESS Function in Excel?

In this article, we will learn about the ADDRESS function in Excel. We will also explore how to return cell value by address, cell address instead of ...

How to Use MMULT Function in Excel (6 Examples)

The MMULT function stands for “Matrix Multiplication”. It is a math and trigonometry function available in Microsoft Excel. The MMULT function ...

How to Use DCOUNT Function in Excel (5 Suitable Examples)

The DCOUNT function is a built-in function in Excel that is categorized as a Database Function. The DCOUNT function of Microsoft Excel is one of the ...

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

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo