microsoft excel courses - Macros

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

Resolved · Low Priority · Version Standard

Macros

Hannah has attended:
Excel Introduction course

by - delegate Hannah [1 post] (2007 Aug 13 Mon, 12:54) Reply

What is a macro?

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

RE: macros

by - trainer Tracy platinum contributer [586 posts] (2007 Aug 13 Mon, 13:03) Reply

a macro is a sequence of steps / commands that can be stored and then recalled with a single click or keyboard stroke.

For example, in Excel you may want to create a button that when pressed, will change the margins of a page, add gridlines, and change the Font to bold. By using a Macro you could record this action, and any time you press the button, it would repeat those steps to your active worksheet

I hope that makes sense

Tracy

· Creating Charts with Excel
· 3 Reasons Why Excel Training Courses For Employees Can Improve Your Business
· Microsoft Office and the Small Business: Part 1 Excel
· Advanced Excel Training - takes you to the next level
· How Excel Training Can Improve Your Company's Sales Process

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