Recently I have conducted a survey on my blog to find out your pulse on PHD. Quite a few survey respondents have told me that PHD needs a topic-wise archive so that you can learn excel easily. So over the weekend I have prepared a webpage where you can find topic-wise posts on excel and charting. Go check out the Learn Excel Online page. It has links to posts on 100+ excel topics. The topics are sorted alphabetically. Take a look and tell me what you think.
Coming to this week’s excel links, we have quite a collection on VBA.
Highly Recommended: Watch Hans Rosling’s Chart Magic in TED India
Watching TED talks is like having a hot cup of coffee, only without side-effects, but all the energy boost. In this memorable talk, Hans Rosling shows us the future of Asia using Charts. There is so much to learn from Hans, in this presentation alone, you can pick up a handful tips on presentation styles, usage of color, usage of charts and being passionate.
Getting Started with VBA? – Free online lessons
Peter Leclerc’s excel-vba.com has tons of resources on learning VBA. There are 33 free online lessons on VBA, starting with using the VBE (that is visual basic editor) to working with form controls. Give it a try
Introduction to VBA – How to get started?
Debra at Contextures gives us this useful article on “introduction to VBA”. She shows us how to use the macro recorder facility to automate a task.
Datapig Mike teaches us a nifty VBA hack that can be used to show a zoom box (a bigger text box so that you can write multi-line text in excel cells) when user presses a short-cut. Pretty innovative, Mike.
How to chart when one data point is too large
Alex’s Data Driven Consulting blog shows us few charting techniques to use when one of the data points is too large. I like the one where the column is piercing through the chart’s roof.
Do you want to share a link with our community?
Please drop me an e-mail or tip me on twitter @r1c1 to share your links. I will include them in next edition of “excel links” if the links are interesting.
