Search results
Results from the WOW.Com Content Network
Lists all Excel functions by their category, such as Logical functions or Text functions.
Over 350 built-in functions, with examples and videos. VLOOKUP, XLOOKUP, INDEX & MATCH, FILTER, RANK, SUMPRODUCT, AVERAGE, COUNTIFS, SUMIFS, UNIQUE, SORT, TEXTSPLIT, SEQUENCE, FIND, DATE, and more. See also 500 Formulas, 101 Functions, and New Excel Functions.
Excel is used to calculate and manipulate numbers and text. To do this, you use formulas! 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.
Important: The calculated results of formulas and some Excel worksheet functions may differ slightly between a Windows PC using x86 or x86-64 architecture and a Windows RT PC using ARM architecture. Learn more about the differences. Function name. Type and description. ABS function.
Below is a brief overview of about 100 important Excel functions you should know, with links to detailed examples. We also have a large list of example formulas, a more complete list of Excel functions, and video training. If you are new to Excel formulas, see this introduction.
Define and use names in formulas. Create a simple formula. Display or hide formulas. Move or copy a formula. Display or hide zero values. Use Excel as your calculator. Summing up ways to add and count Excel data. Count how often a value occurs. Find external references (links) in a workbook.
Related Functions. Calculate running total. SUM SCAN. Count cells that contain formulas. SUMPRODUCT ISFORMULA NOT. Subtotal by color. SUMIF COUNTIF. Subtotal by invoice number.
Excel Functions List with free downloadable examples. Learn the syntax for 200+ of the most commonly used Excel and Google Sheets functions.
Here, you will find a detailed tutorial on 100+ Excel Functions & VBA Functions. Each Excel function is covered in detail with Examples and Videos. This Tutorial Covers:
Function is a predefined formula already available in Excel. Functions perform specific calculations in a particular order based on the specified values, called arguments, or parameters. For example, instead of specifying each value to be summed like in the above formula, you can use the SUM function to add up a range of cells: =SUM(A2:A4)