Excel Links – Project Management Edition

It has been quite a while since we had an excel links post. It doesn’t mean that I am not reading anything new on excel or charting. I have been reading lots of awesome articles and useful content and sharing it on my google reader recommendation list. But it is just that I have been a little lazy and pushed this regular feature to background for a while. Anyhow, I have a new edition of Excel Links for you.

Go ahead and enjoy the juicy, awesome, useful content and comeback to PHD tomorrow for another another tip that will one-up your excel mastery.

Project Management using Excel [New @ PHD]

We have quite a few articles, templates and downloads related to the topic of “project management”. So I took all this useful content and structured neatly in the newly created “Project Management using Excel” section of PHD. You can find various PM templates, tips, best practices and more information in this page. Check it out.

YuMMMMMy Custom Format Code for One Letter Months

Mike Alexandar tells us about a hidden customer format code for showing months as J, F, M, A, M … N, D. It is MMMMM (that is right, 2 and half M&Ms). It is quite a delicious tip and will not lead to heart attack like his bacon recipes.

Automatic Table of Contents in Excel with a Macro

Whenever you have a large workbook with a ton of sheets, you would like to have a TOC sheet set up with links to other sheets. But the process of creating TOC sheet is much like understanding a 3D Pie chart – painful and time consuming. There is a simpler option though. XL Dennis wrote a guest post on MSDN blog about a little macro that automates the process of creating Table of Contents from a workbook.

Right brain or left brain – which one is your chart addressing?

Juice Analytics presents its case for creating charts that appeal to both left brain (numbers and facts, Tufte-like) and right brain (illustrations and images). I couldn’t agree more with them. I firmly believe that charts tell stories. And in order for a story to be memorable and actionable, we need to use creativity and follow info-graphic principles. (also see Robert’s commentary on same topic.)

Create Pivot Tables from Data in Multiple Sheets

Debra shows how to create pivot tables from multiple ranges in Excel. While most of us use a single range to create pivot tables, sometimes we have data across multiple spreadsheets that need to be consolidated and this technique can help us do that.

What is new in Excel 2010?

Here is the official word on what is new in Excel 2010, from Microsoft’s TechNet. Looks like Excel 2010 has packed lots of small and big changes.

Share a link with our readers:

If you want to share a link to an interesting excel article or resource with our readers, pls. drop a comment or send me an email (chandoo.d @ gmail.com). I will consider your recommendations for the next post.