Excel Links – What are your plans for 2010 Edition
So we are in 2010, dawn of a new decade. In fact everyday is a start of new decade, as my friend Jon reflects on twitter. So what are your plans for this year and decade?
As for me, I haven’t really jotted down any new year resolutions. So I am using this post as a public-new-year-resolutions-of-pointy-haired-dilbert.
- Run 20k: I have a dangerous record for stamina. Even though I have been running for 2 years now, I never crossed the 15 k mark. In fact last year I ran 10k several times, but I just don’t have the stamina to push past 15k and reach the 20. So this year, I am hoping to push my self to do that.
- Release online excel training program: I have been planning and jotting down ideas for last 6 months, but never really got around to doing it. I think its time I did this. I want to release an online excel training program this year. It will be a 6 week program and focus on key excel skills to make you a star at your day job. If you have some ideas on topics to cover, delivery mechanism or general suggestions, please tell me using comments or writing to me on my email – chandoo.d @ gmail.com
- Travel less: Since I got married in 2007, I have been traveling a lot. Last year alone I have worked in 3 countries and spent 6 months away from my family. This is just futile. I am hoping to not go anywhere in this year. I just want to stay in one place be with Jo and the kids.
- Do what I enjoy, more: that is writing this blog, connecting with awesome readers like you, staying in touch with my close friends, being there when one of the people in my life need me.
What about you? what plans do you have for this year? I am *really* interested to know what keeps you going. Please share.
Ok, on to this week’s excel links.
?My friend Jon takes up the task of teaching us how to write an excel add-in. These posts may not make sense to those of you just starting with excel. But for those of you with some VBA knowledge, this series is a gold mine of information and insight. In the above post, Jon tells us how to write module functions in VBA by showing an example function that can clean up excel charts. I am following these posts so that one day I can build the GET ME A DONUT excel add-in
DDoE shows us how to make a simple “hello world” button on Excel Ribbons using XML. This post is in the same league as above Jon’s post. But very useful if you are ever planning to make your own add-ins or custom spreadsheet solutions.
Excel king, which is a new blog on excel and charting shares in interesting tip on editing multiple sheets. If you have several worksheets with same formatting (like Monthly sales sheets etc.) you can select all the sheets and make changes in one and excel automatically applies the changes to others. Very useful.
Ajay at Databison releases an excel tree map add-in. Using this you can make an instant tree map with your excel data. Treemaps “display hierarchical (tree-structured) data as a set of nested rectangles. Each branch of the tree is given a rectangle, which is then tiled with smaller rectangles representing sub-branches [more on wikipedia]“. Ajay is selling the add-in for $15, which I feel is a bargain. If you have plans to make treemaps with your data, save yourself few hours of time and get a copy of the tree map add in.
[disclosure: Ajay sent me a copy of the add-in so that I can review it. I also make some commission when you get a copy of this]
In this beautiful visualization, NY Times shows us what is popular on NetFlix Rentals. I am a big fan of NYT visualizations. They teach so many good lessons on making better charts and this one is no exception. It is interactive, provides ability to switch dimensions, lets you analyze the data and best of all of all it is an ego chart. (Ego chart is a chart with some component that everyone can connect to. For eg. a chart showing ideal BMI by Age is an ego chart because almost everyone gets curious to know what their ideal BMI is when they look at this chart)
That is all for this week’s links. You have a fun week ahead. I will see you tomorrow with an excel tip that will make you a star at work.
|What is PowerPivot? (and does it really wear underwear on top of pants !?!)||Collapse, Expand Excel Charts using this hidden trick|