Skip to content
xlsoffice. All Rights Reserved
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Lookup and Reference Examples

  • How to get last row in mixed data with blanks in Excel
  • Complete List of Excel Lookup and Reference Functions, References and Examples
  • How to use Excel COLUMN Function
  • How to use Excel VLOOKUP Function
  • MATCH function: Description, Usage, Syntax, Examples and Explanation

Data Analysis Examples

  • How To Remove Duplicates In Excel Column Or Row?
  • Create Scatter Chart in Excel
  • Conditional Formatting Data bars Examples in Excel
  • How to calculate current stock or inventory in Excel
  • How to create a Histogram in Excel

Data Validation Examples

  • Excel Data validation allow weekday only
  • Excel Data validation with conditional list
  • How To Create Drop-down List in Excel
  • Excel Data validation must begin with
  • Data validation must not exist in list

Excel Functions by Categories

by

This page provides a complete Excel Functions list, grouped by category.

Each of the function links will take you to a dedicated page, where you will find a description of the function, with examples of use and details of common errors.

Worked Example:   Find, Trace and Correct Errors in Excel Formulas using 'Formula Auditing'
Worked Example:   How to get original price from percentage discount in Excel

Text Functions

Logical Functions

Information Functions

Date and Time Functions

Lookup and Reference Functions

Math and Trig Functions

Statistical Functions

Database Functions

Financial Functions

Engineering Functions

Cube Functions

Web Functions

Worked Example:   Subtract Numbers in Excel

Post navigation

Previous Post:

Complete List of Excel Cube Functions References and Examples

Next Post:

How to calculate Day of the Year in Excel

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others
  • How to strip protocol and trailing slash from URL in Excel
  • How to strip html from text or numbers in Excel
  • How to Remove Leading Spaces in Excel
  • DOLLAR function: Description, Usage, Syntax, Examples and Explanation
  • How to display conditional message with REPT function in Excel
  • Get project end date in Excel
  • Get month name from date in Excel
  • Display Days in month in Excel
  • Steps to create Dynamic calendar grid in Excel
  • Get first day of previous month in Excel
  • MIRR function: Description, Usage, Syntax, Examples and Explanation
  • COUPPCD function: Description, Usage, Syntax, Examples and Explanation
  • Calculate interest for given period in Excel
  • PRICEDISC function: Description, Usage, Syntax, Examples and Explanation
  • PMT function: Description, Usage, Syntax, Examples and Explanation
Acronyms, Abbreviations, Initialism & What They Stand For
© 2022 xlsoffice . All Right Reserved. | Teal Smiles