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...
- Get First Name From Name
To extract the first name from a full name in format, you...
- Calculate Years Between Dates
To calculate the number of years between two dates, you can...
- Count Cells Less Than
To count cells that contain values less than a given number,...
- 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...
- 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 their functionality, such as Logical, Statistical, or Text functions. Find detailed information about a function by clicking its name or use Ctrl+F to search by keywords.
Learn the essential basic Execl formulas and discover how to create and use formulas for arithmetic, string, and time series, data with these Microsoft Excel formulas.
Jun 24, 2024 · What Is an Excel Formula? An Excel formula is an expression that acts on a cell or range of cells and produces results in another cell or multiple cells.
Find and learn how to use Excel functions by name, type, and description. Browse the list of functions from A to Z or search by keywords or categories.
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.