exchange rates

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Exchange rates

Exchange rates

resolvedResolved · Low Priority · Version 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:

DATEDIF function

The DATEDIF function is a worksheet function that computes the difference between two dates. This function is documented only in the help files for Excel 2000. It isn't documented in Excel 2002.
the formula function is:
=DATEDIF(Your age,Today(),"Y")
Y stands for year

View all Excel hints and tips


Server loaded in 0.1 secs.