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.

Macros in Excel can perform functions like inserting pictures, copying data from one cell to another, etc. In order to write an effective macro to insert images in excel, you will need to use a loop.

Creating a list of duplicate values that’s separate from the data source is easier than ever thanks to Microsoft Excel's FILTER() function.