microsoft excel xp training - Importing data

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

Resolved · Low Priority · Version Standard

Importing data

Jason has attended:
Excel Advanced course

by - delegate Jason [1 post] (2006 Nov 21 Tue, 17:14) Reply

How do I import data from another Excel file?

Version	Date	Location	Places available	Book	Next place rate:
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Jul 9 Wed	Bloomsbury	0	FULL
2003/XP	2008 Jul 9 Wed	Bayswater	2	book now	£195	£205
2003/XP	2008 Jul 16 Wed	Tooting	0	FULL
2003/XP	2008 Jul 16 Wed	Bloomsbury	1	book now	£235	£240
2003/XP	2008 Jul 18 Fri	Southwark	4	book now	£224	£235
2003/XP	2008 Jul 23 Wed	Southwark	0	FULL
Full Schedule: See all 143 Excel Advanced course dates. Bookings currently available until 24th November 2009.

RE: Importing data

by - trainer Orok bronze contributer [29 posts] (2006 Nov 22 Wed, 10:02) Reply

Hi Jason,

The most straight forward way to share data between two or more Excel documents is to use the Copy and Paste the data. That is;

1 Highlight the range of cells in the first or source Excel document that holds the data you wish to copy

2. Select the Edit menu and choose the Copy option. Note the "marching ants" around the highlighted area

3. Move to the other or destination Excel document and place the cusor where you wish to display the copied data

4. From the Edit menu select the Paste option

If there are other issues of that wish to bring to my attention please get back

Hope this helps

· How to check for and reduce errors in Microsoft Excel
· Basic Excel Training
· Reasons Why VBA for Excel Training Fails
· How Excel Training Can Improve Your Company's Sales Process
· Database Tips from an Excel Training Course

Excel tip:

Adding up time greater than 24 hours

When you add up time if it exceeds 24 hours i.e 27 hours appears as 03:00. Go to Format / Cells / Number / Custom. The format is hh:mm but if change it to [hh]:mm it will add up to the correct amount of hours.

View all Excel hints and tips