If you ever wanted to click a magic button and make complex business tasks happen automatically, macros can make that wish come true. Macros are small programs that execute commands you specify. Write ...

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, ...