Excel Formula Library

If you have ever forgotten the exact syntax of a formula mid-spreadsheet, you know how frustrating it is to stop, open a browser, wade through ads, and try to find a clean answer. The Excel Formula Library by ExcelGuru solves that. It puts every Excel formula — all 455 of them — in one searchable, filterable, free tool that works right in your browser.

What Is the Excel Formula Library?

The Excel Formula Library is a free browser-based reference tool covering every Excel function across all 12 official categories. Each formula card shows you the full syntax, a plain-English description, a breakdown of every argument, and one or two practical examples — so you understand not just what a formula does but how to use it.

Everything is searchable in real time. Type SUM, VLOOKUP, or even just a keyword like “count” or “date” and the matching formulas appear instantly. No page reloads, no ads, no sign-in.

What Formulas Are Covered?

The library covers all 12 Excel function categories:

• Math & Trig — 65 formulas including SUM, SUMIF, SUMIFS, ROUND, RAND, SEQUENCE
• Statistical — 80 formulas including AVERAGE, COUNT, STDEV, PERCENTILE, CORREL
• Text — 35 formulas including VLOOKUP, XLOOKUP, LEFT, MID, TEXTJOIN, TEXTSPLIT
• Lookup & Reference — 35 formulas including INDEX, MATCH, XLOOKUP, FILTER, SORT
• Date & Time — 25 formulas including TODAY, NETWORKDAYS, EDATE, DATEDIF
• Logical — 18 formulas including IF, IFS, IFERROR, AND, OR, LAMBDA, LET
• Financial — 55 formulas including PMT, NPV, IRR, FV, PV, RATE
• Database, Engineering, Information, Cube and Web categories also included

Key Features

Live search

Type any formula name or keyword and results update instantly. Search for “lookup” to see VLOOKUP, XLOOKUP, HLOOKUP and every other lookup function side by side.

Category and difficulty filters

Filter by any of the 12 categories using the filter bar at the top, or narrow results by difficulty level — Beginner, Intermediate, or Advanced — to find formulas appropriate for your skill level.

Click to copy syntax

Every formula card has a Copy button next to the syntax string. One click and the formula is on your clipboard, ready to paste directly into Excel.

Arguments and examples

Expand any card to see every argument explained individually and one or two real-world examples showing the formula in action with actual values and expected results.

Favorites

Star any formula to save it. Your starred formulas appear in the favorites bar at the top so you can jump back to them instantly without searching again.

Who Is This For?

The Excel Formula Library is useful for anyone who works with Excel regularly — whether you are a complete beginner looking up your first IF formula, an analyst who needs a quick reminder of XLOOKUP syntax, a finance professional working with NPV and IRR, or a developer using Excel for data processing and needing the exact syntax for an engineering conversion function.

It is also a useful teaching resource. Teachers and trainers can use it to quickly look up examples and share formula explanations with students without needing to open Excel itself.

How to Use the Excel Formula Library

• Open the tool — no account or download required
• Type a formula name or keyword in the search bar
• Click a category button to browse all formulas in that group
• Click “Args & Examples” on any card to expand the full detail
• Click “Copy” to copy the syntax to your clipboard
• Click the star icon to save any formula to your favorites

The Excel Formula Library is completely free, works offline after first load, and never asks for your email address. Built by ExcelGuru.