#Spreadsheets

Learn how to build an Excel drop-down list with Data Validation, using typed items or a cell range, plus how to edit it later and add error alerts.

Use the Data tab's Remove Duplicates tool to delete repeat rows, and see why highlighting them with Conditional Formatting first is the safer move.

Step-by-step guide to building a PivotTable in Excel: insert it, drag fields into Rows, Columns, and Values, switch Sum to Count, and refresh after edits.

Learn the exact VLOOKUP syntax, see a real example, and fix the #N/A errors that trip up almost everyone the first time they use it.