Here are our 10 featured functions we believe will improve your spreadsheet experience. In newer versions of Excel, these functions were replaced with new functions that provide improved accuracy and have names that better reflect their usage. You can still use them for compatibility with earlier versions of Excel, but if backward compatibility isn't required, you should start using the new functions instead.

AND AVERAGE AVERAGEIF AVERAGEIFS CONCAT COUNT COUNTA COUNTBLANK COUNTIF COUNTIFS DATEDIF FILTER HLOOKUP IF IFERROR IFS INDEX INDEX MATCH LEFT LEN LOWER MATCH MAX MEDIAN MID MIN MODE NETWORKDAYS NPV OR PROPER RAND RIGHT ROUND SORT STDEV.P STDEV.S SUBSTITUTE SUM SUMIF SUMIFS SUMPRODUCT TEXTJOIN TODAY TRIM UNIQUE UPPER VLOOKUP XLOOKUP XOR · Convert Time to Seconds Difference Between Times NPV (Net Present Value) Remove Duplicates ... Excel has many premade formulas, called functions.

To get detailed information about a function, click its name in the first column. ... Version markers indicate the version of Excel a function was introduced.

August 12, 2026 - Complete reference for 400+ built-in Excel functions, each with syntax, examples, and usage notes, many with video. Covers VLOOKUP, XLOOKUP, INDEX & MATCH, FILTER, COUNTIFS, SUMIFS, SORT, TEXTSPLIT, SEQUENCE, and more.

Functions are predefined formulas that perform calculations by using specific values, called arguments, in a particular order, or structure. Functions can be used to perform simple or complex calculations.

These 11 chapters are your ideal starting point to master Excel functions! 1 Count and Sum: The most used functions in Excel are the functions that count and sum.

April 23, 2024 - Read our article on Excel keyboard shortcuts and find out how to work more ef­fi­cient­ly and up your Excel pro­fi­cien­cy. Functions are built-in ex­pres­sions in Excel that apply a pre­de­fined algorithm to arguments (specific values) and return a result.

May 29, 2026 - Functions are built-in formulas in Excel. They’re like shortcuts for performing a calculation or other operation on cell data. There are almost 500 Excel functions, and the number continues to grow.

August 30, 2024 - Formulas are expressions that tell Excel what you want to do with the data. They begin with the equal symbol (=) followed by a combination of operators and functions. These are symbols that specify the type of calculation you want to perform on the elements of a formula. For example, to add two numbers, you can type “=1+1” into a cell.

1 month ago - A complete list of 500+ Excel functions, grouped by Excel's own categories. Each has a short description, and linked ones open a full tutorial.

January 23, 2025 - That means that Excel deleted all data in the row where a duplicate was found. Let’s say you want to see how annual sales compare across states. Pivot tables allow you to take a dataset and summarize it in a variety of ways. It’s one of the most useful functions of Excel or Sheets.

November 20, 2018 - Most Engineering functions are pretty technical...you'll find a lot of functions for complex numbers in this section. However, the CONVERT function is quite useful for everyday unit conversions. You can use CONVERT to change units for distance, weight, temperature, and much more. ... Excel provides many functions for checking the value in a cell, including ISNUMBER, ISTEXT, ISLOGICAL, ISBLANK, ISERROR, and ISFORMULA These functions are sometimes called the "IS" functions, and they all return TRUE or FALSE based on a cell's contents.

A formula is an expression which calculates the value of a cell. Functions are predefined formulas and are already available in Excel.

May 29, 2026 - Excel is a spreadsheet program in Microsoft's 365 Office Suite, which also includes Word, PowerPoint, Teams, and Outlook. Some common Excel functions include SUM, AVERAGE, IF, VLOOKUP, and COUNTIF.

April 13, 2026 - Whether you need to combine text strings (CONCATENATE), extract specific characters (LEFT, RIGHT), or format casing (UPPER, LOWER), these functions offer unparalleled control over text manipulation and cleaning. Combine text strings (CONCATENATE). Extract specific characters (LEFT, RIGHT). Format casing (UPPER, LOWER). Clean and format customer data or extract information from text strings. Manage Dates and Times with Ease: Working with dates and times in Excel can be a breeze with the dedicated Date & Time Functions.

Although Excel includes a multitude of built-in worksheet functions, chances are it doesn’t have a function for every type of calculation you perform. Custom functions, like macros, use the Visual Basic for Applications (VBA) programming language.

By default, Excel uses the A1 reference style, which refers to columns with letters (A through XFD, for a total of 16,384 columns) and refers to rows with numbers (1 through 1,048,576). These letters and numbers are called row and column headings. To refer to a cell, enter the column letter followed by the row number. For example, B2 refers to the cell at the intersection of column B and row 2. In the following example, the AVERAGE function calculates the average value for the range B1:B10 on the worksheet named Marketing in the same workbook.

March 20, 2023 - SUMIFS in Excel - formula examples to sum cells based on multiple criteria. The Excel AVERAGE function does exactly what its name suggests, i.e. finds an average, or arithmetic mean, of numbers.

These are listed in the 'Formulas' menu of the Excel ribbon (see below). This website provides information and examples of each of the Built-In Functions and also shows you how to combine these functions with each other, and with the Mathematical Operators (+, -, *, /, etc.), to create Excel Formulas.