MENU

Fun & Interesting

Excel How To: Insert Pictures into Cells with the IMAGE Function in a Formula

Excel University 17,252 2 years ago
Video Not Working? Fix It Now

🔥 Are you trying to learn Microsoft Excel on YouTube? That's the slow way... Learn Excel the FAST way, find out how here 👉 https://www.excel-university.com/yt Check out 7 Excel Time Hacks Everyone Should Know here https://youtu.be/90RmBAmNnG0 In this video, you'll learn How To: Insert Pictures into Cells with the IMAGE Function in a Formula. Microsoft recently announced the rollout of the new IMAGE function. It enables us to write a formula that inserts an image directly into a cell. This opens up many new interesting possibilities. We have been able to insert images into Excel worksheets for a long time. Historically, these images float above the grid in the drawing layer. Images have been independent of the grid. For many situations, this works great. However, when trying to incorporate pictures dynamically, this method was cumbersome. Recently, Microsoft announced the availability of a new function, IMAGE. With it, we are able to write a formula that displays a picture in a cell. Since the path to the image is stored in the formula, we are able to easily change the image path and filename dynamically using the power of Excel formulas. Watch this video to find out how! Subscribe here 👉 https://www.youtube.com/c/ExcelUniversityInc?sub_confirmation=1 and turn on all notifications 🔔 for MS Excel time hacks that will make you more productive! Watch VLOOKUP Hacks Playlist here https://www.youtube.com/playlist?list=PLg6394TGLU5EwVI-6MxpSZOVcoz9eEPVI Watch VLOOKUP vs SUMIFS Playlist here https://www.youtube.com/playlist?list=PLg6394TGLU5EprSnwbRF8_jCVQKde7cjr Watch Dynamic Arrays playlist here https://www.youtube.com/playlist?list=PLg6394TGLU5FmzOe_Pb-zapkM4cX6PDC_ Watch Treasure Maps playlist here https://www.youtube.com/playlist?list=PLg6394TGLU5FTN2vOk-J55wsCej9l-8Dn Watch Slow to Fast playlist here https://www.youtube.com/playlist?list=PLg6394TGLU5HZ7zlZdmYrEUVAW9jYAWzE

Comment