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
Size : | 150.64 Kb |
File type : | |
Downloads: | 8379 |
Created: | 2017-10-09 |
Think Bayes: Bayesian Statistics in Python
Algorithms and Data Structures With Applications to Graphics and Geometry
Written for the IT professional and business owner, this book provides the business and te..., download free Office tutorial in PDF (680 pages) created by Don Crawford ....
Guide Excel 2010A little guide in PDF,it will clarify the new basics features added to Microsoft Excel 2010 ,free training tutorial under 24 pages....
Microsoft Excel 2007 : Essential GuideThe purpose of this course is to provide a basic guide for student who wants to be familar with the basics of Microsoft Excel 2007....
Microsoft Excel 2016 Academic Course...
Microsoft Excel 2013Download free Microsoft Excel 2013 Tutorial , a PDF training file under 12 pages for beginners....
Microsoft Excel Tips & TricksThese 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....
Beginning Excel 2019Download free course Beginning Excel 2019, pdf file on 387 pages by by Noreen Brown, Barbara Lave, Hallie Puncochar, Julie Romey, Mary Schatz, Art Schneider, Diane Shingledecker....
Introduction to Microsoft Word 2013This support shows you in detail all the features of this new version of the popular word Microsoft Word 2013; it is for anyone wishing to discover and deepen all its features....
Microsoft Excel 2016 TutorialDownload a basic pdf tutorial about Microsoft Excel 2016, free training document under 12 pages...
Quick guide to Microsoft Excel 2016Quick guide to Excel 2016 intended to beginners in order to learn the fundamentals of Microsoft Excel 2016, training document in pdf....