Insert & place images in Cell & options: 2023 new in Excel
HTML-код
- Опубликовано: 12 июл 2024
- 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!
To follow what is new in Excel, check out the official Excel monthly blog I help write here: techcommunity.microsoft.com/t...
And the newsletter I co-author here: solveandexcel.ca/excel_news/
Example files can be found here: www.xlconsulting-asia.com/youtube-files
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 Авто/Мото