excel courses - Excel

The UK's most regular instructor-led training courses.
Training information: excel courses · Microsoft excel training · Microsoft Excel Training UK
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version Standard

Excel

Himani has attended:
Excel Introduction course

by - delegate Himani [1 post] (2007 Jul 2 Mon, 13:50) Reply

How do I link Reuters 3000 to a spreadsheet to obtain live rates?

Version	Date	Location	Places available	Book	Next place rate:
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Oct 15 Wed	Bloomsbury	0	FULL
2003	2008 Oct 15 Wed	Bloomsbury	0	FULL
2007	2008 Oct 15 Wed	Bloomsbury	0	FULL
2003	2008 Oct 17 Fri	Southwark	4	book now	£224	£235
2003	2008 Oct 22 Wed	Southwark	5	book now	£219	£235
2003	2008 Oct 22 Wed	Bayswater	5	book now	£195	£205
Full Schedule: See all 114 Excel Advanced course dates. Bookings currently available until 24th November 2009.

RE: Excel

by - trainer Amanda diamond contributer [1091 posts] (2007 Jul 5 Thu, 15:54) Reply

Hi Himani

Thank you for your question.

I'm not familiar with Reuters 3000, but if this is a web based service, you should be able to use Data - Import External Data - New Web Query then navigate to the web page and select the table showing the rates. Then click OK. At the bottom of the dialogue box showing on your screen, you should see a Properties button where you can adjust the Refresh control and say if you want the data to be replaced when it is refreshed etc. Then click OK, select where the data is to start from in your spreadsheet and click OK.

Amanda

· 3 Reasons why Your Small Business Office Needs Microsoft Excel Training
· Microsoft Excel Training - Numerical excellence for all
· Microsoft Excel Training: Not Just for Newbies Anymore
· 5 Microsoft Excel Charts for Creating Stunning Business Documents
· 3 Reasons Why Excel Training Courses For Employees Can Improve Your Business

Excel tip:

Editing Formulas in Excel Cells

Although people like to edit a formula in the Formula bar, you can also edit a formula in the cell.

To do this select the cell and press "F2". This puts Excel into Edit mode, and you can move around in the cell and make any necessary changes.

Double-clicking the cell also puts Excel in Edit mode.

View all Excel hints and tips