Weekly Excel Links – After a Long Time Edition
It has been a while since we have a weekly excel links post here, and that is not because there were no excel posts out side this blog. It is just because I have been a little busy at work and personal life (a big & exciting change happening, hush, hush) that I had to cut few posts to keep me sane.
But anyways, here is a fresh installment of excel links from around the web. I will try to post few more weekly links posts this month.
Have you ever used Match() or other lookup functions and felt that the need for matching multiple items in a range? Well, you can do that using UDF (user defined functions). Newton Excel Bach provides a simple mmatch() UDF that can scan a range for multiple matching items in a row and then returns the row number. Try it…
A simple but very intuitive data validation hack. AlexJ, who is also a regular commenter here, has suggested Debra @ contextures this hack.
While most of us wouldn’t need to use 2 legends in a chart, if you ever need to use more legends, this is one hell of a simple way to do it.
How to include images in a cell comment ? Well, using VBA. But how ? That is where, JP @ Code for outlook and excel provides us this simple macro that can insert images in to comments.
Few weeks back I have attended the chart tamer demo. What is chart tamer? It is a product from Bonavista systems (the same guys who gave us Bonavista Microcharts product) that aims to simplify chart making process in excel. Well, it is an ambitious product, and Andreas, Stephen Few & team have managed to do that. The chart tamer looks very slick, works like a charm and promises a bright, clear and hassle free future for excel chart makers.
Note to self: enough already, write a simple review about chart tamer along with few screen caps sometime this week.
Note to you: I have been aiming to write that review for a while, then again, read the first paragraph of this post.
Got a link? or Want to just say hi?
Go ahead and type out a mail and send it to me at chandoo.d @ gmail.com. I like reading mails from you and knowing new things.
Leave a Reply
|How Many Bubbles are Too Many Bubbles?||5 Areas where Mouse Kicks Keyboard’s Butt|