# Full list of Excel functions

**Description :**

This is a complete alphabetical list of all the Functions in Excel with a description. To see the syntax and a more in-depth description, the function is a link to the Microsoft Excel site.

Download the complete list.

**FUNCTION** **TYPE AND DESCRIPTION**

**ABS** function Math and trigonometry: Returns the absolute value of a number

**ACCRINT** function Financial: Returns the accrued interest for a security that pays periodic interest

**ACCRINTM** function Financial: Returns the accrued interest for a security that pays interest at maturity

**ACOS** function Math and trigonometry: Returns the arccosine of a number

**ACOSH** function Math and trigonometry: Returns the inverse hyperbolic cosine of a number

**ADDRESS** function Lookup and reference: Returns a reference as text to a single cell in a worksheet

**AMORDEGRC** function Financial: Returns the depreciation for each accounting period by using a depreciation coefficient

**AMORLINC** function Financial: Returns the depreciation for each accounting period

**AND** function Logical: Returns TRUE if all of its arguments are TRUE

**AREAS** function Lookup and reference: Returns the number of areas in a reference

**ASC** function Text: Changes full-width (double-byte) English letters or katakana within a character string to half-width (single-byte) characters

**ASIN** function Math and trigonometry: Returns the arcsine of a number

**ASINH** function Math and trigonometry: Returns the inverse hyperbolic sine of a number

**ATAN** function Math and trigonometry: Returns the arctangent of a number

**ATAN2** function Math and trigonometry Returns the arctangent from x- and ycoordinates

**ATANH** function Math and trigonometry: Returns the inverse hyperbolic tangent of a number

**AVEDEV** function Statistical: Returns the average of the absolute deviations of data points from their mean

**AVERAGE** function Statistical: Returns the average of its arguments

**AVERAGEA** function Statistical: Returns the average of its arguments, including numbers, text, and logical values

**AVERAGEIF** function Statistical: Returns the average (arithmetic mean) of all the cells in a range that meet a given criteria

**AVERAGEIFS** function Statistical: Returns the average (arithmetic mean) of all cells that meet multiple criteria.

**BAHTTEXT** function Text: Converts a number to text, using the ß (baht) currency format

File Size : |
150.64 Kb |

Downloads : |
6386 |

Submitted On: |
2017-10-09 |

Take advantage of this course called **Full list of Excel functions** to improve your **Office** skills and better understand .

This course is adapted to your level as well as all pdf courses to better enrich your knowledge.

All you need to do is download the training document, open it and start learning ** ** for free.

This tutorial has been prepared for the beginners to help them understand basic ** Office**. After completing this tutorial you will find yourself at a moderate level of expertise in from where you can take yourself to next levels.

This tutorial is designed for ** ** students who are completely unaware of ** ** concepts but they have basic understanding on **Office** training.

Download free Microsoft Word 2016 course material and training (PDF file 214 pages)

Free Microsoft Word 2013 Keyboard Shortcuts in PDF for download ,a free training document under 20 pages to make Word easy to use and understand.

Download Publisher 2016 PDF tutorial by techtutor under 10 pages intended to beginners.

Download free Spring tutorial course in PDF, training file in 18 chapters and 68 pages. Free unaffiliated ebook created from Stack OverFlow contributor.

This PDF tutorial shows how to construct a complex application in Microsoft Access ,free training lesson under 154 pages by Soren Lauesen designated to the intermediate level-user.

Download free Scripting Adobe Photoshop tutorial in PDF , a complete guide under 87 pages designated to intermediate level-users.