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: | 8380 |
Created: | 2017-10-09 |
SLO Adoption and Usage in Site Reliability Engineering
Download free course Office 365, pdf file on 680 pages by Matthew Katzer, Don Crawford....
Publisher 2016 tutorial pdfDownload free course about Publisher 2016, getting started with Microsoft Office Publisher 2016 by Bharathi G, PDF training document under 182 pages....
Advanced Word 2013With this PDF tutorial you will be familiar with the basic functionality of Microsoft Word 2013 and you will learn how to write document with ease....
Microsoft Excel 2016 TutorialDownload a basic pdf tutorial about Microsoft Excel 2016, free training document under 12 pages...
Commonly Used Excel FunctionsHere are some basic formulas that are easy to do and that can give some life to an Excel sheet!, download free PDF training document under 17 pages....
Guide PowerPoint 2013Guide of Microsoft Powerpoint 2013 in PDF a quick references card to learn the basics of PowerPoint,a free tutorial for download and training document under 2 pages designated to begginers....
Word 2013 Keyboard ShortcutsFree Microsoft Word 2013 Keyboard Shortcuts in PDF for download ,a free training document under 20 pages to make Word easy to use and understand....
PowerPoint 2010 AdvancedDownload advanced tutorial in PDF about PowerPoint 2010, free course under 201 pages by Stephen Moffat....
Office 365: Migrating and Managing Your Business in the CloudWritten for the IT professional and business owner, this book provides the business and technical insight necessary to migrate your business to the cloud using Microsoft Office 365. This is a practical look at cloud migration and the use of different technologies to support that migration. Numerous ...
Excel 2016 Math with Dates and TimesWith this tutorial, you will learn a lot of shortcuts and custom formatting options about Dates and Times in Excel 2016. Training documents courses on 17 pages for beginners....