All articles with 'technology' Tag

Imagine you have long list of data and you need to quickly identify which of the items are unique. You can use Advanced Filters to do this. Just select the list of items you want to filter, go to menu > Data > Filter > Advanced filter. You will see a dialog box like this: […]

Reader Nikhil Shah asks in an email: Dear Chandoo, I have some Error In Excel sheet. Problem :- I have a locker number 01234 567890, in Excel it will be displayed as 01234 567890 with the space. However if it was entered as 01234567890, Excel will display it as 1234567890, without the leading zero. If […]

Now that iPhone is going to have GPS built in, here is an application idea any of you iPhone app developers out there. The idea is simple, whenever the phone-holder is driving, this app would automatically answer calls with a pre-recorded message (that can go like, “Hi.., I am driving right now, please leave a […]

Excel has various functions, including functions to calculate inverse cosine of a given value, to multiply 2 matrices, to estimate the internal rate of return. But, most of us(well, just me then..) use just about 5-6 formulas to do our jobs. And IF formulas are a majority of these, so it doesn’t harm to learn […]

This is cool, apparently Google resorted to this to beat the leading Russian search provider Yandex. I am not sure whether this would be effective though. Its like forcing people to break a habit. This, probably is the most challenging task for marketers all over the world. When customers are used to Yandex or Naver […]

While trying to understand how the Mozilla firefox search plug-ins work [ more ] I got curious and wrote a search plug-in that will take you to the first Google search result directly instead of displaying the results pages, ie mimicking the “I am feeling lucky” searches. Feel free to download and install it. 1. […]

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 […]

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 […]

One of the most frequent tasks for any manager is “planning”, be it putting together a hiring schedule or designing a jumbo jet, it all starts with a simple project plan and gantt chart is simple and intuitive representation of the same. But how to make a gantt chart in excel without writing too many […]

Ever since writing the create in-cell pie charts in excel, I have been itching to find a simple enough method to do incell bar graphs. An in-cell bar would probably be more useful and cuter than an in-cell pie as it can instantly provide trending details. What more, these would probably look gorgeous when printed […]

Here is a ridiculously easy trick to do nice incell pie charts in excel, what more, they will make you look like a charting wizard. Download free pie chart font from here (direct download link). The font has 21 pie chart codes starting with empty circle (character ‘a’) and ending with full circle (character ‘u’) […]

Like this? Feel free to share / copy / exploit / save the cartoon. See other powerpoint cartoons as well

After seeing DI’s Open Your Favorite Websites Directly from Windows Vista Start post, I thought why not use Windows XP Run dialog box as a search box. So here is a simple trick that can enable you to open your favorite sites directly from XP’s run dialog box. Using this trick you can type “g […]

Gone are the days when software jobs are called ‘coder’ or ‘programmer’, as sophistication increased companies started calling the same coder as ‘software engineer’ or ‘programmer analyst’, then there were ‘sr. evangelists’, ‘associates’ and ‘server gurus’, but in the new era where demand is outstripping supply, naming a job creatively is as important as the […]

I think this is brilliantly done, despite being a mac owner and lover, the ad just looked perfect without sounding arrogant or stupid. Good work Lenevo 🙂