This column shows how to use the Data Table option in Excel’s What-If Analysis tool.

INDEX with XMATCH returns an item from a range or array according to the first or last match it finds. Like XLOOKUP, it works with vertical and horizontal datasets, can search in any direction, and ...

You have a table on paper but need the data listed in Excel? There's a simple trick for importing.