Excel Images - Two New Features - IMAGE function and Data from Image
Posted on: 10/28/2022
Excel has two new image-related features coming out. In this video, a preview of my teaching session at the ASAP (American Society of Administrative Professionals) Virtual Event in November, I walk you through these two new Excel functions.
![IMAGE Function in Excel](https://chrismenardtraining.com/_CMT/images/photos/Original/1493.jpg)
IMAGE Function in Excel
The IMAGE Function inserts images into cells from a webpage or other source location. You can use an image function to load images from anywhere right into your spreadsheet cells (and retain sorting and filtering capabilities).
IMAGE Function Syntax
=IMAGE(source, [alt_text], [sizing], [height], [width])
The only required argument is the source.
YouTube video
![ASAP's Virtual Event - November 17, 2022](https://chrismenardtraining.com/_CMT/images/photos/Original/1497.jpg)
Join Chris Menard at ASAP's Virtual Event on November 17, 2022
ASAP Virtual Event
Chris Menard's Session is Microsoft 365 - New and Upcoming Features from 4:30 pm to 5:45 pm ET
Excel - Data From Picture feature
With Excel's Data from Picture feature, you can insert data from your clipboard, a screenshot, or an image you have saved on your computer.
![Excel - Data from Picture feature](https://chrismenardtraining.com/_CMT/images/photos/Original/1494.jpg)
Excel - Data from Picture feature
Example of Data from Picture
The image on the left is from a website. The image on the right is Data from picture is used to pull in the data from the screenshot.
![Financial screenshot](https://chrismenardtraining.com/_CMT/images/photos/Original/1495.jpg)
Screenshot of financial data
Click to enlarge image
![Data pulled into Excel](https://chrismenardtraining.com/_CMT/images/photos/Original/1496.jpg)
Data pulled into Excel
Recent Excel articles
Chris Menard
Chris Menard is a certified Microsoft Trainer (MCT) and works as a full-time Trainer at BakerHostetler - one of the largest law firms in the US. He runs a YouTube channel with 900+ technology videos that cover various tools such as Excel, Word, Zoom, Teams, Gmail, Google Calendar, and Outlook. To date, the channel has helped over 20 million viewers.
Menard also does 2 to 3 public speaking events every year, presenting at the Administrative Professional Conference (APC), the EA Ignite Conference, the Support Staff Conference, the University of Georgia, and CPA conferences. You can connect with him on LinkedIn at https://chrismenardtraining.com/linkedin or watch his videos on YouTube at https://chrismenardtraining.com/youtube.
Categories