Excel Links of The Week – Malmo Edition
Last Wednesday I flew from Chennai, India to Malmo, Sweden for some work. This is a beautiful town. I like that so many people are either walking or cycling instead of using cars. When I visited Dublin, Ireland few years back, I wanted to spend sometime in Europe. But I stayed there barely for a week. Now my assignment is fairly longer than that. So, I am hoping to explore Europe further. If you know somethings that I should do / visit / learn about Malmo, please share in comments…
Moving on to this week’s excel links:
When you are preparing a spreadsheet model (or game) that involves random numbers, often you may want to geenrate unique random numbers. Andrew’s provides us with a simple VBA solution to do this. While you are there, check out his excel concentration game too.
We, at PHD always recommend simplicity as rule when making charts. If you are still not convinced, this very good example shown on Junk Charts should help you realize the virtues of simplicity.
Play seems to be the focus of excel blogosphere last week. Debra at contextures has created an excel file to generate bingo cards (US style) in excel. Several others followed it up with their own versions of bing number generators. Follow the links, download the book and have some fun! Also, Generate UK / Indian style bingo cards
Jon shows us how to cook the data. (not cook up). He provides some interesting techniques and tips to massage the data before it is used to make charts.
Have a Suggestion or Tip?
Please share with me through comments or email at chandoo . d @ gmail . com. Have a great week ahead everyone
|Skip Blank doesnt skip blank cells ?!?||Using Array Formulas in Excel – Find if a list has duplicate items|