Excel has quietly gained dynamic arrays, XLOOKUP, Power Query, and Python, yet many still work the old way.

Your typical Excel workbook—the file you're working in—can get loaded with plenty of worksheets (each indicated by a tab at the bottom, which you can name). Hide a sheet if you want, rather than ...