microsoft excel training in london

microsoft excel training in london - Macro

Resolved · Low Priority · Version Standard

Macro

Lina has attended:
Excel Advanced course
Excel Intermediate course

by - delegate Lina [1 post] (2007 Feb 27 Tue, 09:51) Reply

I would like to have a good and easy example to understand the use of macros!!!

Version	Date	Location	Places available	Book	Next place rate:
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Nov 27 Thu	Bloomsbury	3	book now	£240	£245
2003	2008 Nov 28 Fri	Southwark	1	book now	£235	£240
2003	2008 Dec 3 Wed	Bloomsbury	0	FULL
2003	2008 Dec 5 Fri	Bayswater	5	book now	£195	£205
2002/XP	2008 Dec 10 Wed	Tooting	0	FULL
2003	2008 Dec 10 Wed	Bloomsbury	0	FULL
Full Schedule: See all 98 Excel Advanced course dates. Bookings currently available until 24th November 2009.

RE: Macro

by - trainer Tracy platinum contributer [586 posts] (2007 Feb 27 Tue, 16:13) Reply

A Macro is simply a way to automate a procedure.

To give you an example, click in an empty cell in excel, then go up to the Tools Menu and down to Macro> Record a New Macro.

You can give the Macro a name you can use your own name,

then type your last name into the cell, press enter, (so your cell is not active) and go up to the Tools menu and down to Macro>Stop Recording.

If you go into Tools>Macro>Macros and click on your name and then press Run the computer should automatically type you own name in a cell.

Now you have created an automated procedure and simply put, you can record all different types of routine procedures.

If you have any problems with that let me know.

For those interested, you may want to undertake a Microsoft Excel training course, of which we have many available.

Tracy

· How to Create Better Excel Spreadsheets: Part Two
· Benefits of learning about Excel charts
· Interesting Lifestyle Applications for Microsoft Excel
· Prepare for your MOS Certification with MS Excel Courses
· Database Tips from an Excel Training Course

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