In two-dimensional XLOOKUP formulas, it doesn't matter which way around the XLOOKUPs go. In this example, the ID lookup is first in the formula, and the column header lookup is nested. If these were ...

Learn how to create a drop-down list using Data Validation in Excel. Data Validation limits the type of data that can be entered into a cell.

Excel's data validation feature is more versatile than you might think. Learn how to use literal values, input values, list values, and even formulas to restrict input date values using data ...

Learn how to change, edit or rename a Data Series name in Microsoft Excel Graph or Chart without editing the original row or column name.

Excel’s data validation feature offers an efficient way to perform a variety of tasks. This collection of techniques demonstrates several handy ways to put data validation to work.

Whether you've recently taken a Microsoft Excel course or you want to check that you're up-to-date with the program's latest capabilities, take the How-To Geek Advanced Excel Test and see how you fare ...