Improve productivity by opening same excel sheet in 2 windows – quick tip
Often we work with large data sheets and it becomes tedious if you want to compare data / formulas etc. You can try split (menu > window > split or alt+w+s) to break the sheet in to two. But there is another cool thing you can do, open a new window for the spreadsheet. Just […]
Inspiring
Here is an inspirational read on Richard Feynman. Have you ever noticed that almost all the great people are humble and fun loving. It just amazes me whenever I read or know about these great people who solved world problems with a smile on their face and yet remained so down to earth.
Brooklyn Bridge in the night
During our recent visit to NY I have been to the famous Brooklyn Bridge and I clicked photos till my fingers itched. Here are some of them, let me know if you have any review comments 🙂 I couldnt carry my tripod though, some of the pics became real blurry at original resolution.
How to add a range of cells in excel – concat()
Excel concatenate() is seriously crippled, it can add 2 or more strings together, as long as they are supplied as separate parameters. This means, when you have a range of cells with text which you want to add up to create a large text, you need to write an ugly looking biggish concatenate() or use […]
Road Rage on Memorial weekend
We are going to big apple on this weekend, its going to be a really long drive, almost 1000 miles both ways put together, I will see if I can post something while resting, but don’t hope to see anything here for the next 3 days. You have an excellent weekend, drive carefully – more […]
Get crazy CNN headlines on your t-shirt
Rat rides cat, cat rides dog, that rides on your t-shirt I am just numbed seeing this outrageous hilarity in the name of news making and selling on CNN, apparently you can buy t-shirts for some of the hand picked news items on CNN by clicking the t-shirt icon next to headline link on their […]
Welcome to Pointy Haired Dilbert – Chandoo.org
It has been a while since I wrote a welcome post to my readers, so here again. Pointy Haired Dilbert – Chandoo.org is a blog about technology, business, data analytics, excel, photography, advertising and my life. I am Chandoo, an excellent donut eater, coffee drinker extraordinaire, blogger beyond reform, crappy coder, lousy manager, happy husband, […]