Insert & place images in Cell & options: 2023 new in Excel

preview_player
Показать описание
Excel now allows you to place images in cells, great for sorting lists, there are so many aspects to explore, how they work with filters, VLOOKUP, XLOOKUP, SUMIFS formulas, PivotTables, the IMAGE function, copy & pasting, editing images, and where they can be sourced from. Although I'm not a fan of the name (In cell images), I think it is really fantastic the flexibility and all the features!

00:00 Introduction
00:41 Move inside Cell
01:02 Paste into Cell
01:25 Filters and alt text
02:52 Other image view and format options
05:55 IMAGE function
06:54 VLOOKUP, SUMIFS, XLOOKUP
08:39 PivotTables
08:59 Linked Data types
11:17 QR code creator
Рекомендации по теме
Комментарии
Автор

Awesome! I'm only wondering why it took about 50 years (well, at least it felt like that) until we now can finally put images into Excel cells.
BTW, what CPU does your PC have? It looks like Excel is really crisp and snappy in your video.

DavidGP
Автор

Great info on images. Playback suddenly speeds up at 11:50.

kevingodsave
Автор

Nice Video, the new place in cell is awesome BUT, every time you double click on the cell the image will disappear and be replaced by the text. Is there any way to avoid that problem?

mel-bplr