Donations made to Presidential Candidates – US Elections 2008 What would you get when you take 1.4 million rows of presidential election donations made to Obama’s and McCain’s campaigns? One possibility is the above visualization. The folks at Pitch Interactive created the above visualization. The half pies in the middle represent the overall donations made […]

By integrating services like Google Finance, Search in to spreadsheet functions, google docs has paved the way for endless possibilities. Google spreadsheet function GoogleFinance() can be used to build stock portfolio tracker sheet that can fetch historical stock quotes to tell how your money is doing. Click here to see the stock portfolio tracker sheet […]

This is 4th part of Creating Management Dashboards in Microsoft Excel 6 post series by Robert. This 6 Part Tutorial on Management Dashboards Teaches YOU: Creating a Scrollable List View in Dashboard Add Ability to Sort on Any KPI to the Dashboard Highlight KPIs Based on Percentile Add Microcharts to KPI Dashboards Compare 2 KPIs […]

Gauges are a familiar metaphor, everyone can understand them, you can see them everywhere – near your stove, ac, car, gaming console, pc – you name it. So, when you are preparing a chart to tell a point, gauge chart like the one above can be effective. (I know charting pros like Jon Peltier wouldn’t […]

Every week Pointy Haired Dilbert features some of the excel links from around the web here. Get the archives here. Teaching physics using excel My friend Jon @ PTS Blog tries a different approach to teach physics to his daughter. Who says excel is only for corporates? Daily dose of Excel compiles the ultimate list […]

Often when you are processing text using excel it is important to split the text in to multiple parts based on a delimiter. For eg. you may want to divide this|needs|to|be|split in to five parts this needs to be split. There is a simple way to do this in excel, using “import text” option. But […]

Took this in a bar, rotated the photo in a image editor. Btw, what do you like to drink? For me Vodka if I want to get drunk, otherwise a good chilled beer. Happy weekend?