Archive for August, 2008

Photographic Fridays #11 – It stretches all the way you can see

Published on Aug 29, 2008 in america, photographic fridays, travels
Photographic Fridays #11 – It stretches all the way you can see

Took this near Niagara falls, NY. The falls are divided between US and Canada. You need a Canadian visa (US visa) if you want to see the water falls from both sides. Of course, water doesn’t need a passport to flow. Browse other.

Continue »

Cool Visualizations of the Week [Aug 29]

Cool Visualizations of the Week [Aug 29]

Once every week Pointy Haired Dilbert celebrates the art of chart making by sharing 4-5 of the best info-graphics featured in various web sites. Click here to see the charts featured earlier. How to does Love, Anger, Joy and other emotions look like? Have you ever wondered how your emotions look like? That is exactly […]

Continue »

Aligning charts, objects on spreadsheet [excel layout tip]

Published on Aug 28, 2008 in Learn Excel

Often when you are adding several charts to your report or project plan, it may be important to have them all aligned to a proper baseline – a fundamental design principle. Take a look at this: But if you try to select each chart individually and adjust the alignment, it may not provide correct results […]

Continue »

What they dont teach you in any school – Appreciation

Published on Aug 28, 2008 in business, ideas

Back when I was doing MBA, one of the first courses we took was called MOC (Managerial Oral Communication). The idea of the course is simple. Each of the 60 students in class would give a 12 minute presentation on any topic of their choice to everyone. Then everyone has 8 minutes to provide suggestions, […]

Continue »

Creating KPI Dashboards in Microsoft Excel [Part 2 or 6] – Adding One Click Sort

Published on Aug 27, 2008 in Analytics, Charts and Graphs, Featured, Learn Excel

Creating KPI Dashboards in Microsoft Excel is a series of 6 posts by Robert from Munich, Germany. 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 […]

Continue »

Excel links of the week – weekend without wire [Aug 26]

Published on Aug 26, 2008 in excel links, ideas, Learn Excel

Last Saturday our internet connection at home went off. I called the road runner folks hoping to getting it back up, but no luck. We were told to wait till Monday evening before the service personnel could restore the connectivity. Thankfully, we didnt feel all that bored and could spend lot of time talking to […]

Continue »

Date with my sheet – 10 tips on using date / time in excel

Published on Aug 26, 2008 in ideas, Learn Excel

Excel date time features are very handy and knowing them a little in depth can help you save a ton of time in your day to day spreadsheet chores. Let us prepare for your date with the sheet using these 10 handy tips. Before jumping on to the tips, it helps to know how excel […]

Continue »

Quickly process text using split() spreadsheet function in google docs

Published on Aug 25, 2008 in Analytics, Learn Excel, technology

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

Continue »

Photographic Fridays #10 – At the Niagara Falls

Published on Aug 22, 2008 in photographic fridays
Photographic Fridays #10 – At the Niagara Falls

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.

Continue »

5 wonderful visualizations you must see [Aug 22]

5 wonderful visualizations you must see [Aug 22]

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

Continue »

Tiger Woods walks on water to please a fan – Awesome advertising

Published on Aug 21, 2008 in advertising, Humor, ideas

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

Continue »

Display symbols in excel chart axis

Published on Aug 21, 2008 in Charts and Graphs, hacks, ideas, Learn Excel

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

Continue »

Creating KPI Dashboards in Microsoft Excel [Part 1 of 6]

Published on Aug 20, 2008 in All Time Hits, Charts and Graphs, Featured, Learn Excel
Creating KPI Dashboards in Microsoft Excel [Part 1 of 6]

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

Continue »

Dell tells me to buy a finger print reader in order to have another color on the system

Published on Aug 20, 2008 in business, wonder why
Dell tells me to buy a finger print reader in order to have another color on the system

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”

Continue »

It is show time baby! – better designer clocks to display time in your spreadsheets

Published on Aug 19, 2008 in Charts and Graphs, ideas, Learn Excel

My polar clock using donut charts in excel started a conversation and readers have been awesome enough to download the excel and create their own clocks to show time. Even though the idea of this blog is share the little that I know with you, it is amazing how much I have learned from you […]

Continue »