Google docs spreadsheet app is going mainstream with each passing day. Recently they have introduced split() formula to divide text in to multiple cells using a user specified delimiter. The syntax for this function is =split(text value, delimeter), for eg. =split(“pointy haired dilbert”, ” “) would result in 3 individual cells with “pointy”, “haired” and […]

The sky, the greenery and the instant rainbows at Niagara falls are mind blowing. We had great fun at the falls last weekend. I took several photos, here is one for you savor during the weekend.

Every week Pointy Haired Dilbert celebrates the art of chart making by sharing 5 of the most beautiful, innovative and effective infographic ideas from various sites. Click here to see the visualizations featured earlier. Pop, Soda or Coke? – Countywise terms used for sweetened carbonated water The pop-vs-soda map tells how marketers have been effective […]

Look at the power of conversation. A fan posted on youtube showing an apparent glitch in Tiger Woods 08 video game that you can walk on water to hit a golf ball. What did Electronic Arts and Tiger Woods do? They post a response to that video advertising Tiger Woods 09 saying that “its not […]

Here is a quick excel tip to make your charts look professional by showing symbols in the axis labels instead of text. Just follow these 4 simple steps: First identify the symbols you want to show on the axis or as data label from symbol fonts like webdings, wingdings or a custom dingbat font like […]

Creating KPI Dashboards in Microsoft Excel is a series of 6 posts by Robert. This 6 Part Tutorial on KPI 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 in the […]

This is hilarious or there is a color technology out there that requires to scan my finger print in order to show the “bunch o surfers” or some other design on my laptop skin. Really Dell? see it on the dell site, just select the color scheme as “bunch o surfers”