Скачать или смотреть Excel New Image Function - Insert Images into cells with a Formula!

The new Excel IMAGE function enables you to insert images into cells with a formula. This great function allows you to sort, filter, and rearrange images. The image function has five arguments, but only one is required. You can control whether you want to fit the image to a cell or fill a cell with the image. Depending on the size of the image, you may want to increase the column width and row height.

Chapters:
0:00 Intro
0:45 Copy Image URL
1:18 Image Function - Example 1
2:30 Image Function with a Table

IMAGE Function
=IMAGE(source, [alt_text], [sizing], [height], [width])

IMAGE Function Arguments
[Required] source is the URL path of the image file, using an “https” protocol. (NOTE: Supported file formats include BMP, JPG/JPEG, GIF, TIFF, PNG, ICO, and WEBP.)
[Optional] alt_text is the alternative text that describes the image (for accessibility).
[Optional] sizing specifies the image dimensions. There are several possible values:
0: Fit the image in the cell and maintain its aspect ratio.
1: Fill the cell with the image and ignore its aspect ratio.
2: Maintain the original image size, which may exceed the cell boundary.
3: Customize the image size by using the height and width
[Optional] height and width define the height and width of the image only when using sizing 3 option.

Supported formats
BMP, JPG/JPEG, GIF, TIFF, PNG, ICO, and WEBP.

Availability
The IMAGE function is available to Insiders running the following Beta Channel builds:

Windows: Version 2209 (Build 15608.10000) or later
Mac: Version 16.65 (Build 22080701) or later
iOS: Version 2.65 (Build 22080701) or later
Android: 16.0.15608.10000 or later

- EQUIPMENT USED --------------------------------
○ My camera – https://amzn.to/3vdgF5E
○ Microphone - https://amzn.to/3gphDXh
○ Camera tripod – https://amzn.to/3veN6Rg
○ Studio lights - https://amzn.to/3vaxyy5
○ Dual monitor mount stand - https://amzn.to/3vbZSjJ
○ Web camera – https://amzn.to/2Tg75Sn
○ Shock mount - https://amzn.to/3g96FGj
○ Boom Arm - https://amzn.to/3g8cNi6

- SOFTWARE USED --------------------------------
○ Screen recording – Camtasia – https://chrismenardtraining.com/camtasia
○ Screenshots – Snagit – https://chrismenardtraining.com/snagit
○ YouTube keyword search – TubeBuddy – https://www.tubebuddy.com/chrismenard

And make sure you subscribe to my channel!

DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week!