Menu
Excel Links of The Week – Malmo Edition
excel links - 5 comments
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:
Making Your Random Numbers Unique
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
Prepare Your Data for Charting
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 🙂
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:
|
Leave a Reply
| « Skip Blank doesnt skip blank cells ?!? | Using Array Formulas in Excel – Find if a list has duplicate items » |
At Chandoo.org, I have one goal, "to make you awesome in Excel & Power BI". I started this website in 2007 and today it has 1,000+ articles and tutorials on data analysis, visualization, reporting and automation using Excel and Power BI. 
5 Responses to “Excel Links of The Week – Malmo Edition”
You should go visit Copenhagen which is quite near, just a small train-ride away. There are plenty of things to see in our fair capital. Architecture, both new and old, castles, museums, art, Christiania and plenty of bars and restaurants!
I don't know Malmö but I think the Turning Torso is a must-see!
I spent 4 days in Malmö in 2006. The city is not huge and it is quite relaxing. No matter where you look at you'll see the Turning Torso. on the last day we took a train to the very close Lund, a city worth seeing, very walkable. If you prefer the bustling, take Copenhagen instead.
On a clear day, take a train to Helsingborg (30 minutes) and visit the city center and a little further north, there is a nice little peninsula from which you can see big part of southern Sweden / northern Denmark shores.
@Peter: Sure, I actually visit Copenhagen few days a week on work purpose, but may be one weekend I will go there and roam a bit more. And turning torso is literally visible from any corner of the Malmo.
@Alfiler: Good suggestion. Few friends here suggested visiting Lund... I guess we will go there one of the weekends.
@Fabrice: I have a friend in Helsingborg, so I guess the visit is due anyway.
[...] back to India tomorrow, for a 2 week vacation, to spend time with Jo.[ Now she is here and I am here [...]