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

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 get [...]

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.

15 MS Excel Tips to Make you a Productivity Guru

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

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 in [...]

Display decimals only when the number is less than 1 [Excel number formatting tip]

Here is a quick excel number formatting tip. If you ever want to format numbers in such a way that it shows decimal values only if the number is less than 1 you can use conditional custom cell formatting (do not confuse with conditional formatting).
Here is an example:

In such cases you can use conditions in [...]

Simple Todo List application using Excel - Download and become productive

After seeing Andrew’s simple excel based check-list I got this idea of preparing a simple To-Do list application using excel.
Since most of us use Excel on day to day basis, why not use it as a productivity application as well by keeping track of all the things we must do (TO DO List). When [...]