Use Microsoft® Excel Differently to Gain a Productive Edge
Issue - Apr 2011
In one of the past trainings, we had a group of participants from the retail industry. Their company, which was an American MNC retailer, carried thousands of products of many designs and for different segments of customers. For them, it was impossible to know the code of every product. So they wanted to know if Excel could display a picture of the product when the product code is selected. That would definitely make the numbers they are analyzing a lot more meaningful.
At that point in time, I had some idea how it could be done with the OFFSET formula and the camera function in Excel but did not have the opportunity to get down working on it. When I finally did, I was pleased with the outcome of the solution.Because I am sure nobody ever thought that was at all possible. Watch the video and witness how the solution at work.
Download this "display product image" file and find out how it works.
If you received this newsletter from a friend and would like to be included in our mailing list, please go to our Excel Today's page.
If you have a facebook account, you can like us at facebook or linkedln. From facebook or LinkedIn, you will be notified on mini cases and ideas how we use Excel on a day to day basis. These tips may not be published in our newsletter.
everydayExcel Business Lab Pte Ltd
Author of "Hidden Secrets of Data Analysis with Excel" and
"Excel Secrets for Highly Effective Marketers"
Received this newsletter from a friend? You can request to be included in our mailing list by signing up at our Excel Today's page. If you have friends whom you think might be interested in this newsletter, feel free to send it to them.