All articles with 'information' Tag

Custom Cell Formatting in Excel – Few Tips & Tricks

Published on Feb 25, 2008 in Charts and Graphs, Featured, hacks, Learn Excel

The other day I had to make an excel sheet for tracking all errors across one of the applications we are doing for our customer. The format was something like this, We wanted to use a consistent message id format [4 digits: 0001, 0002, … , 1000 etc.]. Now I do not want to type […]

Continue »

Auto tagging your old blog posts

Published on Jan 7, 2008 in Analytics, blogging, hacks, ideas, technology

As you all may know I have recently moved my blog from blogger to wordpress. Since I have started blogging way back in 2004 most of my posts were untagged. I have used blogger labels ever since they were introduced, still almost 400 of my posts were untagged. I had two options, Manually edit posts […]

Continue »

Say NO to Default Charts Forever!

Published on Mar 20, 2007 in Charts and Graphs, hacks, Learn Excel

or Excel Charting Hacks # 2Roughly 35-40% of my working time in office is spent with powerpoint. As one of my mentors said, powerpoint gives neither the power nor the point. Apart from writing truck loads of bullet points and using auto shapes, I also work alot with numbers and charts. Obviously I resort to […]

Continue »

Excel Charting Hacks #1

Published on Feb 15, 2007 in Charts and Graphs, hacks, Learn Excel

The other day I had to make some graphs about revenues and profits of a set of companies. While doing it I wanted to use bar chart with bars of profit and revenue overlapping. But when I mentioned the revenue as 3000 and profit as 1500, the graph would show up something like this. As […]

Continue »

Howto: Excel Based Mutual Fund Portfolio Tracker

Published on Nov 13, 2006 in Learn Excel, personal finance

Instead of searching for the NAVs of all my funds at MyIRIS or MutualFundsIndia, I have developed a small excel sheet which will fetch the values for me and displays the current portfolio value at the click of a button. Here I am trying to share the “HOWTO” of the same. Create an excel workbook […]

Continue »

Coimbatore Bus Mafia and Adventure Trip to Ooty

Published on Sep 29, 2006 in Random

Heard of black tickets? Well you must have somany times. After Aamir Khan glorified selling black tickets big way in Rangeela, Chennai’s private bus operators couldnt help but pick up a trick or two of the trade. So there I am, unaware of the UCBTM (Undergroud Coimbatore Bus Transportation Mafia) cancerously proliferating and thriving in […]

Continue »

Cameras: Most Popular vs. Most Clicked

Published on Sep 26, 2006 in Random

A couple of days I guess S.Anand has given this link to Flickr’s Top Digital cameras. The funda is simple. The site tells you what are Top camera models in Flickr based on the EXIF data available using some Flickr API. I was wondering if the same cameras are also most sought after by people. […]

Continue »

US Legal Firms, Infosys Employees and Online Advertising

Published on Sep 8, 2006 in Random

Today I ran a search in Del.icio.us for Infosys to get some information. What I saw in the results page is height of online anti-advertising. Generally you expect to see some ads related to the search tags. What you see here is on a different dimension altogether. When I clicked on the ad, it took […]

Continue »

3 Steps to Create cool dashboards in excel

Published on Sep 5, 2006 in Analytics, Learn Excel

Dashboards are very common business monitoring tools, but creating them in excel with all the bells and whistles is not so easy. So here is a quick 1-2-3 on how to do it. Lets take a sample of 2 consecutive year sales figures for 7 regions. The colums have Region name, 2004-05, 2005-06 figures and […]

Continue »

R1C1 – Excel Here Launched

Published on Sep 4, 2006 in Random

My love for excel doesnt stop at the application. I thought starting an excel specific blog to share my excel knowledge and discuss it with other enthusiasts is a good idea. So R1C1 was born a couple of days back. Today I posted an article on creating unique lists in Excel there. Do check it […]

Continue »

How to Get Unique Items using Excel

Published on Sep 4, 2006 in Analytics, Learn Excel

I recently had to perform some analysis on a set of insurance companies in certain geography. After searching the net I found such list of companies operating in that continent. But the problem is, These companies are listed multiple times, one time for each of their geographical area of operation. I cannot count each company […]

Continue »

Orbit Musings and other things

Published on Aug 3, 2006 in Random

>>> How come chennai doesnt have any English / Hindi FM channels? I think (correct me) all other metros have them. The only FM channel where you can hear something in Hindi is All India Radio’s FM Channel. >>> I am planning to buy a TV. My budget is 10k. The TV must be flat […]

Continue »

A bachelors guide to renting a house in Chennai

Published on Jul 27, 2006 in Random

All you hopeless and wifeless bachelors, get up and start looking. With PHD releasing “the unofficial bachelors guide to renting a house in Chennai” today, you will never again get a “no, we dont rent to criminals, politicians, drummers, dogs, carpenters and bachelors” reply from your prospective landlords. Where to look: Never call a housing […]

Continue »

Focus on Details = Satisfied Customers

Published on May 5, 2006 in Random

It is amazing how attention to smaller details can change the face of a service organization. There are several things that are done just the way they are since they were first done. Ok, thats a complex statement, for example, when you go to a website and it has some data/animation to load, all you […]

Continue »

How not to do advertising online?

Published on Feb 10, 2006 in advertising, ideas

The above seen is a snapshot of the interactive ad for Indage Chateau Wine sellers. It took me to this page when I clicked on it. What went wrong with this ad? In above page you can see that there is no way in hell I can find out where all this Indage Chateau is […]

Continue »