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.

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

 

Size150.64 Kb
File typepdf
Downloads8456
Created2017-10-09
Cover of Full list of Excel functions

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

  • Microsoft Excel Tips & Tricks

    These are some of my favorite tips and power features that’ll get you well on your way to ‘Excel Guru Status’ giving you not only the recognition you deserve, but also making your work more enjoyable....

  • Microsoft Excel 2016 Course for Beginners

    Looking for Excel 2016 tutorials? this page is a free training document of Excel 2016 courses, in pdf....

  • Microsoft Excel 2013 course

    Download free Microsoft Office Excel 2013 file under 505 pages,step by step to learn Excel and build your skills , course tutorial training on pdf by Curtis D. Frye....

  • The Beginner’s Guide to Microsoft Excel

    This is a free Excel PDF tutorial in 11 chapters and 23 pages. This course aims to give students the basics of Microsoft Excel tips and trics. ...

  • Quick guide to PowerPoint 2010

    This pdf tutorial will help you understand PowerPoint 2010 features and create presentation for school or work. I will show you how to use each feature step by step so you you will learn PowerPoint 2010 easily and efficiently....

  • Download Publisher 2016 PDF tutorial

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

  • Excel VBA tutorial for professionals

    Download free VBA tutorial course in PDF, training file in 31 chapters and 128 pages. Free unaffiliated ebook created from Stack OverFlow contributor....

  • Excel Basics: Microsoft Office 2013

    This course is intended to beginning computer users. You are only expected to know how to use the mouse and keyboard, open a program, and turn the computer on and off. You should also be familiar with the Microsoft Windows operating system....

  • Publisher 2016 tutorial pdf

    Download free course about Publisher 2016, getting started with Microsoft Office Publisher 2016 by Bharathi G, PDF training document under 182 pages....