Search results
500 Excel Formulas. Over 500 working Excel formulas with detailed explanations, videos, and related links. Includes key functions like VLOOKUP, XLOOKUP, INDEX & MATCH, FILTER, RANK, ROUND, AVERAGE, COUNTIFS, SUMIFS, UNIQUE, SORT, TEXTSPLIT, and more.
- Sum If Greater Than
To sum values greater than a given number, you can use the...
- Calculate Days Remaining
Dates in Excel are just serial numbers that begin on January...
- VLOOKUP With 2 Lookup Tables
The Excel VLOOKUP function is used to retrieve information...
- Calculate Years Between Dates
To calculate the number of years between two dates, you can...
- Remove Unwanted Characters
To remove specific unwanted characters in Excel, you can use...
- Subtotal Invoices by Age
The formulas used to count invoices by age in H5:H7 are as...
- Sequence of Years
To generate a series of dates by year, you can use the...
- Maximum Value
To get the maximum value in a set of data, you can use the...
- Sum If Greater Than
Learn how to create formulas and use built-in functions to perform calculations and solve problems in Excel. Download a tutorial workbook, browse through formula elements, and get help from experts.
Browse Excel functions by category, such as statistical, math, text, lookup, and compatibility functions. Learn how to use the most popular functions, such as SUM, IF, VLOOKUP, and MATCH, with examples and videos.
Learn how to use 15 essential Excel formulas for data analysis, manipulation, and accuracy. See examples, exercises, and tips for adding formulas manually or using GUI.
Calculate the average of a group of numbers. Sum values based on multiple conditions. Calculate percentages. Subtract numbers. Guidelines and examples of array formulas. Write, insert, or change an equation. Learn these top skills to create your own formulas and functions.
Learn the basic concepts and skills of formulas and functions in Excel, such as cell references, relative and absolute references, and how to enter and edit formulas. See examples, videos, and tips for using common functions like SUM, AVERAGE, and COUNTIF.
Mar 20, 2023 · Formula is an expression that calculates values in a cell or in a range of cells. For example, =A2+A2+A3+A4 is a formula that adds up the values in cells A2 through A4. Function is a predefined formula already available in Excel.