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

 

Size : 150.64 Kb
File type : pdf
Downloads: 8380
Created: 2017-10-09
Full list of Excel functions

Warning: Trying to access array offset on false in /home/tutovnfz/public_html/article.php on line 233

Others Tutorials

Programming for Computations - MATLAB/Octave: A Gentle Introduction to Numerical Simulations with MATLAB/Octave

Open Data Structures (in C++)

Confessions of an IT Manager

Cache Memory course

Fundamentals of Cryptology

Others related eBooks about Full list of Excel functions

Excel Data Analysis, 2nd Edition

This book offers a comprehensive and readable introduction to modern business and data ana..., download free Excel Data tutorial in PDF (358 pages) created by Hector Guerrero ....

Guide Excel 2010

A 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 Guide

The purpose of this course is to provide a basic guide for student who wants to be familar with the basics of Microsoft Excel 2007....

Evaluating Information Retrieval and Access Tasks

Download free course Evaluating Information Retrieval and Access Tasks, pdf file on 225 pages by Tetsuya Sakai, Douglas W. Oard, Noriko Kando....

Introduction to Excel VBA Macro programming

Introduction to Excel VBA Macro programming, Learn Excel tools by utilizing them in various cases, Understand the logic and syntax behind Visual Basic programming, which interacts with the Excel interface...

Advanced Word 2013

With 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 2007 Advanced - Tutorial

Download free Microsoft Excel 2007 Advanced course material and training, a 100 pages pdf documents intended to beginners....

Microsoft Excel for Beginners

This is a basic computer workshop. Microsoft Excel is a spreadsheet program. We use it to create reports that need calculations and charts. In this workshop we will learn how to move around and work inside the spreadsheet....

Quick guide to Word 2010

A course to learn how to use the Word 2010 version, PDF training course to download for free, Microsoft Office Word 2010, training support in 4 pages...

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