Tag Archives: Linked Picture

The making of an interactive CV in #Excel

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 , , , , , , | 5 Comments

How to lookup an image in #Excel

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 , , | 20 Comments

Interactive Chart with navigation panel [NO VBA]

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 , , , , , | 3 Comments

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

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

Rate this:

Posted in Excel Tips | Tagged , , | 6 Comments