Create Dynamic Hyperlinks in Excel [Video]
During one my recent training programs, a participant asked an interesting question.
I have a list of values. I would like to place a hyperlink in my workbook that would always take me to the last value in the list.
Something like shown aside.
Click on the image to learn how this is done.
An Excel Dashboard to Visualize 10,007 Comments [Dashboard Tutorial]
First some good news, On 21st November, 2010, our little blog received its 10,000th comment!
Thank you so much for making this happen.
Those of you reading chandoo.org for a while know my penchant for comments. I have learned a lot of excel tips & ideas just by reading the comments you posted on this blog. I think comments are one of the best parts of this blog. So, naturally, I wanted to celebrate this milestone, with something big & awesome.
My intention was to download all the 10,000+ comments and play with the data to come up with something outstanding, like a dashboard. It took me 2 days to conceptualize and create this beauty.
How to make a Birthday Reminder in Excel ? [Video]
Learn how to create a birthday reminder worksheet in excel in this video post. You can also download a template to keep track of upcoming birthdays and anniversaries.