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

Download File


Microsoft Word 2013

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

Download

Word 2013 Keyboard Shortcuts

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

Microsoft PowerPoint 2007

This PDF tutorial is aimed at beginner who wants to creat their own PowerPoint presentation ,easy course with illustrative images,free training lesson under 14 pages by Dawn Rauscher.

Download

Introductionto the Assembly Language

This tutorial represente a brief introduction to assembly programming ,training courses in PDF under 77 pages designated to beginners.

Download

Introduction to programming with Fortran 95

Introduction to programming with Fortran 95. This tutorial aim to provide an introduction to programming with Fortran 95. Fortran is particularly suitable for science and engineering.

Download

C++ ,Pointers and Memory

This tutorial explains how to use pointers and memory and how the pointer works.A complete training document in PDF with sample code By Nick Parlante.

Download