Home » Office » Full list of Excel functions

# Full list of Excel functions 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.

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

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.

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.

Tutorials in the same categorie :

## Guide PowerPoint 2013

Guide of Microsoft Powerpoint 2013 in PDF a quick references card to learn the basics of PowerPoint,a free tutorial for download and training document

## Microsoft Word 2013

Download courses Microsoft Word 2013 in PDF ,a free training document under 15 pages for beginners.

## Microsoft Word 2103 Step by Step

This PDF tutorial provides invaluable handson experience for who want to learn about new features in Word 2013 .It's a free and complet training docum

## AJAX basics

This tutorial provides some basics Ajax process ,training document in PDF under 38 pages for beginners.

## COBOL Programming

Download COBOL tutorial in PDF,a free training courses under 236 pages to learn the basics of COBOL language

## Rust tutorial in PDF

Download free Rust tutorial course in PDF, training file in 50 chapters and 184 pages. Free unaffiliated ebook created from Stack OverFlow contributor

## Cobol programmer's guide

Download a complet PDF tutorial about Cobol for programmers ,it shows you how to develop COBOL programs that use the database languages SQL and PL/SQL

## Excel 2016 Shortcuts

With this reference, you will learn how to use easily Microsoft Excel 2016, all keyboard shortcuts that you need to work as a professional. Free trai

## iOS Development Tutorial

Learning how to build application with IOS editor.Free PDF tutorial for beginners.