Sorting Text in Excel using Formulas

on 22 Oct, 2008 in Analytics, Excel Tips, Featured | 13 Comments

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

Read More >>

Sports Dashboards in Excel - A Tutorial

on 20 Oct, 2008 in Excel Tips, visualization | 6 Comments

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

Read More >>

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

on 17 Oct, 2008 in Excel Tips | 7 Comments

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.

Read More >>

15 MS Excel Tips to Make you a Productivity Guru

on 16 Oct, 2008 in Excel Tips, Featured | 13 Comments

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

Read More >>

More than 3 Conditional Formats in Excel

on 14 Oct, 2008 in Excel Tips, visualization | 5 Comments

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

Read More >>

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

on 2 Oct, 2008 in Excel Tips | 4 Comments

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

Read More >>

Simple Todo List application using Excel - Download and become productive

on 1 Oct, 2008 in Excel Tips | 1 Comment

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

Read More >>
Page 3 of 7«12[3]456»...Last »