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,
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.
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.
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.
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.
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
|5 Awesome Info-graphics for your Inspiration [Dec 19]||Excel 2007 Review – 10 things that WOWed me|