Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel training class - Currencies

excel training class - Currencies

ResolvedVersion Standard

Mon 28 Jan 2008, 09:42 Delegate Clinton said...

Clinton has attended:
Excel Intermediate course

Currencies

How do I use different currencies on one s/s?

Fri 1 Feb 2008, 11:43 Trainer Mark said...

RE: currencies

Hi Clinton

to use different currencies in one spreadsheet is quiet straight forward really for starters you will need to know where you need to use these.

Then select the cells you need to use a specific currencies the you need to go to the format menu then click on cells, from there choose the number tab from the top of the window, choose currency on the left after that click on the drop list for symbol choose the one you want then click on OK.

For other formats that you need all you need to do is repeat the process as above

hope this helps you out

Mark East

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Filtering Data in an Excel 2010 Worksheet

When you have an Excel Worksheet with masses of data, it's not going to be easy to sift through it. So, in order to view sections of data, you can use the filter tool. Select the cells you want to filter (no need to select the column headers), then click the Home tab on the Ribbon, click Sort and Filter (you will find this in the Editing Section) then click Filter.

You will now see arrows in the top row of all the columns. If you click on an arrow, it will give you some filtering options so you can sort your data into ''Smallest to Largest'' or ''Oldest to Newest'' and so on..

To turn off the filtering, go back to the Home tab and click the Filter button again.

View all Excel hints and tips

excel training class - Currencies

Currencies

RE: currencies

Excel articles

Excel tip:

Filtering Data in an Excel 2010 Worksheet