From the course: Excel: Advanced Formulas and Functions

Unlock the full course today

Join today to access over 23,200 courses taught by industry experts.

IMAGE

IMAGE

From the course: Excel: Advanced Formulas and Functions

Start my 1-month free trial Buy for my team

IMAGE

“

- Now I'm going to show you something that is really cool. A lot of Excel users have wanted a way to bring images into Excel and have them adjust with formulas. And there is currently a way of doing that, but it is a very delicate, complex process. But now, we've got the image function. It is relatively new and you may not have this yet. But check, you might have it. So, okay, here, let's get into it. The images have to come in via a URL. A lot of us are requesting a way to be able to store these images in the workbook, or locally on our computers, but that's not available to us. You have to use a URL. In D three, four and five I have URLs for images. Now, watch: Equals, image. Double click the source. That's where we need a URL. And I am referencing a cell right here. It's possible for you to type the URL in, and if you do that, you have to wrap it in double quotes. Okay, let's move on. Alt text.…

Contents