Excel Functions

Discover how functions in Excel help you save time.
If you are new to functions in Excel, we recommend you to read our introduction to Excel Functions.

• 1. Date And Time:
  This page lists the built-in Excel Date and Time Functions, which can be used to extract information from, and perform operations on, Excel dates and times.
• 2. Engineering:
  The built-in Excel Engineering Functions perform the most commonly used engineering calculations, many of which relate to Bessel Functions, Complex Numbers or converting between different bases.
• 3. Financial:
  List Financial functions, such as the DURATION, RATE, and PMT functions…
• 4. Information:
  Excel Information Functions – Links to Each of the Built-In Information Functions with Full Description, Examples and Common Errors.
• 5. Logical:
  Lists all logical functions, such as the AND, OR, and IF functions
• 6. Lookup and reference:
  Excel comes with multiple Lookup and Reference functions that let you find matching values. Use this article to decide which function is best for your needs.
• 7. Math:
  Excel Math Functions – Links to Each of the Built-In Math & Trig Functions
• 8. Statistical:
  This chapter gives an overview of some very useful statistical functions in Excel.
• 9. Text:
  How to use the Excel TEXT function to Convert a number to text in a number format.

Excel Formulas

A collection of useful Excel formulas for sums and counts, dates and times, text manipularion, conditional formatting, percentages, lookups, and more!

Count	Sum	Average
Min and Max	Conditional Formatting	Lookup
If	Date and Time	Date Series
Text	Financial	Workbook
Internet	Names	Percentage
Range	Miscellaneous