Over 1000 working Excel formulas with detailed explanations, videos, and related links. Includes key functions like VLOOKUP, XLOOKUP, INDEX & MATCH, FILTER, RANK, ROUND, …

Over 350 built-in functions, with examples and videos. VLOOKUP, XLOOKUP, INDEX & MATCH, FILTER, RANK, SUMPRODUCT, AVERAGE, COUNTIFS, SUMIFS, UNIQUE, SORT, …

Sep 27, 2024 · 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 …

This document contains a brief overview of about 100 important Excel functions you should know, with links to detailed examples. It is based on a more complete list of Excel functions here.

May 22, 2024 · The AND function is one of Excel's logical functions. It is designed to test multiple conditions simultaneously and return TRUE only if all the conditions are met.

Oct 19, 2023 · To use Excel with confidence, you must have a good understanding of formulas and functions. This article introduces the basic concepts you need to know to be proficient with …

Apr 19, 2025 · Nearly 50 new functions have been added to Excel! This is not your Dad's Excel anymore – a lot has changed. This article takes a quick tour of the new functions, with links to …

Mar 14, 2025 · Now that we've covered the basics of INDEX and MATCH, how do we combine the two functions in a single formula? Consider the data below, a table showing a list of …

May 1, 2025 · The Excel LAMBDA function provides a way to create custom functions that can be reused throughout a workbook, without VBA or macros.

Jun 9, 2025 · The IF function is one of the most widely used functions in Excel. At the core, IF runs a test and returns one value when the result is TRUE, and another value when the result …