Close this search box.

Excel Links of the week – the Christmas edition

excel links - 4 comments

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.

Related articles:

Written by Chandoo
Tags: , , , , , , ,
Home: Chandoo.org Main Page
? Doubt: Ask an Excel Question

4 Responses to “Excel Links of the week – the Christmas edition”

  1. Tarun says:

    Hey do you sales earning post of previous month.

    Tell us how many visitors you got, how much you made, what improvement in rankings you made etc.

  2. Fabrice says:

    A genuine big "THANKS" to you for your time and effort to share great tips through PHD. Happy Xmas and long life to PHD... Ciao !

  3. Chandoo says:

    @Tarun: Welcome. I share some of the traffic details in best of month posts. Last month we had 150k page views with 60k visitors. Every month the number of visitors / pageviews has been growing. So is the RSS subscriber base. I cant divulge the sales / ad revenue data, but I can tell you this much : I am still working 9 to 5 to make a living. So this blog has a looong way to go before I can probably say I am making very good money doing this. But I am writing this because I enjoy learning and sharing about excel and related stuff.

    @Fabrice: Thank you so much and I wish you the same 🙂

Leave a Reply

« »