Excel tutorials

Practical Microsoft Excel tutorials, from basic features to modern functions like XLOOKUP.

Excel

How to Create a Drop-Down List in Excel

Create a drop-down list in Excel with Data Validation: from typed items, from a cell range, from another sheet, and a list that updates automatically.

 Excel

How to Use XLOOKUP in Excel: A Beginner's Guide

XLOOKUP explained with simple examples: syntax, left lookups, custom 'not found' messages, returning several columns, and how it compares to VLOOKUP.