Excel Links – Learn Excel Online Edition
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.
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.
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
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.
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.
|Format Charts Faster in Excel 2007 [quick tips]||Group Smaller Slices in Pie Charts to Improve Readability|