Free Excel & Google Sheets guides

Excel formula guides, minus the headache

Clear, example-led guides to the formulas people search for most, with the exact syntax, common errors, and fixes. Or skip the reading and let ExcelPerfect write the formula for you.

Lookup & reference

VLOOKUP 6 min read

How to Use VLOOKUP in Excel (Step-by-Step, with Examples)

VLOOKUP is the function people reach for when they need to find a value in a table and pull back a matching value from another column: looking up a price by product code, an email by name, a salary by employee ID.

Read guide
XLOOKUP 5 min read

How to Use XLOOKUP in Excel (the Modern VLOOKUP)

XLOOKUP is the modern lookup function in Excel. It replaces VLOOKUP, HLOOKUP, and most INDEX/MATCH formulas with one cleaner function.

Read guide
INDEX/MATCH 6 min read

How to Use INDEX MATCH in Excel (Look Left and Right)

INDEX/MATCH is the lookup combo power users prefer over VLOOKUP. MATCH finds the position of a value, and INDEX returns whatever sits at that position in another column.

Read guide
VLOOKUP vs XLOOKUP 5 min read

VLOOKUP vs XLOOKUP in Excel (Which Should You Use?)

VLOOKUP and XLOOKUP both find a value in a table and return a matching value, but XLOOKUP is the modern rewrite: simpler, more flexible, and harder to break.

Read guide

Logical

IF 5 min read

How to Use the IF Function in Excel (with Multiple Conditions)

The IF function returns one value when a condition is true and another when it is false. It is the foundation of decision-making in spreadsheets: flagging, scoring, categorising, and conditional math.

Read guide
IFERROR 4 min read

How to Use IFERROR in Excel (Hide #N/A and #DIV/0!)

IFERROR catches any error a formula produces and returns a value of your choice instead (a friendly "Not found", a 0, or a blank cell), so dashboards stay clean.

Read guide

Math & aggregation

SUMIF 5 min read

How to Use SUMIF in Excel (Sum with a Condition)

SUMIF adds up the numbers in a range that meet a single condition: total sales for one region, the sum of all "Paid" invoices, every value over 100.

Read guide
COUNTIF 4 min read

How to Use COUNTIF in Excel (Count with a Condition)

COUNTIF counts how many cells in a range meet a single condition: how many invoices say "Paid", how many scores are over 100, how many names start with S.

Read guide
SUMIFS 5 min read

How to Use SUMIFS in Excel (Sum with Multiple Criteria)

SUMIFS adds up numbers that meet two or more conditions at the same time: sales for the West region in January, paid invoices over 100, amounts within a date range.

Read guide
COUNTIFS 4 min read

How to Use COUNTIFS in Excel (Count on Multiple Criteria)

COUNTIFS counts how many rows meet two or more conditions at the same time: orders that are both West and Paid, values between 50 and 100, open tickets raised this year.

Read guide

Text

CONCAT 4 min read

How to Concatenate in Excel (Join Text from Cells)

Concatenating means joining text from several cells into one: combining first and last names, building an address line, or merging codes into a single key.

Read guide

Data cleanup

UNIQUE 5 min read

How to Remove Duplicates in Excel (3 Simple Ways)

Duplicate rows creep into every spreadsheet. Excel gives you three ways to deal with them: a live UNIQUE formula, the one-click Remove Duplicates button, and COUNTIF to flag dupes without deleting anything.

Read guide

Launching soon

Get this the moment we launch

ExcelPerfect turns plain English into the exact formula, and it’s almost here. Join the waitlist for early access and an extended free trial.

You type Sum column B where column A is "Paid"
=SUMIF(A:A,"Paid",B:B)

No spam, ever. Just one email the day we launch.