Sheets and Cells — Every Excel Function, Every Google Sheets Formula, Every Fix

Excel · Google Sheets · Add-ins · AI

Every function. Every fix. Every formula.

The complete spreadsheet playbook. Master every Excel function, every Google Sheets formula, every error fix, every template — organized by category, tested by hand, downloadable in one click.

Popular: VLOOKUP· XLOOKUP· IF· FILTER· #N/A· #SPILL!

30+

Functions Live

Error Pages

Pillar Guides

Templates

2,100+

Pages Planned

Start Here

Jump straight in

Five doorways into the site — whichever fits what you need right now.

🧮

Functions

Every function, categorized and tested

⚠️

Errors

Fix any spreadsheet error in 60 seconds

📊

Templates

Free downloadable workbooks and dashboards

📖

Guides

Long-form pillar content and deep-dives

🤖

AI in Excel

Claude, Copilot, ChatGPT — spreadsheet workflows

Deep-Dive Guides

Our best content, organized by topic

Multi-thousand-word pillar guides that unify entire function families with tested examples and companion workbooks.

Legacy Lookup

VLOOKUP Complete Guide

The definitive VLOOKUP resource — 10 real-world patterns, migration path to XLOOKUP, common mistakes, exact-vs-approximate match, and every trick you need to master lookups in any Excel version.

4,666 words17 min readRead →

Troubleshooting

Excel Errors Complete Guide

All 9 error types explained with causes, fixes, and prevention — #REF, #NAME, #VALUE, #DIV/0, #N/A, #NULL, #NUM, #SPILL, #CALC. Plus the 5-step debugging workflow that catches everything.

5,293 words20 min readRead →

Modern Excel

Master modern Excel's biggest change — all 15 dynamic array functions (FILTER, UNIQUE, SORT, SEQUENCE, TAKE, DROP, WRAPROWS, and more), the spill mechanism, nested patterns, and complete #SPILL! troubleshooting.

4,304 words18 min readRead →

Decision Logic

IF Statement Complete Guide

The entire IF family in one guide — IF, IFS, IFERROR, IFNA, SWITCH, AND, OR, NOT. 10 essential patterns, the decision tree for picking the right function, and every mistake to avoid.

4,436 words17 min readRead →

Browse all guides →

Function Library

Every function, categorized

Excel is the foundation (30+ pages live, 470+ in build). Google Sheets coverage begins Q1 2027 with dedicated categories.

Lookup

XLOOKUP, VLOOKUP, INDEX/MATCH

Math & Trig

SUM, SUMIFS, ROUND

Text

LEFT, TEXTJOIN, SUBSTITUTE

Logical

IF, IFS, AND, OR

Date & Time

TODAY, NETWORKDAYS, EOMONTH

Statistical

AVERAGE, COUNTIFS, STDEV

Financial

PMT, NPV, IRR, FV

Information

ISBLANK, ISNUMBER, ROW

Database

DSUM, DGET, DCOUNT

Engineering

CONVERT, HEX2DEC, BITAND

Dynamic Arrays

FILTER, UNIQUE, SORT

LAMBDA & Modern

LAMBDA, LET, MAP, REDUCE

AI Functions

AI.ASK, AI.EXTRACT, AI.LIST

Cube & Web

CUBEVALUE, WEBSERVICE

Compatibility

Legacy function equivalents

Browse all Excel functions →

🟢 Google Sheets coverage launches Q1 2027

400+ Google Sheets functions, spreadsheet-specific errors, dashboard templates, migration guides, and Excel-vs-Sheets comparisons — all with the same depth and care as our Excel content.

📅 Month 4 kickoff: ARRAYFORMULA, QUERY, IMPORTRANGE, and native GS functions

Our Products

Add-ins built by us, for you

Native productivity tools that install directly into Excel and Google Sheets — designed to save hours every week.

Excel Wizard Add-in

Excel Wizard

The productivity add-in for people who live in Excel. Install from Microsoft AppSource.

500+ pre-built formula templates at your fingertips
One-click error fixer for all 9 error types
Formula translator: legacy → modern (XLOOKUP, FILTER, LAMBDA)
Instant lookup table generator from any range
Named range manager with visual dependency map

