RSS

If you are Relian** telecommunications, and your customers are not happy with the bill they have been getting- I suggest check your ‘data sorting’ concepts in Excel.

09 Mar

Data Sorting in Excel

To  understand the importance of the point I just made in the title and in the picture in this post, remember that although we are not going to use the customer name as a way of sorting, if they are not included in the sort area they will be detached from the fields- Bill no. and Bill amount.

Detaching one or more fields in the sorting process is the only reason how, for example, Nikki, who used to give only miss calls recieved Jennie’s Bill of Rs. 20,000 [Jennie used to be on the phone 24*7]

Put simply, if your worksheet contains 8 fields and 20 records, say , and even if you intend sorting those records only on the basis of one of those fields-  all 20 records must be included in the range selected for sort.

So, pay a little more attention where you sort in Excel next time. This will make you customers happy 🙂

Happy learning 🙂

Advertisements
 
1 Comment

Posted by on March 9, 2011 in MS - Excel

 

One response to “If you are Relian** telecommunications, and your customers are not happy with the bill they have been getting- I suggest check your ‘data sorting’ concepts in Excel.

  1. shweta sharma

    March 10, 2011 at 11:25 am

    i wish relian** customers read it…

     

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s