Excel Links – Change in Posting Schedule Edition
Ok, this is bound to happen. After regularly writing for about 2 years now, I have decided to revise posting schedule on Chandoo.org. Usually I write 5 posts per week (about 21-22 per month). While I have not ran out of ideas yet (my notebook still has 94 different ideas yet to become posts), I am running out of time. So, going forward, I will be writing 3-4 times per week on Chandoo.org (usually on Monday, Wednesday and Friday). I know this might come as a surprise to the regular readers, but please note that this no way will lead to reduced post quality or awesomeness. It is just that I want to spend a little more time learning new things (Tableau, Protovis, Access, VBA come to mind) and work on some more exciting projects (new products, online courses etc.).
What is your say on new posting frequency at chandoo.org?
Are you worried about reduction in number of posts? Or, are you at relief knowing about one less email per week? Do let me know what you think thru comments.
Here is a list of Excel related links for this week:
Here is a primer on Importing Text files in to excel, a very detailed step by step tutorial exploring various settings and behaviors of text file imports. From MSDN blogs.
Juice Analytics is one of my favorite place to pick up new stuff and ideas on chart design and presentation. In this new article, they show us how to remake a set of charts to bring the messages out. Very useful advice for chart makers, designers and presenters all around.
Robert shows us the virtues of combining data and charts in dashboard tables. This is a very powerful and useful technique that I usually employ in my dashboards. While we all agree that charts are much more easier to read and can bring patterns out quickly, having raw data appeals to manager / decision makers urge to know the numbers. Plus numbers are comparable immediately.
Junk Charts shows a charting tool loved by statisticians – Scatter Plot Matrix. Think of it like a panel chart showing correlations between variables. Since the correlation scatter plot for x versus y and y versus x are same, the scatter plot matrix is actually a triangle instead of square. Check out the post on Junk Charts to find-out more about this technique.
Dick Kusleika has taken inspiration the much loved random data generator add-in from JP and created a random data generator of his own. Very useful if you are in to excel based development (or development at all) and looking for test data constantly.
Write for Chandoo.org:
Do you have an exciting idea or cool implementation of excel trickery and want to share it with our readers? Email me with what you have in mind.
Leave a Reply
|Office 2010 Contest Winners are here!!!||Range Lookup in Excel [Formulas]|