Excel Tools

Adds all numbers in a range of cells.

=SUM(A1:A10) → adds values in cells A1 through A10

Returns one value when a condition is true, another when false.

=IF(A1>100,"High","Low")

Looks up a value in the first column of a table and returns a value from another column.

=VLOOKUP(A2, Sheet2!A:D, 4, FALSE)

Modern replacement for VLOOKUP/HLOOKUP — searches a range and returns matching values.

=XLOOKUP(A2, B:B, C:C, "Not found")

Counts cells in a range that meet a single condition.

=COUNTIF(A:A, ">100")

Sums cells in a range that meet a single condition.

=SUMIF(A:A, ">100", B:B)

What Is Microsoft Excel?

A friendly introduction to Microsoft Excel: what the app does, where it shines, and why it's still the world's default spreadsheet.

Excel vs Google Sheets

Excel and Google Sheets do 90% of the same things — but the last 10% matters. Here's how they compare on formulas, collaboration, performance, and price.

The Most Useful Excel Functions

Learn these ten Excel functions and you'll handle 90% of everyday spreadsheet work. Examples, syntax, and when to reach for each one.

How Excel Formulas Work

A plain-English guide to how Excel actually evaluates a formula — references, operators, functions, and the rules behind = signs and $ pinning.

Common Excel Errors and How to Fix Them

Decode Excel's six most common formula errors and learn the quickest way to fix each one — without rewriting your whole spreadsheet.

Excel for Beginners

Start here if Excel feels intimidating: the core concepts and habits that unlock everything else.

How to Use VLOOKUP

The classic lookup function, demystified — with the gotchas that trip up most people.

How to Use XLOOKUP

The newer, smarter lookup — and why it's worth switching from VLOOKUP whenever you can.

Best Excel Functions for Work

If you only learn a handful of Excel functions, learn these. They cover most real-world office tasks.

Excel Productivity Tips

The shortcuts and habits that separate slow Excel users from fast ones.