Excel Links of the Week – What is really happening Edition

First let me give you some excuses for not posting regularly.

Last month has been very hectic due to sudden travel to Sweden from Chennai. I could hardly manage a handful of posts. Moving to a new place meant I could find very little time to respond to reader mail. I am sorry if you have sent me an email and didn’t get a response. Thankfully, I have managed to carve out a new posting schedule since last week and I will be sticking to 3-4 posts per week going forward.

Now time for some good news. Our twitter follower base has grown to 3 digits. Yes, R1C1, PHD’s twitter presence has a hundred followers. If you are in to birds or micro-blogging you should probably follow me over there.

Moving on to this week’s excel links,

Using various shades to depict uncertainty in predictions

In a fine charting tutorial, Peltier teaches us how to show uncertainty in predictions using shaded lines. Even though I have never seen charts like this before, I think this is one of the coolest ways to use area charts. Go check it out for yourself.

Vlookup on 2 columns

Dick shares with us 3 techniques to lookup in 2 columns at a time. I prefer using either vlookup with helper column in the beginning or index with helper column in the end.

Spreadsheet Barbecue Grill, Really!!!

Finally a barbecue grill that looks like a spreadsheet. No comments.

NodeXL – Visualizing Large Social Network’s Data in Excel

NodeXL is an excel 2007 template for visualizing social networks. It is a collaboration between Microsoft Research, University of Maryland, Telligent Systems, Cornell, University of Washington. The project has several cool visualizations and comes handy when you need to visualize a large network of data (for eg. hierarchical relationships in a large, complex organization)

Questioning Data to Ink Ratio(opens a PDF)

In this beautiful and insightful newsletter, Stephen Few questions the “data to ink ratio” and suggests that we must raise our voice (ie use more ink) if needed.

Excel Dashboard and Visualization Bootcamp

Jon Peltier and Mike Alexander (of DataPig Technologies) are conducting a Excel dashboard and visualization bootcamp between May 20 and 22. It is in Frisco, Texas. If your job involves considerable amount of dashboard creation and visualization, you might want to attend a workshop like this and sharpen your skills.

Do you want to share a cool excel or charting related link ?

If so, drop a comment or send us the details at chandoo . d @ gmail. com. Emails from readers like you make me very happy.

Have a great week everyone 🙂

Hello Awesome...

My name is Chandoo. Thanks for dropping by. My mission is to make you awesome in Excel & your work. I live in Wellington, New Zealand. When I am not F9ing my formulas, I cycle, cook or play lego with my kids. Know more about me.

I hope you enjoyed this article. Visit Excel for Beginner or Advanced Excel pages to learn more or join my online video class to master Excel.

Thank you and see you around.