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 …

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 …

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 often embedded inside the IF function as the logical test to simplify what would otherwise be a more complex formula. For example, in the worksheet …

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 …

Jun 2, 2025 · The SUMIF function adds up numbers in Excel when they meet a specific condition. It's one of Excel's most widely used functions, and you will find it in all kinds of spreadsheets …

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 …

Feb 9, 2024 · Sometimes you have a formula that isn't finished and Excel won't let you save the formula. In this video, we'll look at a simple way to save an unfinished formula so that you …