🏫 Learn the fundamentals of Excel in just 2 hours: kevinstratvert.thinkific.com 📩 Get the latest high-quality tutorial and tips and tricks videos emailed to your inbox each week: kevinstratvert.com/newsletter/ ⏭ Watch next - playlist with all my free tutorial videos on how to use Excel: ruclips.net/p/PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY
This comment does not pertaining to the contents of your video. I was looking for a tutorial on how to change my channel name and out of three creators, you were the most concise and to the point with no additional BS. Thank you! I had no idea it was simple enough.
Are you spying on me, Kevin? This is the third time I have a specific issue with office and you come up with a video about it a week after. I was just wondering last week how come it's not possible to insert images to cells in such an advanced product as excel. Got my answer. Amazing! Loves your videos. They are really helpful.
I've been looking for a solution to this for a long time now, but didn't find anything satisfactory. This helps a great Kevin. Can you also share if there's any way we can add images without online sources, like upload from a folder.
Adding images from your own computer is, of course, the only useful application. I have the same need as you have. And, many images from online will not be accepted by this Image-function. A pitty.
The Image feature is great, but for now, seems you must be an Office Insider to have access to and use it. I updated my Office 365 and still don't have the new Image function. I was all hyped up to use it for a spreadsheet I am doing that needs photos, but I am not an Office Insider, so no access. Bummer!! Hopefully, it will be rolled out soon.
Each storage product surfaces the url differently, based on permissions. Personal OneDrive (share icon or option, set permission level and copy link). Viewability starts with the user’s access for that url. The image is not part of the excel file, the cell is basically a web browser bookmarked to that one page.
Question: Does this mean I cannot use an image on my computer? I'm creating an inventory sheet and I've taken pics I'd like to have with it. Thank you!
Excellent. I was using a macro (yuck!) to insert images into cells from a database application. This will make it much easier to not only add them into a non-macro enabled Excel file but also have the images participate in interactive changes such as the sort/filter that you showed. Thank you.
Waaaah! I don't have IMAGE as a selection. Closest option is "IMAGINARY." Have a Microsoft 365 subscription and am using Excel 16.64 on a Mac. Wha' happened??
Excellent video and very useful. I have a doubt though. Can I use the image in my personal Google drive or onedrive to embed this way? And if yes, if I sent the file to someone else, would they be able to view the pics? Thanks
Hi Kevin, I have learnt alot useful skills in excel with your video. Thanks. I have a question regarding this topic for inserting image in Excel Cell. I tried to use the insert function but when select a function where I type Image there is no results shown. May I know what I can do to include this? I even resort to use formula =image.... but no Image formula comes out. Also, I was wondering if these cells can be use in the same cells as texts like a description of the image and then the image? Thanks in advance.
I don't see this function, even when I try to search for it like you did in the video. I tried the web version and it's not there either. This is a great tip though and I like your videos!
Hello Kevin, thank you for yet another great video. I have a couple of questions I really hope you can share your expertise on - 1) Is it possible to create a Drop Down List in so when a particular option is chosen from the list an image appears instead of the option text itself? 2) Using a Drop Down List, can I create a unique comment (example: Associated SKU) that is tied to whichever option is chosen from the drop down list? Thank you for your time.
Kevin how do you get your logo or whatever it is called on your RUclips video channel.The small round picture with your name next to it, beneath your video on the right? It also shows how many subscribers you have. I cannot find any RUclips video that shows how to do this and am about to start my own channel. I already have a logo ready to use. Thanks.
Hi Kevin, thanks it was very useful trick but how do i have this fubctiob (IMAGE) in my excel? I tried to use it but my excel doesn't support that! I have newest version of iffice 365.
I love the subtle humor you add! Needing to work on your fortune cookie recipe 😅 Thanks for all your amazing tips. You make it easy to see how your tips and tricks can be implemented into personal needs.
You can also present it as a comment (or known as "note" in later versions), by editting the whole overlay's background as the picture. It is kinda tricky to set up, but it saves space and it looks so pro.... Credit to the instructor who shared this in a Excel VBA course (who also taught me the shorthand variable initialization in VBE)
Hey bro do you have any idea about the outlook verification mouse and cheese problem? I have an MS 365 family subscription but I could not make a new outlook account. I need help.
Hi - Excel has always had the ability to insert images into cells, but it does not currently work with Excel online. Presumably, this video is showing a new addition which will also work with Excel online?
Thank you . It is nice to learn something new from time to time. Is it possble to make two sheets in one excel workbook, one for picures and use them as a reference on the other sheet because I do not want to put or copy pictures from online? thx
Apparently the image function is still being rolled out but only to people who are part of the insider programme, the rest of us will have to wait a while.
Wonder why it's not available in my install. I have a version later than the one MS says you need. Availability The IMAGE function is available to Insiders running the following Beta Channel builds: Windows: Version 2209 (Build 15608.10000) or later I have Version 2211 build 15831.202089
Mine hadn't updated in the last 2 years, I finally got it updated uninstalling & reinstalling, but even with most recent version & Beta Insider, I still didn't have the Image function. It turned out, for me anyway, that many updated things weren't accessible to me because of a couple not checked boxes in Options. Once I went to: File > More... > Options > General > Privacy Settings > and checked, "[ ] Turn on all connected experiences", which also auto checks everything above it in the Connected Experiences section, then all the updated list of things including the Image Function were available and working. Of course maybe yours is checked & something else. Just putting in case it might help save someone time getting it to finally work.
I m looking for a solution to embed an image in EXCEL MAC into a cell. By double clicking the little image I like to raise it big as the screen is. Any solution for that ?
Thank you How about an advanced video on how to extract pdf data (and scanned pdf too = OCR) and put them into excl using Python (how to convert pdf to excel using Python)
Power Query has a from PdF connector that does a pretty good job with table data and image to table is for photo/OCR versions of the same. (Available to insiders for desktop PCs and standard for IOS and macos Apps. (IOS tends to give better results but it was similar to start, so pc should improve.)
When you are doing these tutoria,l please can you indicate the version and build of the software you are using. Because the Microsoft 365 Apps for Business - Microsoft Excel (Version 2208 Build 15601.20088), cannot do this, or do i need specific template.
Make sure you all have the correct version of Office/Microsoft 365 for this to work. I have Office and no luck. Oh well- good tutorial though, as always!
Hi Kevin, are there any caveats to use apart from Office Insider? I am signed up as a Office 365 user and Office insider beta but still no IMAGE functions available. Perhap I need to be in the USA :)
Thanks a lot for the tutorial. Not able to find the option IN Office 365. I am actually intrested in exporting the image file to Power BI by using the hyperlink of picture on desktop excel app.
Kevin, why did you put "NEW" in the title of your video? I am asking, because others that do so, seem to always end up leaving it there, and years later, their video's title still reads "NEW". Will you be editing your title, by way of removing "NEW", when you deem it is no longer "NEW"? What period of time do you feel would be appropriate?
I included new since there are workarounds to doing this that have been around a while and this helps differentiate. I personally use new in combination with the publish date on a video and that tells me that it was new as of the publish time. Cheers!
@@KevinStratvert Do you mean that the feature was new, based on the date you are publishing your video? If that is your reason, then I (and probably others) will not interpret "NEW" as a new feature, but rather a new video. I thought that you wanted people to know that you posted a new video.
Try using a Google Drive link instead but you probably need to set the link to be shared with everyone that clicks on the link. (I don't have Microsoft Insider so I can't test this yet).
Thanks for video. When I try this the dialog box where I typed "image" comes back with "Please rephrase your question". I do not get the "image" function as a choice in the select a function dialog box. What version of software is required to have the image function? Thanks
How to add image from local disk? I cannot find the buttons from the explanation of Microsoft, without any screenshot as always... Actually the "Place in cell" option doesn't exist in my Excel on Mac.
🏫 Learn the fundamentals of Excel in just 2 hours: kevinstratvert.thinkific.com
📩 Get the latest high-quality tutorial and tips and tricks videos emailed to your inbox each week: kevinstratvert.com/newsletter/
⏭ Watch next - playlist with all my free tutorial videos on how to use Excel: ruclips.net/p/PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY
I have read how to insert images in cells with excel but how to insert a scanned image was not mentioned it seems an impossible task
Do you have a number that I can use to call you and try having you guide me to tell me how to fix my channel chat and my channel screen
Or at least that's how I think it would work. Unfortunately, my new version of Insider Excel doesn't have the ability to enter IMAGE :(
Image function not yet available in my Office 365 version
This is why I love this channel: Useful, short and easy explained.
Learning never gets dull with you, Kevin! Truly appreciate all the effort!
This comment does not pertaining to the contents of your video. I was looking for a tutorial on how to change my channel name and out of three creators, you were the most concise and to the point with no additional BS. Thank you! I had no idea it was simple enough.
Are you spying on me, Kevin? This is the third time I have a specific issue with office and you come up with a video about it a week after. I was just wondering last week how come it's not possible to insert images to cells in such an advanced product as excel. Got my answer. Amazing! Loves your videos. They are really helpful.
I love this channel ever since it rescued my laptop.
I've been looking for a solution to this for a long time now, but didn't find anything satisfactory. This helps a great Kevin.
Can you also share if there's any way we can add images without online sources, like upload from a folder.
Adding images from your own computer is, of course, the only useful application. I have the same need as you have. And, many images from online will not be accepted by this Image-function. A pitty.
Same question, this seems odd to me considering a common scenario would include photos of altering inventory and internal.
Tutor is very easy
The Image feature is great, but for now, seems you must be an Office Insider to have access to and use it. I updated my Office 365 and still don't have the new Image function. I was all hyped up to use it for a spreadsheet I am doing that needs photos, but I am not an Office Insider, so no access. Bummer!! Hopefully, it will be rolled out soon.
This is especially useful! Easier than the old method of adding images to an Excel table.
Thank you, and interesting tutorial. But, how does one create such a URL link for an image that one has in their personal photo storage?
It would be the address you find in File Explorer; or if you use OneDrive, use that URL.
Each storage product surfaces the url differently, based on permissions. Personal OneDrive (share icon or option, set permission level and copy link). Viewability starts with the user’s access for that url. The image is not part of the excel file, the cell is basically a web browser bookmarked to that one page.
If you need my number just let me know I just need help with my channel because it's messed up
Nice to run into this "to-day".
Leaning new things again! Thanks!
Great, great, great Thank you very much.
A very big solution to my challenge
I use Libre Office . The open source alternative. I will have to run right over and see if Libre has a similar function.
1. Can't use locally stored images? Then that makes this very limited.
2. Requirements at the end should have been mentioned up front.
Hi Kevin, can you do a video on inserting image with an offline ms excel?
I need this too 🙂
Question: Does this mean I cannot use an image on my computer? I'm creating an inventory sheet and I've taken pics I'd like to have with it. Thank you!
Hello dear, did you find image option.. I can't find it i am using Excel version 2019
Look forward to using this in about two years time when us mere mortals stuck on corporate tenants get access to it 😆
Excellent. I was using a macro (yuck!) to insert images into cells from a database application. This will make it much easier to not only add them into a non-macro enabled Excel file but also have the images participate in interactive changes such as the sort/filter that you showed. Thank you.
Thankssssss
Great video tutorial it's working on my device iOS
OK, Thanks for your video .
Some of the sources for my images are not on the web but are in One Drive from a personal collection
Waaaah! I don't have IMAGE as a selection. Closest option is "IMAGINARY." Have a Microsoft 365 subscription and am using Excel 16.64 on a Mac. Wha' happened??
Does it have to be on the internet? Anyway to link it to a folder on ur computer?
0:00 - Hi KS. 👋 4:52 - 732nd like from me. 👍 Cheers.
This is a great tip and I can see many use cases for this function.
What if the image is in a folder on my desktop? how do i create an online source for the image i created? Thank you for your help.
Excellent video and very useful. I have a doubt though. Can I use the image in my personal Google drive or onedrive to embed this way? And if yes, if I sent the file to someone else, would they be able to view the pics?
Thanks
Hi Kevin, I have learnt alot useful skills in excel with your video. Thanks. I have a question regarding this topic for inserting image in Excel Cell. I tried to use the insert function but when select a function where I type Image there is no results shown. May I know what I can do to include this? I even resort to use formula =image.... but no Image formula comes out.
Also, I was wondering if these cells can be use in the same cells as texts like a description of the image and then the image?
Thanks in advance.
Thank you very much👍🏻
Very informative
I don't see this function, even when I try to search for it like you did in the video. I tried the web version and it's not there either. This is a great tip though and I like your videos!
You need a Microsoft 365 subscription and you need to be an office insider. More info in the description 👍
Hey KEV
You've Tought me so much Bro
THANKS !!!
Excellent, as usual. You can now view the attachments I mentioned in your Facebook messages.
Hello Kevin, thank you for yet another great video. I have a couple of questions I really hope you can share your expertise on -
1) Is it possible to create a Drop Down List in so when a particular option is chosen from the list an image appears instead of the option text itself?
2) Using a Drop Down List, can I create a unique comment (example: Associated SKU) that is tied to whichever option is chosen from the drop down list?
Thank you for your time.
Glad I have been watching Kevin for a while now... otherwise, I'd be ordering some cookies for real😅
Thank you for opening my eyes, but I wonder how you get the picture to pop up while you hover over it? thanks for everything.
New subscriber here, thanks you for the videos!
Great help!
Educative
Can you do an ibis paint x video pls? I see so many tutorials but I can't understand them.
Thanks
Kevin how do you get your logo or whatever it is called on your RUclips video channel.The small round picture with your name next to it, beneath your video on the right? It also shows how many subscribers you have. I cannot find any RUclips video that shows how to do this and am about to start my own channel. I already have a logo ready to use. Thanks.
How do you upload your pics to the web (I have hundreds in my catalog), so to make them usable with the function IMAGE ?
*if the website in the link changes the picture, then it'll change yours as well, so it would be better to have your own photo upload site link*
That is amazing. Thanks Kevin.
I have seen enough videos to know your real dream is having a cookie company!
😆 it’s a journey
@@KevinStratvert Just imagine if you were to actually open a cookie company and enjoy runaway commercial success. That would be something, LoL.
@@KevinStratvert one small step for man..
Hi Kevin, thanks it was very useful trick but how do i have this fubctiob (IMAGE) in my excel?
I tried to use it but my excel doesn't support that!
I have newest version of iffice 365.
I love the subtle humor you add! Needing to work on your fortune cookie recipe 😅 Thanks for all your amazing tips. You make it easy to see how your tips and tricks can be implemented into personal needs.
OK teems and conditions apply
I wonder if that image control will work with images stored on SharePoint. Obviously the people using the work book would need access to those images.
I was wondering that too. I was thinking, if you could link to a network folder it should work in the same way. Do you agree?
@@Lufc-Chaddy we won’t know until we try. It would be helpful if it does. Not so much if it doesn’t.
@@Lufc-Chaddy No it wouldn't as it need a web based link. A network drive doesn't have that capability.
Kevin, How to get back and reinstall Math Input Panel in Windows11? thanks for sharing.
Kevin! Your videos are great! Thank you for sharing your expertise!
You can also present it as a comment (or known as "note" in later versions), by editting the whole overlay's background as the picture. It is kinda tricky to set up, but it saves space and it looks so pro....
Credit to the instructor who shared this in a Excel VBA course (who also taught me the shorthand variable initialization in VBE)
Thanks very much for making this video!
Thank you
nice 👍
How do charts read this column? What about PowerBI?
Hey bro do you have any idea about the outlook verification mouse and cheese problem? I have an MS 365 family subscription but I could not make a new outlook account. I need help.
why cannot call the function of image even update office 365? tks
Kevin how to insert a picture onto excel using scanner
Only works for Office 365 though...
Hi - Excel has always had the ability to insert images into cells, but it does not currently work with Excel online. Presumably, this video is showing a new addition which will also work with Excel online?
Thanks!
Great tips, could you do a video on web scraping?
Thank you . It is nice to learn something new from time to time. Is it possble to make two sheets in one excel workbook, one for picures and use them as a reference on the other sheet because I do not want to put or copy pictures from online? thx
How you do that please tell
awesome. thank you
FOR INSIDERS ONLY (IN TITLE PLEASE)
Oh oh! I can’t find IMAGE using the fx button. Is this available for MS Office 365.
Apparently the image function is still being rolled out but only to people who are part of the insider programme, the rest of us will have to wait a while.
Which software you use for video editing?
Wonder why it's not available in my install. I have a version later than the one MS says you need. Availability
The IMAGE function is available to Insiders running the following Beta Channel builds:
Windows: Version 2209 (Build 15608.10000) or later
I have Version 2211 build 15831.202089
Mine hadn't updated in the last 2 years, I finally got it updated uninstalling & reinstalling, but even with most recent version & Beta Insider, I still didn't have the Image function. It turned out, for me anyway, that many updated things weren't accessible to me because of a couple not checked boxes in Options.
Once I went to: File > More... > Options > General > Privacy Settings > and checked, "[ ] Turn on all connected experiences", which also auto checks everything above it in the Connected Experiences section, then all the updated list of things including the Image Function were available and working.
Of course maybe yours is checked & something else. Just putting in case it might help save someone time getting it to finally work.
Please include iin the titles which version of Excell thank you ...
I don't see this feature in Excel 2016. Is this available only in a specific excel version
I m looking for a solution to embed an image in EXCEL MAC into a cell. By double clicking the little image I like to raise it big as the screen is. Any solution for that ?
Thank you
How about an advanced video on how to extract pdf data (and scanned pdf too = OCR) and put them into excl using Python (how to convert pdf to excel using Python)
Power Query has a from PdF connector that does a pretty good job with table data and image to table is for photo/OCR versions of the same. (Available to insiders for desktop PCs and standard for IOS and macos Apps. (IOS tends to give better results but it was similar to start, so pc should improve.)
@@AaronMarshallsf Thank you, I saw it, but it just gave me random letters. I think maybe because the PDF in Arabic? I don't know.
You love your cookies
When you are doing these tutoria,l please can you indicate the version and build of the software you are using. Because the Microsoft 365 Apps for Business - Microsoft Excel (Version 2208 Build 15601.20088), cannot do this, or do i need specific template.
Thanks for this
When clicking on the image, can the image enlarge to full size?
Hi Kevin great content ,i do not have the image function available
Make sure you all have the correct version of Office/Microsoft 365 for this to work. I have Office and no luck. Oh well- good tutorial though, as always!
Hi Kevin, are there any caveats to use apart from Office Insider? I am signed up as a Office 365 user and Office insider beta but still no IMAGE functions available. Perhap I need to be in the USA :)
Any idea when I type image or =image it is not found. I have updated my excel but still I have nothing showing up.
Hello. Thanks for this ! What if we want images on our computer? Does function Image work? 😊 Thanks a lot.
Hi Kevin, I can't find fx image in excel 2016. Is there any way to insert image based on cell value? Ex: each student has his/her photos. Thanks
How can I do this in my offline version of Excel? It seems like such a simple thing that Excel should have...
Thanks a lot for the tutorial. Not able to find the option IN Office 365.
I am actually intrested in exporting the image file to Power BI by using the hyperlink of picture on desktop excel app.
Kevin, why did you put "NEW" in the title of your video?
I am asking, because others that do so, seem to always end up leaving it there, and years later, their video's title still reads "NEW".
Will you be editing your title, by way of removing "NEW", when you deem it is no longer "NEW"? What period of time do you feel would be appropriate?
I included new since there are workarounds to doing this that have been around a while and this helps differentiate. I personally use new in combination with the publish date on a video and that tells me that it was new as of the publish time. Cheers!
@@KevinStratvert Do you mean that the feature was new, based on the date you are publishing your video?
If that is your reason, then I (and probably others) will not interpret "NEW" as a new feature, but rather a new video.
I thought that you wanted people to know that you posted a new video.
@@NoEgg4u intent is to let people know that the feature is new 👍
I'm still finding it hard to insert a picture from my PC and making it look like this without resizing. I was hoping to get help on that.
Great video 👍
I wonder although, can I link an image residing on my OneDrive? I've been trying but to no avail
Try using a Google Drive link instead but you probably need to set the link to be shared with everyone that clicks on the link. (I don't have Microsoft Insider so I can't test this yet).
@@LJS540 I have an Insider account, I shared the image from OneDrive with "Everyone". And yet it seems this function aint workin with it.
how do you do this from image files on your computer?
I have Excel Office Professional 2019 Plus not the 365 but this is not included
Excel does not save images inside the chart?) Usual buthead workaround)
Thanks for video. When I try this the dialog box where I typed "image" comes back with "Please rephrase your question". I do not get the "image" function as a choice in the select a function dialog box. What version of software is required to have the image function? Thanks
Hi! Is it possible to do conditional formatting with custom images? I have my own icons but can’t figure out how to use them!
How to add image from local disk? I cannot find the buttons from the explanation of Microsoft, without any screenshot as always... Actually the "Place in cell" option doesn't exist in my Excel on Mac.
Has anyone been able to try using embedded images in a Mail Merge?
What format should we save the file to see pictures? Mine is showing "value"