Tag Archives: Linked Picture

The making of an interactive CV in #Excel

Posted on January 27, 2018 by MF

What to do with Linked Picture to create something interesting in #Excel? How about an Interactive CV to show off your Excel skills!? First, why? Once upon a time when I updated my CV, I was thinking… Everyone states something … Continue reading →

Rate this:

Posted in Excel Tips | Tagged Custom Lists, Dashboard, Format, INDIRECT, Linked Picture, Pivot Table, Slicer | 1 Comment

How to lookup an image in #Excel

Posted on January 20, 2018 by MF

Lookup an image using “Linked Picture” in #Excel Perhaps you have used VLOOKUP to return a value from a table very often. However you cannot use VLOOKUP to return an image… So how the above can be done? You will … Continue reading →

Rate this:

Posted in Excel Tips, Formula | Tagged INDEX, Linked Picture, MATCH | 8 Comments

Interactive Chart with navigation panel [NO VBA]

Posted on March 4, 2017 by MF

Isn’t it nice? Don’t think that this is difficult. No VBA is required. Indeed you only need to know a few Excel skills in order to create an interactive chart with navigation panel like this. The skills required: Conditional formatting … Continue reading →

Rate this:

Posted in Chart | Tagged Conditional Formatting, Form Controls, INDEX, Interactive chart, Linked Picture, ROW | Leave a comment

Paste Special – Linked Picture (aka “Camera” in earlier versions of Excel)

Posted on November 22, 2013 by MF

As mentioned in my previous post, I am going to talk about another built-in function that is not commonly used (in my limited community)… 😛 COPY, PASTE linked picture (aka “Camera”, which is actually available in Excel 2003; not sure … Continue reading →