excel training in london - Macros

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

Resolved · Low Priority · Version Standard

Macros

Rhodia has attended:
Excel Advanced course
Excel Intermediate course

by - delegate Rhodia [2 posts] (2007 Mar 21 Wed, 09:45) Reply

What are macros used for?

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Sep 8 Mon + 9 Tue	Bayswater	2	book now	£495	£495
2003	2008 Sep 18 Thu + 19 Fri	Bloomsbury	2	book now	£495	£495
2003	2008 Sep 25 Thu + 26 Fri	Southwark	5	book now	£450	£485
2003	2008 Oct 6 Mon + 7 Tue	Bayswater	5	book now	£450	£485
2007	2008 Oct 13 Mon + 14 Tue	Bayswater	6	book now	£450	£485
2003	2008 Oct 23 Thu + 24 Fri	Southwark	5	book now	£450	£485
Full Schedule: See all 44 Excel VBA course dates. Bookings currently available until 26th November 2009.

Macros are used in order to automate tasks you carry out frequen

by - trainer Rich platinum contributer [711 posts] (2007 Mar 21 Wed, 14:12) Reply

Hi Rhodia,

Macros are used in order to automate tasks you carry out frequently. You need to create them yourself - you can start creating a macro by going to Tools - Macro - Record New Macro.

Once your macro is created, you can add a button to run the macro onto a toolbar by going to Tools - Customise - Commands and choose Macros from the Categories list. The macros you have recorded should be visible in the Commands list on the right. Select your macro then drag it onto a toolbar. By right-clicking on the macro button you can then change the settings for the button.

You can learn more through Microsoft Excel training.

Regards, Rich

· Compare Different MS Excel Training Methods
· Tips to Facilitate Printing of Excel worksheets
· Identifying Suitable Candidates For VBA For Excel Training
· How to Create Better Excel Spreadsheets: Part Three
· Microsoft Excel Courses Teach Advanced Macro Techniques

Excel tip:

Printing spreadsheets without opening them first

Here's a fast way of printing a spreadsheet from Windows Explorer/My Computer.

Go to the location where the spreadsheet is saved on your computer, then right-click on the icon next to the document and select Print from the menu.

The spreadsheet will automatically open, print and close itself.

View all Excel hints and tips