Learn More Coming Q3 2027

Sheets Wizard Add-on

Sheets Wizard

Bringing the same power to Google Sheets. Coming to Google Workspace Marketplace.

400+ Google Sheets formula templates ready to insert
QUERY builder with visual filter interface
IMPORTRANGE dependency tracker
Apps Script snippet library
Excel ↔ Sheets formula translator

Coming Q4 2027 In development

Error Reference

Fix any error in 60 seconds

Every Excel error type, explained with cause, fix, and prevention pattern.

#REF!

Reference error

A cell reference is broken — usually from deleted rows/columns or a moved lookup table.

#NAME?

Name recognition error

Excel can't recognize a function name — typo, missing quotes, or version incompatibility.

#VALUE!

Value type error

A formula received the wrong data type — text where number expected, or vice versa.

#DIV/0!

Division by zero

Formula tried to divide by zero or by a blank cell. Fix with IF or IFERROR guard.

#N/A

Not available

A lookup couldn't find the value — most common with VLOOKUP, XLOOKUP, INDEX/MATCH.

#SPILL!

Spill blocked

A dynamic array can't fill its target cells — usually blocked by existing data or merged cells.

Browse all error pages →

Templates

Free downloadable workbooks

Ready-to-use Excel templates across 6 categories. Google Sheets versions coming Q2 2027.

💰

Finance

Budgets, cash flow, loan amortization, expense trackers

📈

Business Ops

Invoices, quotes, project trackers, timesheets

📊

Dashboards

KPI dashboards, sales reports, executive summaries

🔬

Data Analysis

Pivot templates, statistical models, data cleaning

🏠

Personal

Household budgets, meal planners, habit trackers

🎓

Student

GPA calculators, study schedules, assignment trackers

📁

Browse All

See every template across all categories

🟢

Google Sheets

Coming Q2 2027 — 400+ templates in build

AI in Spreadsheets

Use AI in Excel and Google Sheets

Workflows, prompts, and step-by-step tutorials for using AI assistants inside your spreadsheets.

Claude in Excel

Claude for Excel add-in — formula generation, data analysis, and spreadsheet automation with the world's most capable AI model.

Microsoft Copilot

Native Microsoft 365 Copilot inside Excel — chart creation, formula suggestions, and natural-language data queries.

ChatGPT for Excel

Using ChatGPT alongside Excel — prompting techniques, formula debugging, and workflow automation.

Browse all AI-in-Excel guides →

Interactive Tools

Formula playgrounds, coming soon

Interactive browser-based tools for formula generation, error debugging, and format conversion — no download needed.

Q1 2027

Formula Generator

Describe what you need in plain English, get a working Excel or Google Sheets formula. Powered by Claude.

Q1 2027

Error Explainer

Paste any error and get an instant diagnosis with the exact fix — no debugging required.

Q2 2027

Excel ↔ Sheets Translator

Convert Excel formulas to Google Sheets equivalents (or vice versa) with syntax adjustments handled automatically.

Q2 2027

Pivot Table Wizard

Build any pivot table by answering 3 questions. No dragging, no field-list confusion.

Q3 2027

Regex Builder

Interactive regex tester for text-parsing formulas. Live preview on your data.

Q3 2027

Named Range Analyzer

Upload a workbook, see every named range and its dependencies visually mapped.

Where We're Going

The 12-month roadmap

Sheets and Cells is building toward the definitive spreadsheet resource on the web — 2,100+ pages across Excel and Google Sheets by end of Year 1.

✓ Done — Foundation

Months 1-3: Excel Foundation

Homepage, all 15 function-category hubs, 30 canonical function pages, 10 error pages, 7 legal pages, 3 AI-in-Excel guides, and 4 pillar guides shipped.

→ Now — Depth

Months 4-6: Depth & Google Sheets Kickoff

Building out remaining function pages, first Google Sheets category hubs, ARRAYFORMULA/QUERY/IMPORTRANGE deep-dives, and first interactive tools go live.

Q3 — Scale