Forum home » Delegate support and help forum » Microsoft Excel Training and help » Web Site

Web Site

ResolvedVersion 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.6 % recommend us

More live stats...

Training information:

Excel tip:

Sorting List Subtotals

If you find that you would prefer to show the items in a subtotalled list in a different order, eg ascending rather than descending, you can sort your list. To sort a subtotalled list, hide the detail rows and then sort the subtotal rows. When you sort a subtotalled list, the hidden detail rows are automatically moved with the subtotal rows.
IMPORTANT: If you do not hide the details rows before sorting a subtotalled list, your subtotals will be removed and all of the rows in your list will be reordered.

View all Excel hints and tips

Web Site

Web Site

RE: Web Site

Excel articles

Excel tip:

Sorting List Subtotals