Archive for October, 2008

Introducing Spreadcheats – Become Supergood with Excel in 30 days

Published on Oct 31, 2008 in blogging, Learn Excel
Introducing Spreadcheats – Become Supergood with Excel in 30 days

Starting next week, PHD is going to feature a 30 post series on spreadcheats. The purpose of these posts is to make day to day spreadsheeting a breeze. Each post will be less than 200 words in size and aspires to make your day at office a little bit more productive. I have already identified […]

Continue »

Soon you can use Excel on the Web

Published on Oct 30, 2008 in technology
Soon you can use Excel on the Web

Yesterday Microsoft announced in PDC (professional developers conference) that it will be releasing a web based version office applications – Word, Excel, Power Point, One Note later this year. This is an exciting news since you can access the goodness of these powerful desktop apps inside a browser for free. No more hassles of upgrading […]

Continue »

Adding Box Plots to Show Data Distribution in Dashboards [Part 6 of 6]

Published on Oct 29, 2008 in Analytics, Charts and Graphs, Learn Excel
Adding Box Plots to Show Data Distribution in Dashboards [Part 6 of 6]

This is a Guest Post by Robert on Visualization Techniques for Excel KPI Dashboards. 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 in the […]

Continue »

Making Pie-charts look Sexy – The CNN’s tax burden analysis chart

Published on Oct 29, 2008 in Analytics, Charts and Graphs
Making Pie-charts look Sexy – The CNN’s tax burden analysis chart

There is always a debate about how good or evil pie charts are. While visualization purists believe pie charts should be avoided at all costs, newbies find creating and using pies very easy and often over do it. I have blogged few techniques involving pie chart visualizations like in-cell pie charts, speedometer charts, donut clocks […]

Continue »

How to NOT spend $ 150,000 and still dress up your charts

Published on Oct 28, 2008 in Charts and Graphs, Featured, Learn Excel
How to NOT spend $ 150,000 and still dress up your charts

By now everyone and their grandmother must have known about how Republican National Committee has spent $ 150,000 on Sarah Palin’s clothing and make up. I am a big fan of clothes. So much that I wear them everyday. But not all of us have a committee or fund raisers to dress up ourselves, none […]

Continue »

Excel Links of the Week – What the heck happened to photographic fridays edition

Published on Oct 27, 2008 in excel links
Excel Links of the Week – What the heck happened to photographic fridays edition

Remember the photographic fridays? Some of you must be thinking whatever happened those posts? Well, my intention for writing those posts has been to get your feedback so that few of us can become better photographers. But flickr does a hell of better job for this than my little blog can. So I have decided […]

Continue »

5 Beautiful Visualizations [Oct 24]

Published on Oct 25, 2008 in Cool Infographics & Data Visualizations
5 Beautiful Visualizations [Oct 24]

Every week, Pointy Haired Dilbert celebrates the art of chart making by sharing 4-5 of the most beautiful visualizations floated around the web in the last few days. Take a look at them and have some inspiration and fun 😀 Map of most popular social networks in each country This is a simple world map, […]

Continue »

Sports Statistics Dashboard in Excel – Few More Alternatives

Published on Oct 24, 2008 in Charts and Graphs, Learn Excel
Sports Statistics Dashboard in Excel – Few More Alternatives

First of all, thanks everyone for making the should you always start barcharts at zero? discussion lively. Almost everyone felt that we should start bar charts at zero. After spending sometime with my initial test cricket statistics dashboard, I have created few alternatives. You can see them below. But somehow I feel that I haven’t […]

Continue »

Sorting Text in Excel using Formulas

Published on Oct 22, 2008 in Analytics, Featured, Learn Excel
Sorting Text in Excel using Formulas

Sorting text is such a day to day activity that it always surprises me why Excel hasn’t provided a simple spreadsheet formula for doing it. Of course you can use the sorting menu command (menu > data > sort) but this requires manual steps (or VBA). Most of the times we get raw textual data […]

Continue »

Reader Poll: Should the axis for bar charts always start at zero?

Published on Oct 21, 2008 in Charts and Graphs, Featured, Learn Excel
Reader Poll: Should the axis for bar charts always start at zero?

It all began with my Excel Dashboard Tutorial – Making a dashboard with player statistics. I have used bar charts with axis whose minimum is not zero, to create a dramatic effect in the charts. See below: Jon Peltier commented saying that, Rule #1: Bar and column chart value axes should start at zero. Since […]

Continue »

Sports Dashboards in Excel – A Tutorial

Published on Oct 20, 2008 in Charts and Graphs, Learn Excel
Sports Dashboards in Excel – A Tutorial

One of my favorite cricket player, the GOD – Sachin Tendulkar has become highest test run scorer. What do I get if Sachin becomes highest scorer, you may ask. In order to celebrate this occasion I have created a cool sports dashboard in excel with some of the top test cricket players’ statistics. And, you […]

Continue »

Excel Links of the Week – Birthday Edition

Published on Oct 20, 2008 in excel links, personal

Today I am celebrating my 27th birthday. “not much left before thirty”, my wife playfully reminds me. “We still have 3 more years to go”, I said, thinking about all those things to do before I turn thirty list. All in all the year has been fantastic. We have moved to US for work reasons, […]

Continue »

Use Enter to Paste Copied Values in Excel [Quick Tip]

Published on Oct 17, 2008 in Learn Excel
Use Enter to Paste Copied Values in Excel [Quick Tip]

Here is a simple copy pasting tip. Next time when you want to paste a set of copied cells to another area, instead of using CTRL+V, just use ENTER. See this: Learn 16 more excel copy pasting tricks today.

Continue »

5 Superb Visualizations of the Week [Oct 17]

Published on Oct 17, 2008 in Cool Infographics & Data Visualizations
5 Superb Visualizations of the Week [Oct 17]

Animals in the Zoo – Creative Bar Chart This creative bar chart shows the distribution of various zoo inhabitants. The yellow strip is for birds, green bar is for amphibians, orange strip is for mammals and finally the curly green bar in the end is for, you guessed it right, reptiles. Also shown in the […]

Continue »

The New Poor – Internet Penetration Rates by Country

Published on Oct 16, 2008 in blogging, Charts and Graphs, Learn Excel
The New Poor – Internet Penetration Rates by Country

Yesterday is Blog Action day and tons of bloggers posted about single topic – poverty. It is a topic very close to my heart for various reasons. It is a very sad thing not to have food or shelter or healthy living conditions. But man has thrived in all those situations just because he learned […]

Continue »