excel consulting - How to create lists in excel from data

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

Resolved · Low Priority · Version Standard

How to create lists in excel from data

Manase has attended:
Excel Advanced course

by - delegate Manase [1 post] (2007 Mar 7 Wed, 09:30) Reply

Do you have to use macros

Version	Date	Location	Places available	Book	Next place rate:
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Aug 28 Thu	Southwark	0	FULL
2002/XP	2008 Aug 29 Fri	Tooting	0	FULL
2003	2008 Sep 2 Tue	Bloomsbury	4	book now	£207	£215
2003	2008 Sep 4 Thu	Bayswater	5	book now	£195	£205
2007	2008 Sep 4 Thu	Bloomsbury	0	FULL
2003	2008 Sep 9 Tue	Bloomsbury	4	book now	£207	£215
Full Schedule: See all 139 Excel Intermediate course dates. Bookings currently available until 25th November 2009.

RE: How to create lists in excel from data

by - trainer Richard platinum contributer [779 posts] (2007 Mar 12 Mon, 15:49) Reply

Manase,

Macros can be used for many things.
First find a process that you do repetitively.
Make sure you can do each step clearly. You can only automate or record something that you can already do.
Once you have the steps, then go to TOOLS > MACROS > RECORD NEW MACRO on the menu bar.
Complete the information in the window (name of macro, shortcut, description). Once you click OK, the macro starts recording. It records EVERYTHING you do, do be very specific about what you do. There is no time limit when recording a macro, so take your time.

Once you have completed the recording, click STOP and then you can replay your macro through the TOOLS > MACROS > MACROS menu.

· Microsoft Excel Training - Numerical excellence for all
· Advanced level training: Microsoft Excel and the Web
· 3 Reasons why Your Small Business Office Needs Microsoft Excel Training
· Basic Excel Training
· Benefits of learning about Excel charts

Excel tip:

Converting an American date format to European using Formula

Excel depending on your local setting will only pick up date values of the dd mmm yyyy oders as date type. If you import data from various sources including America their date order is different with data value in mmm dd yyyy, excel can only treat it as text indicated by left aligning it. To overcome this you have to do the the following.

1. Extract the date components mmm dd yyyy, by using the the Text functions LEFT, MID or RIGHT

2. Reorder dd mmm component and concatenate using "&" in the right order this will create a text string with the date in the right order it then needss to be converted to a value so excel can recognise it.

3. To convert to value encase in TEXT function.

4. Format to desired date format.

View all Excel hints and tips