excel training onsite - Macros

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

Resolved · Low Priority · Version Standard

Macros

Matthew has attended:
Excel Advanced course

by - delegate Matthew [1 post] (2007 Mar 21 Wed, 09:45) Reply

How do Macro's work

Version	Date	Location	Places available	Book	Next place rate:
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2002/XP	2008 Sep 10 Wed	Tooting	0	FULL
2003	2008 Sep 10 Wed	Bloomsbury	5	book now	£219	£235
2003	2008 Sep 12 Fri	Southwark	5	book now	£219	£235
2003	2008 Sep 17 Wed	Southwark	0	FULL
2003	2008 Sep 17 Wed	Bayswater	5	book now	£195	£205
2003	2008 Sep 19 Fri	Bloomsbury	6	book now	£214	£230
Full Schedule: See all 125 Excel Advanced course dates. Bookings currently available until 24th November 2009.

RE: Macros

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

Hi Matthew,

Macros are used 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.

Regards, Rich

· Tools From Advanced Excel Courses: Goal Seek and Solver
· How to Create Better Excel Spreadsheets: Part One
· How to check for and reduce errors in Microsoft Excel
· How to Create Better Excel Spreadsheets: Part Four
· Features of Microsoft Excel that assist in Analysis of Financial Data

Excel tip:

Use the SUBTOTAL function in Excel

You can create subtotals in your spreadsheet using the SUBTOTAL function, which looks like this:

=SUBTOTAL(9,cell:cell)

9 represents the function being used (SUM), followed by the range of cells the function is operating on.

The neat thing about using the Subtotal function is that if you have used it several times in the same column or row, clicking on the AutoSum button at the end of the column or row will make Excel add only the results of cells containing the Subtotal function in that column or row.

View all Excel hints and tips