COMPUTER-PDF.COM

Excel Functions Full List Tutorial for Beginners in PDF

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.

Learning the Excel Functions Full List

Microsoft Excel has various built-in functions that can be used for multiple purposes, such as mathematical calculations, text manipulation, date and time calculations, and many more. Here is a list of some of the most commonly used functions in Excel:

  • SUM - calculates the sum of a range of cells
  • AVERAGE - calculates the average of a range of cells
  • COUNT - counts the number of cells in a range that contain numbers
  • MAX - returns the most considerable value in a range of cells
  • MIN - returns the smallest value in a range of cells
  • IF - performs a logical test and returns a value based on the test's outcome
  • VLOOKUP - looks up a value in a table and returns a corresponding value from a different column
  • INDEX - returns a value from a table based on a specified row and column number
  • MATCH - returns the position of a value in a range of cells
  • CONCATENATE - joins two or more text strings together
  • ROUND - rounds a number to a specified number of digits
  • ROUNDUP - rounds a number up to a limited number of digits
  • ROUNDDOWN - rounds a number down to a limited number of digits
  • NOW - returns the current date and time
  • TODAY - returns the current date
  • LEN - returns the number of characters in a text string
  • LEFT - returns a specified number of characters from the beginning of a text string
  • RIGHT - returns a specified number of characters from the end of a text string
  • MID - returns a specified number of characters from a text string, starting at a fixed position
  • SUBSTITUTE - replaces a specific text string with another text string
  • TRIM - removes spaces from a text string
  • UPPER - converts a text string to uppercase
  • LOWER - converts a text string to lowercase
  • PROPER - capitalize the first letter of each word in a text string
  • COS - returns the cosine of an angle
  • SIN - returns the sine of an angle
  • TAN - returns the tangent of an angle
  • PI - returns the value of pi
  • SQRT - returns the square root of a number
  • MOD - returns the remainder of a division operation

These are just some examples of the many functions that Excel has. Many more functions are available, including advanced financial, statistical, and engineering functions, which can work with data in tables, dates, and times.

Description : Download Microsoft Excel Functions Full List, free PDF file by westernsydney.edu.au.
Level : Beginners
Created : September 20, 2017
Size : 136.09 KB
File type : pdf
Pages : 13
Author : westernsydney.edu.au
Downloads: 18378
Sample pages PDF ebook

Online skills may be learned related to the Excel Functions Full List

Learn MS Excel CoPilot: Boost Your Productivity and Data Analysis
Microsoft Excel tutorial for beginners and advanced
What is Microsoft Access? A Quick Start Tutorial
VLOOKUP Function in Microsoft Excel: A Comprehensive Guide
Deep Learning Fundamentals in Data Science

Download the file

Related Excel Functions Full List eBooks

Formulas & Functions in Microsoft Excel

The Formulas & Functions in Microsoft Excel is a beginner level PDF e-book tutorial or course with 14 pages. It was added on September 20, 2017 and has been downloaded 9045 times. The file size is 109.44 KB. It was created by Theresa A Scott.


Excel 2016 Basics Math and Functions

The Excel 2016 Basics Math and Functions is a beginner level PDF e-book tutorial or course with 25 pages. It was added on September 18, 2017 and has been downloaded 4609 times. The file size is 802.09 KB. It was created by Pandora Rose Cowart .


Excel 2010: PivotTable, IF & VLookup Functions

The Excel 2010: PivotTable, IF & VLookup Functions is an advanced level PDF e-book tutorial or course with 14 pages. It was added on October 19, 2015 and has been downloaded 11512 times. The file size is 522.6 KB. It was created by Kennesaw State University.


Excel Formula & Functions Quick Reference

The Excel Formula & Functions Quick Reference is an advanced level PDF e-book tutorial or course with 8 pages. It was added on September 21, 2017 and has been downloaded 13402 times. The file size is 251.55 KB. It was created by Faye Brockwell.


Excel 2016 - Advanced Functions & Modifying Spreadsheets

The Excel 2016 - Advanced Functions & Modifying Spreadsheets is an advanced level PDF e-book tutorial or course with 24 pages. It was added on September 1, 2016 and has been downloaded 8740 times. The file size is 751.26 KB. It was created by Kennesaw State University.


Excel 2016 - Intro to Formulas & Basic Functions

The Excel 2016 - Intro to Formulas & Basic Functions is an intermediate level PDF e-book tutorial or course with 15 pages. It was added on September 1, 2016 and has been downloaded 13872 times. The file size is 434.9 KB. It was created by Kennesaw State University.


Excel 2013: Intro to Formulas and Basic Functions

The Excel 2013: Intro to Formulas and Basic Functions is an intermediate level PDF e-book tutorial or course with 16 pages. It was added on October 19, 2015 and has been downloaded 13371 times. The file size is 580.01 KB. It was created by Kennesaw State University.


Excel 2013: Advanced Functions and Modifying Spreadsheets

The Excel 2013: Advanced Functions and Modifying Spreadsheets is an advanced level PDF e-book tutorial or course with 26 pages. It was added on October 20, 2015 and has been downloaded 9505 times. The file size is 665.65 KB. It was created by Kennesaw State University.