Ok, here is a brand new excel blog in the town, from Mike Alexandar, a Microsoft Excel MVP. The blog is called bacon bits. Wonder what bacon has got to do with spreadsheets, well, you will do well to know that his company is called datapig technologies. Mike has written some really cool excel books like Excel 2007 Dashboards & Reports For Dummies
, Excel 2007 VBA Programmer’s Reference
and Microsoft Excel and Access Integration
. The blog looks promising with very cool excel and vba tricks. Add it to your reader or daily stop list and I am sure you will agree with me.
Let us talk about the excel links I have come across recently.
Using XY Charts to draw state maps
Dick Kusleika provides a neat technique for creating US State Maps using XY Charts. Using XY Charts for maps is somewhat cumbersome. I have stopped trying that route after crashing excel fewtimes. Instead, I use Tushar’s method of shapes to construct maps. You can learn more about that here
Generating TinyURLs using Excel
Jimmy provides a simple VBA macro that can generate tinyurls from any given URL. This can be handy if you are planning use run a twitter campaign from excel sheet.
This is a classic Stephen Few article where he disapproves 2 inforgraphic visualizations and highlights all the mistakes in them. He asks “Is this the best infographics has to offer?” I echo with his opinions. That is one reason why I have stopped posting the cool infographics of the week series.
Help Jorge finish his data visualization e-book
If you have sometime, head over to Jorge’s Junk Charts blog and help him write his e-book on 101 Data Visualization Questions You Were Afraid to Ask. You can win a free copy if your question is selected.
How to design a filter for your dashboards / reports
Juice analytics highlights five features of effective filters. This is a very good lesson if you design dashboards and complex TPS reports where filtering is necessary. I thin the aspects of Selections and Impact are very relevant when designing spreadsheet based filters.
Do you want to share a useful excel or charting related link?
Send me an e-mail or drop a comment. I like to learn and share new stuff about excel, spreadsheets and charting. More so, I like to read emails from *you*. So go ahead…
7 Responses to “Excel Links – Bacon bits are good edition”
Thanks for the link, Chandoo. Let me just say that I'll have 101 free copies and I'm taking the readers' questions until June 30. The e-book will be available after the Summer.
Thanks for mentioning the blog Chandoo. I would say the check is in the mail, but everyone knows I'm a cheap bastard.
Thanks for mentioning my post. My site is acting up (I think it's WP 2.8) but if you go to the home page for the blog, you can read the full post there.
@Jorge.. you are welcome.
@Mike.. Ouch.. that hurts, I was actually starting at the post box every other minute...
@JP... I am tired of WP upgrading their versions so rapidly.. I guess I will skip 2.8 and 2.9 and upgrade to 3 when it is ready...
The link works now. Turns out it was my fault, not WP. Although the new "codebox" feature in the post editor is a bit annoying (thankfully you can turn it off).
Thanks for the heads up on bacon bits.. I've learned a bunch of stuff from the DataPig website so I'm sure that this will be educational as well.
Hi
Have large number of spreadsheets that link to a weekly and also an annual summary. After many years these spreadsheets are getting very large and ugly.
Is there any way to replace linked data with the actual data set as a value. If there is it means that I could archive off ancient parts of these spreadsheets and work only with say the current year.
Looking forward to hearing