Excel Links – Delay in State migration visualization results edition

We got more than 50 wonderful entries for this contest. I have compiled 50% of the entries. Due to personal reasons (its annual vacation time at our household), I had to delay the rest and resume it after first week of June. So the results will be announced in 2nd week of June. Thanks for understanding and your patience. Watch this space for mind-boggling dashboards in 3 more weeks.

Here is a trick question. What happens when you zoom down your workbook to 39%? Go ahead and check it. I will wait. Got the answer? Mike shows us that at 39% zoom, Excel maps out named ranges on the cell grid. Pretty cool way to quickly uncover the names in a workbook.

Ever wondered how big, interactive & live dashboards are designed. Recently we had elections in India (largest democracy in the world, so you can imagine the kind of data & challenge this creates). Gramener, a data visualization company partnered with Microsoft & CNN-IBN (Indian version of CNN) create a cool live dashboard on poll results day. They tell us the process behind creation of such dashboard in this article & the few that follow it. Very insightful.

That is all for now. I will see you again in next post.

Sign-up for our FREE Excel tips newsletter:

Here is a smart way to become awesome in Excel. Just signup for my FREE Excel tips newsletter. Every week you will receive an Excel tip, tutorial, template or example delivered to your inbox. What more, as a joining bonus, I am giving away a 25 page eBook containing 95 Excel tips & tricks. Please sign-up below:

about “state migration visualization contest”, I am very sorry to say, but the management of this competition is quite disappointing … I think you had to publish the files immediately and allow the two juries (popular and experts) to do their job

about the “some juicy, delicious and awesome Excel links” … is it possible to add here in the comments the links of our articles published in the last month?
we think that these are very cool, and do not understand why they were excluded from this collection

“is it possible to add here in the comments the links of our articles published in the last month?”

Of course yes. I read a bunch of Excel blogs thru my RSS reader. I have added your site to my daily reading list. I know E90E50 has many beautiful, creative and outstanding examples of what can be done with Excel. I will certainly feature your work here. Sorry I missed it earlier because your site was not part of my daily reading list (I some how assumed that you have no RSS feed. I am wrong).

Now your first point,

“I am very sorry to say, but the management of this competition is quite disappointing”

I can understand your disappointment. But sorting thru contest entries is no easy task. I spend between 10 to 15 minutes per file and take several screenshots, animated demo, note down comments on the technique used. Doing this for 50 files takes a lot of time. When you combine this with equally busy personal life, process of running a business, writing for a website etc. you can guess what happens.

Since this contest has no time sensitive nature, I assume no one should have a problem when the results are posted.

you said: “Since this contest has no time sensitive nature, I assume no one should have a problem when the results are posted”

this is true but I can not wait to see the files and could not imagine having to wait all this time … ok , maybe I’m too impatient I’m sorry …

I think the greatness of chandoo is also about being able to take criticism and always aim to improve, this is a great site for its audience and its staff … Hui, Jeff and Chandoo (and all other), keep it up

Now for something more important: I second Roberto’s request: you should definitely have a closer look at the work of the Franken’s team and consider to mention them in one of your next Excel Links posts:

@Robert
i like your follow-up post too … well done
you are one of the best experts and innovator that I know … so this:
“They are way more innovative with Excel than I will ever be”
is not true …
anyway thanks of your words