3 nuevos consejos para dominar excel

8/13/2019 3 Nuevos Consejos Para Dominar Excel

http://slidepdf.com/reader/full/3-nuevos-consejos-para-dominar-excel 1/8

3 nuevos consejos para dominar Excel

Mayo 2013

Imagine you’re a sales manager for a large retail chain in Europe. Suddenly, your finance

colleague has come down sick with the flu in the middle of the monthly sales reporting.

Your boss needs the hard numbers on her desk by tomorrow morning and your colleague

has left a mess of data for you to sort out. Looks like you’re going to have to skip dinner

plans with your friend tonight.

Or maybe not. Luckily, you remembered some Microsoft® Excel® tips that can help you

get the work done in no time. With a few smart tips for organising even the most out of

control spreadsheet, you can get this mess in order with less stress than you’d expect.

Here’s how:

Tip 1: Text to columns

Let´s say you want to create a list of the company’s stores, with the location and the daily

revenue. First, import a large dataset from your controlling software, which might looksomething like this:

Yikes, that’s a mess – but don’t panic. You do not have to go line by line and se parate the



dataset into separate columns. Those clever guys from Microsoft took care of it and enabled

Excel with a tool that will help you clean up this data with a few clicks.

Step 1. Select the column with the data.

Step 2. Go to “Data” ribbon and click the “Text to columns”. Step 3. Click “Delimited” and then “Next”.

Step 4. Choose the mark, which indicates the end of the columns (in our example we used a

comma, so click “Comma”), then “Finish”.

What you get as a result is a tidy looking table, ready for further editing:



Tip 2: Paste special: “Transpose”

Now it’s time to make the spreadsheet more readable for your boss.

In previous articles, we have described the magic possibilities of the “Paste special”

function, but that’s just the beginning. An additional tip to help you in this case would be

the “Transpose” function, which saves a lot of time and nerves for anyone who has ever

faced with a problem of converting columns into rows or vice versa.

Let’s say you’re still working with the same dataset. But now you want to have store

locations as the column titles and daily revenue as rows. Here’s how:

Step 1. First, select the cells you want to convert (in this example, choose all three columns

with the data) and copy it (Ctrl+C).

Step 2. Select the cell where you want to put your data and press the right mouse button.

Step 3. Choose the “Paste special” function in the list that showed up.

Step 4. Click “Transpose” and then “OK”.

http://h30458.www3.hp.com/ww/en/smb/1276160.html






additional possibilities in the sort function that can save you time – especially if you ever

need to reuse this custom sorting across multiple tables.

Step 1. Select the data (without the row with the headers) you want to sort.

Step 2. Go to the “Data” ribbon and click “Sort” function. Step 3. Click “Options” and then tick “Sort left to right”, then “OK”.

Step 4. Choose the row from which you want to sort the data.

Step 5. In the “Order” drop-down list, choose “Custom sort”.



Step 6. Type the new order you wish to use. Make sure that you separate each new value

with a comma. In our example, it will look like this:



Step 7. Click “OK”.

You’ll get the following as a result. As you can see, the main store is listed first, followed

by Munich and Frankfurt, and then all the rest.

Perfect timing, the spreadsheet is correct and you have just enough time to make dinner

with your friend. Your boss gives you a thankful wave as you head out the door, but you

know that all that hard work is due to a few easy tips from Excel.

3 nuevos consejos para dominar excel

Documents