Use Microsoft® Excel Differently to Gain a Productive Edge
Issue - Jul 2009
Jenny (not her real name) inherited a spreadsheet from her predecessor. The spreadsheet contains details of job applicants who have come for interviews. One of the columns, "Remarks", contains 2 sets of details, one for "Comments" and the other, "Position applied for". The rest of the columns are merged to facilitate navigation around the spreadsheet. This causes a problem for Jenny. The way the data are captured (2 rows per record) prevent it from being used as a source for a pivot table.
Jenny wants to transfer "Position applied for" to a new column next to "Comments" so that each record will take up only one row. She would then remove the second row for each record.
It would have been easy to cut and paste the information if there are only a few records. But in the spreadsheet, there are over one thousand records! How much time do you think Jenny would take to do the conversion?
If she has mastered the techniques we teach, it will take only 5 minutes. Here's how:
If you've attended our courses before, you can login to the Members' Area and watch the whole process in action.
If you received this newsletter from a friend and would like to be included in our mailing list, please go to our Excel Today's page.
If you have a facebook account, you can like us at facebook or linkedln. From facebook or LinkedIn, you will be notified on mini cases and ideas how we use Excel on a day to day basis. These tips may not be published in our newsletter.
everydayExcel Business Lab Pte Ltd
Author of "Hidden Secrets of Data Analysis with Excel" and
"Excel Secrets for Highly Effective Marketers"
Received this newsletter from a friend? You can request to be included in our mailing list by signing up at our Excel Today's page. If you have friends whom you think might be interested in this newsletter, feel free to send it to them.