Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

exchange rates

ResolvedVersion 2003

Jennie has attended:
Excel Intermediate course
Excel Advanced course

Exchange rates

Is it possible to link budget amounts in spreadsheets to a currency convertor to give an accurate and up to date figure in stirling as well as USD

RE: Exchange rates

Dear Jennie

Thank you for attending Excel Advanced course!! I hope you enjoyed the course and benefited from it.

I believe your question was answered when we covered the Web query during the Excel Advanced Course. Please let me know if you have started to apply that for your specific requirement and if it working for you.

If you need step by step instruction on how to do the Web Query then please let me know and I should be able to provide you with the instructions!!

I hope this has answered your query.

If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please post it as a new question and we should be able to provide you the solution for it!!

Kindest Regards


Rajeev Rawat
MOS Master Instructor 2000 and 2003
MCAS Master Instructor 2007

Tue 23 Dec 2008: Automatically marked as resolved.

Excel tip:

Shortcut keys to move between sheets

Instead of clicking on a sheet tab to view a sheet, use the following keyboard shortcuts to move between sheets in the same file:

Ctrl + Page Down - Switch to the next worksheet (to the right)

Ctrl + Page Up - Switch to the previous worksheet (to the left)

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.