Excel Links of the week – the Christmas edition

It is the holiday week, that means less posts and more fun. We went to a friend’s wedding yesterday and had wonderful time. We are planning to celebrate Christmas at home with friends this year. How are you celebrating the holidays this year?

Off to this week’s excel links,

Editing Data Series references in Charts

Creating charts is probably the most time consuming tasks when it comes to using excel. Jon takes a look at editing data series formulas and provides a simple add-in that you can use if you make lot of charts on regular basis.

10 rules for good design

Garr at Presentation Zen lists ten simple rules for good design, even though he wrote it from presentation point of view, most of them are relevant for spreadsheet design. Take a look and implement one of them today in your report or chart.

Creating table of contents in your workbooks

Ever built a large work book with more than 5 sheets? It might be helpful to include a navigation sheet where you provide links to other sheets. Debra at Contextures blog shares few tips on making ToC for your workbooks.

Making beautiful charts using Adobe Illustrator

Even though excel is a very good tool for making charts often you may need a design quality software to make charts. Nathan at Flowingdata has posted a detailed tutorial discussing how to make charts using Adobe Illustrator.

Eight must have features for real time dashboards

Juice analytics lists down 8 features that dashboard makers should keep in mind while designing. Of course if you are stuck at building, do check our tutorials on excel based dashboards.

Happy holidays everyone 🙂

Hello Awesome...

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.