Web Site

Resolved · Low Priority · Version 2016

Tue 11 Jul 2017, 16:20 Delegate Lloyd said...

Lloyd has attended:
Excel PowerPivot course

Web Site

I do a lot of exchange rate work, which wen site would be good to link monthly spot rates against instead of me having to code these in each month.

Thu 13 Jul 2017, 10:42 Trainer Jens said...

RE: Web Site

Hi Lloyd,

Thank you for the forum question and also the nice feedback. I am happy that you found the course useful.

If I was you I would try to link Excel to your normal source, but the data must be organised in a table on the website. If it is not possible I found the link below I have tested and it is working fine.

https://www.gov.uk/government/uploads/system/uploads/attachment_data/file/621902/exrates-monthly-0717.csv/preview

Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Thu 20 Jul 2017: Automatically marked as resolved.

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Excel tip:

Using an equal (=) sign that isn't part of a formula

Before you type the equal sign, type an apostrophe: '
Then type your equal sign: = (and anything else you want to add after your equal sign)
Press ENTER.

(the apostraphe will disappear

View all Excel hints and tips