The "Unpivot" button inside Excel's Get Data feature is a hidden superpower. It can turn a tedious, error-prone task into smooth, automated workflows. No more copy-pasting, no more manual rearranging ...

Excel's Linked Picture tool lets you take a snapshot of some data and paste it as an image—handy if you're compiling a dashboard of the key metrics from across your workbook. Unlike normal images, ...