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.

Repeat the last action in Excel using shortcut Use the keyboard shortcut Ctrl+Y or F4 to quickly repeat the last action you performed without navigating through menus or options.

The Shortcut AI agent for Excel could be the next boon — or threat — to white collar workers who spend all day in spreadsheets.

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

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.