🏫 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: kzitem.info/door/PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY
@SB-rx8cc
2 жыл бұрын
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
@gaminghansen8482
2 жыл бұрын
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
@JoannaVancouver
Жыл бұрын
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 :(
@PL4x2
Жыл бұрын
Image function not yet available in my Office 365 version
@neo778
2 жыл бұрын
This is why I love this channel: Useful, short and easy explained.
@benitoventoza6518
2 жыл бұрын
Learning never gets dull with you, Kevin! Truly appreciate all the effort!
@buysmartter
2 жыл бұрын
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.
@sedroulsemporium4392
2 жыл бұрын
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.
@davidhillyer3911
2 жыл бұрын
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?
@YusufMumtaz
2 жыл бұрын
It would be the address you find in File Explorer; or if you use OneDrive, use that URL.
@AaronMarshallsf
2 жыл бұрын
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.
@gaminghansen8482
2 жыл бұрын
If you need my number just let me know I just need help with my channel because it's messed up
@kimmarie5442
Жыл бұрын
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!
@uzzalhosen9984
9 ай бұрын
Hello dear, did you find image option.. I can't find it i am using Excel version 2019
@arkscrew
2 жыл бұрын
I love this channel ever since it rescued my laptop.
@brichter4669
2 жыл бұрын
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.
@TulanKumar
2 жыл бұрын
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.
@BobWoldringh
Жыл бұрын
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.
@TrggrWarning
Жыл бұрын
Same question, this seems odd to me considering a common scenario would include photos of altering inventory and internal.
@YusufMumtaz
2 жыл бұрын
This is especially useful! Easier than the old method of adding images to an Excel table.
@gadget_Bob
2 жыл бұрын
1. Can't use locally stored images? Then that makes this very limited. 2. Requirements at the end should have been mentioned up front.
@Ys_Guy
2 жыл бұрын
I have seen enough videos to know your real dream is having a cookie company!
@KevinStratvert
2 жыл бұрын
😆 it’s a journey
@SKMRify
2 жыл бұрын
@@KevinStratvert Just imagine if you were to actually open a cookie company and enjoy runaway commercial success. That would be something, LoL.
@Ys_Guy
2 жыл бұрын
@@KevinStratvert one small step for man..
@jesushelpme6040
2 жыл бұрын
Hi Kevin, can you do a video on inserting image with an offline ms excel?
@HJay
20 күн бұрын
I need this too 🙂
@Mr-J...
2 жыл бұрын
Look forward to using this in about two years time when us mere mortals stuck on corporate tenants get access to it 😆
@eponymousIme
2 жыл бұрын
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??
@zo9fg
2 жыл бұрын
Does it have to be on the internet? Anyway to link it to a folder on ur computer?
@TipsMedsos
Жыл бұрын
Tutor is very easy
@scottng8171
2 жыл бұрын
Leaning new things again! Thanks!
@headrushindi
2 жыл бұрын
I use Libre Office . The open source alternative. I will have to run right over and see if Libre has a similar function.
@kev_mclernon_family_channe4745
Жыл бұрын
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.
@ruivieirafarinha1930
2 жыл бұрын
Great, great, great Thank you very much.
@prasoonsurendran7916
2 жыл бұрын
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
@Worrelpa
2 жыл бұрын
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.
@Lufc-Chaddy
2 жыл бұрын
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?
@TiMalice2009
2 жыл бұрын
@@Lufc-Chaddy we won’t know until we try. It would be helpful if it does. Not so much if it doesn’t.
@Worrelpa
2 жыл бұрын
@@Lufc-Chaddy No it wouldn't as it need a web based link. A network drive doesn't have that capability.
@digitalguy26ks
2 жыл бұрын
A very big solution to my challenge
@skyekam49
Жыл бұрын
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.
@equinonez55
2 жыл бұрын
How do you upload your pics to the web (I have hundreds in my catalog), so to make them usable with the function IMAGE ?
@bvrbvt05
2 жыл бұрын
Nice to run into this "to-day".
@endtimeswriter
2 жыл бұрын
Kevin how do you get your logo or whatever it is called on your KZitem 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 KZitem video that shows how to do this and am about to start my own channel. I already have a logo ready to use. Thanks.
@VVeiQuek
9 ай бұрын
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)
@javidparsa2199
2 жыл бұрын
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.
@HeatherMajors
2 жыл бұрын
This is a great tip and I can see many use cases for this function.
@Coyote5555
2 жыл бұрын
Glad I have been watching Kevin for a while now... otherwise, I'd be ordering some cookies for real😅
@blenderthenrender7465
3 ай бұрын
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.
@buntee2274
Жыл бұрын
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.
@nancyk777
2 жыл бұрын
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!
@KevinStratvert
2 жыл бұрын
You need a Microsoft 365 subscription and you need to be an office insider. More info in the description 👍
@sebastianaxhoviq2367
2 жыл бұрын
Great video tutorial it's working on my device iOS
@macmac1934
2 жыл бұрын
Kevin, How to get back and reinstall Math Input Panel in Windows11? thanks for sharing.
@alvsroa8371
2 жыл бұрын
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.
@IceHot247
2 жыл бұрын
How do charts read this column? What about PowerBI?
@vinodunny
2 жыл бұрын
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.
@shanleung311
2 жыл бұрын
why cannot call the function of image even update office 365? tks
@keeponballin6094
Жыл бұрын
Hey KEV You've Tought me so much Bro THANKS !!!
@alecarmstrong7538
2 жыл бұрын
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?
@susanbowers8061
2 жыл бұрын
Oh oh! I can’t find IMAGE using the fx button. Is this available for MS Office 365.
@Ken-P
2 жыл бұрын
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.
@SyedMuzammilMahasanShahi
2 жыл бұрын
That is amazing. Thanks Kevin.
@jahidnatore4680
2 жыл бұрын
OK, Thanks for your video .
@SB-rx8cc
2 жыл бұрын
Kevin how to insert a picture onto excel using scanner
@samrust8020
2 жыл бұрын
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
@bettygamero2929
2 жыл бұрын
How you do that please tell
@mariereyes5437
Жыл бұрын
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.
@JoyEll
Жыл бұрын
Thanks very much for making this video!
@Upsettroll
2 жыл бұрын
Can you do an ibis paint x video pls? I see so many tutorials but I can't understand them.
@maloyaircraft1174
Жыл бұрын
Kevin! Your videos are great! Thank you for sharing your expertise!
@cbcpd2035
2 жыл бұрын
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.
@sany5448
2 жыл бұрын
Which software you use for video editing?
@Jojosmith342
Жыл бұрын
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
@ifraz6
Жыл бұрын
I don't see this feature in Excel 2016. Is this available only in a specific excel version
@SKMRify
2 жыл бұрын
Excellent, as usual. You can now view the attachments I mentioned in your Facebook messages.
@arch.blender1178
Жыл бұрын
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 :)
@raccoon874
Жыл бұрын
*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*
@billybobinthehouse12
Жыл бұрын
Thanks for this When clicking on the image, can the image enlarge to full size?
@SwedishChachu
Ай бұрын
Very informative
@antoines.7682
10 ай бұрын
Hello. Thanks for this ! What if we want images on our computer? Does function Image work? 😊 Thanks a lot.
@techcorner2024
2 жыл бұрын
OK teems and conditions apply
@ikeiyke9306
2 жыл бұрын
Thankssssss
@pointrus17rus57
2 ай бұрын
New subscriber here, thanks you for the videos! Great help!
@George-ds5ev
2 жыл бұрын
Great tips, could you do a video on web scraping?
@SpaceOverTime
Жыл бұрын
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
@johnbender1364
Жыл бұрын
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.
@prokorshopal4865
2 жыл бұрын
0:00 - Hi KS. 👋 4:52 - 732nd like from me. 👍 Cheers.
@cosmo9362
Жыл бұрын
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
@YuChen531
Ай бұрын
Thank you very much👍🏻
@lesliebeck8382
2 ай бұрын
How can I do this in my offline version of Excel? It seems like such a simple thing that Excel should have...
@Joker-Leto
Жыл бұрын
Please include iin the titles which version of Excell thank you ...
@radlock1721
Жыл бұрын
Any idea when I type image or =image it is not found. I have updated my excel but still I have nothing showing up.
@Kiwi19927
Жыл бұрын
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 ?
@mystosplosion
3 ай бұрын
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!
@resuwanrazack7253
2 жыл бұрын
FOR INSIDERS ONLY (IN TITLE PLEASE)
@CrocoArt
2 жыл бұрын
Only works for Office 365 though...
@ajayv304
Жыл бұрын
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.
@mahmoudali6205
2 жыл бұрын
Thanks
@khalif8547
2 жыл бұрын
Educative
@jacobuys-pd3iq
7 ай бұрын
Hi Kevin great content ,i do not have the image function available
@Sanjay-et2hd
Ай бұрын
What format should we save the file to see pictures? Mine is showing "value"
@sharon.1978
Жыл бұрын
Thanks, Kevin. How can I insert Bold letters into text fx such as Concatenate?
@ballrnfts1312
Жыл бұрын
how do you do this from image files on your computer?
@avinoamrothenberg1244
2 жыл бұрын
Great video 👍 I wonder although, can I link an image residing on my OneDrive? I've been trying but to no avail
@LJS540
2 жыл бұрын
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).
@avinoamrothenberg1244
2 жыл бұрын
@@LJS540 I have an Insider account, I shared the image from OneDrive with "Everyone". And yet it seems this function aint workin with it.
@abdulrahmanmohamed8825
2 жыл бұрын
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)
@AaronMarshallsf
2 жыл бұрын
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.)
@abdulrahmanmohamed8825
2 жыл бұрын
@@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.
@moseschristopher1922
11 ай бұрын
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.
@fernandoherranz4095
Жыл бұрын
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!
@bellam2413
6 ай бұрын
Thank you
@JoannaVancouver
Жыл бұрын
I can't find this function in my Office365 desktop Excel, nor in Excel online on my Windows laptop. When I open the function window, IMAGE is not listed and not found when I search for it either. Help?
@JoannaVancouver
Жыл бұрын
Oh, right at the end you mention you have to be part of the Office Insider program to find this feature. It would be good if you could mention that at the start.
@JoannaVancouver
Жыл бұрын
But... joining insider program and downloading latest Office update, still doesn't show IMAGE option. I'm in Canada.
@Not-Only-Reaper-Tutorials
Жыл бұрын
I have Excel Office Professional 2019 Plus not the 365 but this is not included
@jamilanjum374
2 ай бұрын
Hi, sir this function available on google excel sheet????
@NoEgg4u
2 жыл бұрын
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?
@KevinStratvert
2 жыл бұрын
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!
@NoEgg4u
2 жыл бұрын
@@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.
@KevinStratvert
2 жыл бұрын
@@NoEgg4u intent is to let people know that the feature is new 👍
@marianross5830
Жыл бұрын
Some of the sources for my images are not on the web but are in One Drive from a personal collection
@brucelafleur6446
Жыл бұрын
awesome. thank you
@joshuadrewlow
Жыл бұрын
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.
@marianross5830
Жыл бұрын
I'd like to make a database of photos with their website link in Excel, please. Please can you advise? Thank you
@birjurajatuladhar4394
Жыл бұрын
Hello Kevin thank you for your videos... Quick question If I have drop down menu with two options... Do we have function to update price in another row if we chose any of them ... Just like I set J8 row 'sweet 1' = J9 row '$1' And if I chose in drop down J8 row 'sweet 2' = J9 row '$2' Is that possible... Thank you in advance
Пікірлер: 189