Get things done in Excel

The core tools for finding, summarizing, and making sense of your numbers.

1. Look up values with VLOOKUPPull data from one table into another using a matching key.5 min read
2. Build a pivot table to summarize data3 min read
3. Compare two columns to find matches5 min read
4. Use AI in Excel with Copilot and Analyze Data7 min read

Fix messy sheets and set rules for what goes into them.

1. Remove duplicate rows4 min read
2. Highlight duplicate valuesSpot the repeats before you delete anything.3 min read
3. Add a drop-down listLimit entries to a set list so data stays consistent.4 min read

Make sheets easier to read and harder to break.

1. Freeze rows and columnsKeep headers in view while you scroll.4 min read
2. Wrap text inside a cell4 min read
3. Merge cells, and know when not to2 min read
4. Lock cells to protect your work3 min read

When Excel crashes or a file disappears, start here.

1. Recover an unsaved or lost file6 min read
2. Fix Excel not responding or freezing5 min read