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

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 …

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

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 …

Jun 2, 2025 · Using the SUMIF function 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 …

Aug 13, 2024 · In this example, the goal is to look up a price using XLOOKUP with multiple criteria. To be more specific, we want to look up a price based on Item, Size, and Color.

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 …

May 11, 2024 · Below are examples of custom formulas you can use to apply conditional formatting. Some of these examples can be created using Excel's built-in presets for …

Mar 14, 2025 · INDEX and MATCH is the most popular tool in Excel for performing more advanced lookups. This is because INDEX and MATCH are incredibly flexible – you can do …

Jun 9, 2025 · The formula in this example converts amounts in USD to other currencies using currency codes and a simple lookup table. The available currencies and exact conversion …