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