Skip to content
Excel Help

Tutorials

Choose a task, work through an example, and check the result in your own data.

Duplicates and list comparison

Preview duplicate rows

Choose key columns, review every match, and export the kept rows.

Highlight duplicates

Mark repeated IDs, whole rows, or later occurrences without deleting data.

Count unique values

Compare distinct values with values that occur exactly once.

Compare two lists

Pair repeated occurrences and inspect items left over in either source.

Imports and data cleanup

Split text into columns

Work through delimiter, fixed-width and destination examples.

Import CSV with leading zeros

Keep identifiers as text and compare the sample CSV with the expected workbook.

Convert text to dates

Resolve ISO, MDY and DMY dates while preserving the original strings.

Find hidden spaces

Diagnose spaces, nonbreaking spaces, tabs and line breaks in imported IDs.

Data cleaning worked example

Follow one dataset from preserved original to cleaned output and row-count checks.

Lookups, formulas and errors

XLOOKUP with multiple criteria

Look up a row using two or three conditions and inspect first-match behavior.

Fix number-versus-text lookups

Find why visually identical IDs do not match and choose a repair.

FILTER with multiple criteria

Compare AND and OR conditions, empty results and spill behavior.

Fix a SPILL error

Reproduce blocked cells, tables and merged-cell cases, then repair them.

Troubleshoot formula errors

Work through separate N/A, VALUE and REF cases with expected repairs.

Formatting, entry rules and dates

Conditional formatting formulas

Apply row rules with the right cell references and check boundary cases.

Conditional formatting for dates

Highlight overdue and upcoming dates without treating blanks as dates.

Data validation examples

Set numeric, date and list entry rules and inspect their limits.

Dependent drop-down lists

Build a category-and-item selector and handle a changed category.

Business days with holidays

Count inclusive working dates with your holidays and custom weekends.

Keyboard reference

Excel shortcuts for Mac

Search a Mac-specific shortcut reference and download the printable PDF.

More Excel guides