Excel Links of the Week [Sep 29]
Time for sharing another round of excel related articles around the web.
List of all data visualization and analysis excel add-ins, The list includes some of the really useful add-ins. Handy bookmark if you work with data visualization alot and need to know where to find good stuff to add to your excel capabilities.
Designing a chart when you have lots of data, This is a common problem we all face. Often we have lots of data (in this case household income distribution data from 1967 to 2005) and we try to come up with *ONE* chart to show all of it along with our insights. This works in some rare cases, most of the time resulting in chart mess. Xlcubed has done some analysis of a simple problem and tries to propose an alternative.
Excel Chart Adviser by Microsoft Excel chart adviser is a free add-in to excel. Once added it would show up as button on your ribbon / toolbar UI and suggest charting alternatives for your data. Read what Scott Ruble, a program manager on the MS Excel team has to say about this.
Simple Check List with Excel – I used to maintain a spreadsheet with things to do during my MBA days. Especially when things are crazy bad I used have 10-20 undone items. These days I just don’t do that much (or am I doing stuff really fast ?) But you might find Andrew’s simple checklist using excel very useful.
That is all. Welcome to a brand new week of excel excitement. If you want to find more interesting excel links, browse our shared excel links archives. 🙂
My name is Chandoo. Thanks for dropping by. My mission is to make you awesome in Excel & your work. I live in Wellington, New Zealand. When I am not F9ing my formulas, I cycle, cook or play lego with my kids. Know more about me.
I hope you enjoyed this article. Visit Excel for Beginner or Advanced Excel pages to learn more or join my online video class to master Excel.
Thank you and see you around.
Leave a Reply
|« Sun Flower – Photographic Fridays # 15||How to WOW your customers with tracking – Dominos pizza example »|
4 Responses to “Excel Links of the Week [Sep 29]”
Thanks for the link Chandoo! There are some good links in this post.
One that sounds familiar is the Microsoft Chart Advisor. If you take a look at Juice's website (chart cleaner in my post) they have a web-based application called Chart Chooser that helps users determine which chart is best for their data set. They are very similar and can be a good guide for the novice data vis person.
@Tony .. you are welcome. 🙂 I have seen the Juice's chart selection site and I guess it is pretty useful.
Nice to meet you Chandoo.
Thanks for the mention of my checklist 🙂
@Andrew .. it is great experience to interact with people like you... 🙂