All articles in 'Learn Excel' Category

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 »

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 »

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 »

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 »

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 »

15 MS Excel Tips to Make you a Productivity Guru

Published on Oct 16, 2008 in Featured, Learn Excel

We all like to customize things, to personalize them so that we feel better, faster and smarter using them. Microsoft Excel is a perfect example of highly customizable software. It is simple to learn and use, and at the same time it is relatively easy to change the way it works for you. Here is […]

Continue »

More than 3 Conditional Formats in Excel

Published on Oct 14, 2008 in Charts and Graphs, Learn Excel
More than 3 Conditional Formats in Excel

One of the most popular posts on this blog is how to become excel conditional formatting rock star. Quite a few commenters there asked me if there is a way to get more than 3 (or 4) conditional formats in excel 2003. Like what you see below: You can get more than three conditional formats […]

Continue »

Excel Links of the Week – The Mt. Rainier edition

Published on Oct 13, 2008 in excel links
Excel Links of the Week – The Mt. Rainier edition

We drove down to one of the Washington’s best attractions. The Mt. Rainier National Park. It is one of the best natural attractions I have ever seen. The mountain, the greenery and the drive are totally awesome. The mountain looked breathtakingly beautiful and the whole park looked awesome with fall colors. Do visit Mt. Rainier […]

Continue »

KPI Dashboards – Compare 2 Decision Parameters [Part 5 of 6]

Published on Oct 9, 2008 in Analytics, Charts and Graphs, Learn Excel
KPI Dashboards – Compare 2 Decision Parameters [Part 5 of 6]

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

Continue »