All articles in 'Learn Excel' Category

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 »

Replace Radar Charts with Tables to Make Comparison Easy

Published on Oct 7, 2008 in Charts and Graphs, hacks, ideas, Learn Excel
Replace Radar Charts with Tables to Make Comparison Easy

In Petal Charts – an Alternative to Radar Charts I have suggested using a radar chart tweak to replace the radar charts. Both PTSBlog and Information Ocean have posted their critical reviews of these petal charts. So as a penance for proposing petals, I am going to provide a tutorial on creating a comparison table […]

Continue »

Excel Links of the Week [Oct 06]

Published on Oct 6, 2008 in excel links

What a Monday it is. Most of the us woke up to find that whatever we have been accumulating for the last few years in investment gains has been wiped out (BSE Sensex at 2 year low, Dow slips below 10000). Not a very pleasant way to start the week, but then may be this […]

Continue »

Major Updates to Google Docs Spreadsheets App – Menus, Named Ranges, Toolbar

Published on Oct 6, 2008 in Learn Excel, technology

Google Docs – spreadsheet application has introduced some major upgrades to their editor today. Some of the key changes include: Introduction of menus to access all spreadsheet functions / features by category: Now the spreadsheet app menus look more like Excel 2003 menus. Looks like Google is trying hard to close gap between the two […]

Continue »