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
VLOOKUP is one of the most important lookup functions in...
- 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
Jul 4, 2024 · Learn how to use Excel formulas and functions to perform calculations, manipulate data, and generate reports. This article covers the basics of formulas and functions, and explains 25 examples of common and useful ones.
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 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.
Formulas and functions. Formulas Functions Logical Reference More functions Errors. Overview of formulas in Excel. 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.
Mar 20, 2023 · Learn the essentials of Excel formulas and functions with 10 basic examples and links to in-depth tutorials. Find out how to use SUM, AVERAGE, MAX, MIN, COUNT, COUNTA and other functions to calculate values in a cell or a range of cells.
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.