Google Spreadsheets Holiday Art Template
This is pure fun! Few Googlers used the collaborative feature in Google Spreadsheets to create a holiday art template with snow flakes using 18 colors. Each of them added few colors on a blue canvas to create this massive template. The best part is they even made a time lapse video of the whole process […]
5 visualizations to inspire you [Nov 21]
The best 3d pie chart ever We all know that 3D pies are not a very good way to express your story. I guess this one is an exception we all are happy to make [via PTS Blog] How to solve problems – Interactive visualization This interactive visualization shows how to solve problems in a […]
Generating Random Phone Numbers
Often when you are writing code or testing an application, it might be helpful to have random phone numbers generated for you. Here is an excel formula that I use: =value(left(substitute(rand(),”0.”,””),10)) try these 2 instead (thanks to John) =RAND()*(9999999999-1000000000)+1000000000 =RANDBETWEEN(1000000000,9999999999) [needs analysis toolpack add-in or excel 2007] Even though it works most of the time […]
The new Mac vs. PC web ad by Apple is really cool
Did you checkout the new web based Mac vs. PC ads Apple is running on the CNN.com? They are totally cool. why? because, in that ad, the PC guy walks from one ad-block to another creating wow user experience for whoever seeing the ad. Here is a small animation I have created out of it […]
What would you like to ask Charley Kyd of Exceluser.com in an interview?
I have an exciting news for you, Yesterday I have mailed Charley Kyd – an Excel MVP, author of four books and 50+ articles for various national media, owner of exceluser.com and creator of popular products like plug-n-play excel dashboard kit. And he has agreed to give me an interview over phone / email. The […]
Make your VBA macros work anywhere: Enable Relative References
Do you know that while recording macros in excel you can use the relative reference based recording so that you can use your macro anywhere and the references would be adjusted automatically? Yes! I have learned this yesterday and I thought it is pretty cool. Here is how you can make your macro VBA code […]
Excel Links of the Week – Do you want to run 10k with me edition
It has been almost 9 months since I crossed the 5k running mark for the first time in my life. Running is one of the most enjoyable things I do. I have been running between 5 and 7 kilometers ever since. I wanted to run 10 kilometers and finally I am confident of doing it. […]