Excel Links of the Week – now even more downloads edition
Welcome to another edition of excel links.
During the last week, I have revised excel downloads page on PHD and now it contains over 75 excel templates, tutorial downloads. I am not sure if you dig the new format of the page though. So go take a look at it and let me know what you think.
Moving on to the excel links,
Breaking rules is fun. Junkcharts shows this very well designed chart and tells why despite breaking a few rules (values in alphabetical order instead of descending order, mirror imaged area fills leading to difficult comparison of growth) the chart succeeds in connecting with audience. I totally agree with “break few rules” point, you should experiment often to add variety and poke curiosity. After all, normal is boring.
Color plays a vital role in designing beautiful, inspiring charts. While the article on Smashing Magazine leans towards web design, most of these principles apply to chart design as well. So go ahead and pick up vital color skills and awesome-ify your next chart.
Andrewe shows us how to solve word puzzles using excel. Games excite me and Excel doubly so. The combination is too tempting to pass.
My friend Jon is deeply worried about 2 pie charts and he tells us that using Dot Plots can be a cure. I don’t disagree with him either. Read his post to avoid messing up your pie charts.
John Walkenbach is not content with excel bible. So went ahead and actually built small Excel app to read verses of bible. Download and play with it. (and if you are in to God, enjoy a verse or two)
Leave a Reply
|Fix Incorrect Percentages with this Paste-Special Trick||Data Validation using an Unsorted column with Duplicate Entries as a Source List|