Archive for November, 2008

5 things that helped me run 10k

Published on Nov 30, 2008 in personal, Random

As told earlier I have finished my 10 k run today (actually 13 k). Even though running 10 kilometers is not a big deal for many people, it is a HUGE deal for me and I thought I would write a small post sharing my experience of crossing this important milestone.

Continue »

Say thanks with an excel tip

Published on Nov 26, 2008 in blogging, Featured, Learn Excel

Tomorrow is thanksgiving day here. It is a harvest festival on which people express thanks for what they have. Much like Sankranthi (pongal) in India. At this moment I am very angry and frustrated about the terror strikes in Mumbai. I am not sure how a person can do something like this to others. I […]

Continue »

Prevent users from scrolling away on your dashboards [dirty little trick]

Published on Nov 25, 2008 in Charts and Graphs, Learn Excel

Dashboards let users get all the information they want in a quick glance. Not if users start using scroll bars and scroll down to cell A64000. So here is a quick and dirty trick. Assuming your dashboard ends in row 40, select row 41 and go to menu > window > freeze panes. That way […]

Continue »

Advanced Data Validation Techniques in Excel [spreadcheats]

Published on Nov 25, 2008 in Learn Excel
Advanced Data Validation Techniques in Excel [spreadcheats]

Data validation is a great way to keep your users informed about possible values in a cell and guide them to select something appropriate. As part of the spreadcheats series, in this post we will discuss 2 advanced data validation techniques that can help you when you are modeling a complex worksheet.

Continue »

Fun way to clean up modern art with visualization

Published on Nov 25, 2008 in Cool Infographics & Data Visualizations

TED Talks are a great way to keep your mind nourished. They inspire you, give you a ton of new ideas. I saw this ted talk (embedded below) Tidying up art by Ursus Wehrli and couldn’t resist sharing it with you. It is an entertaining one and I recommend watching it. In this talk the […]

Continue »

Excel Links of the Week – PHD’s new tag line [Nov 24]

Published on Nov 24, 2008 in blogging, excel links

This is probably the 100th time I have changed this site’s tag line. So, it may not be a great news to you. But again, I need to say out this loud so that you, my dear reader, will know what this blog is going to stand for: Excel Tips, Charting Ideas and Visualization Oomph. […]

Continue »

Introducing Excel Formula Helper

Published on Nov 24, 2008 in blogging, Learn Excel
Introducing Excel Formula Helper

One of the most common comments we get here is “how does xxx formula works?” Even though there is vast documentation on excel formulas including the built-in help in MS Office, often it is difficult for us to learn a formula quickly and use it in a snap. So to help new users of excel […]

Continue »

Google Spreadsheets Holiday Art Template

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 […]

Continue »

5 visualizations to inspire you [Nov 21]

Published on Nov 21, 2008 in Cool Infographics & Data Visualizations
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 […]

Continue »

Generating Random Phone Numbers

Published on Nov 20, 2008 in Analytics, Learn Excel
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 […]

Continue »

vlookup(), match() and offset() – explained in plain english [spreadcheats]

Published on Nov 19, 2008 in Featured, Learn Excel
vlookup(), match() and offset() – explained in plain english [spreadcheats]

VLOOKUP may not make you tall, rich and famous, but learning it can certainly give you wings. It makes you to connect two different tabular lists and saves a ton of time. In my opinion understanding VLOOKUP, OFFSET and MATCH worksheet formulas can transform you from normal excel user to a data processing beast. Today, […]

Continue »

The new Mac vs. PC web ad by Apple is really cool

Published on Nov 19, 2008 in advertising, technology
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 […]

Continue »

What would you like to ask Charley Kyd of Exceluser.com in an interview?

Published on Nov 18, 2008 in Learn Excel

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 […]

Continue »

Make your VBA macros work anywhere: Enable Relative References

Published on Nov 18, 2008 in Learn Excel
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 […]

Continue »

Excel Links of the Week – Do you want to run 10k with me edition

Published on Nov 17, 2008 in Learn Excel, personal

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. […]

Continue »