excel training onsite - Macros

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

Resolved · Low Priority · Version Standard

1 post

ReplyTue 28 Nov 2006, 14:39Delegate Divya said...

Divya has attended:
Excel Intermediate course

Macros

how do you start a macro and when are they used? can you give an example of a simple macro?

Version	Date	Location	Places available	Book	Next place rate (£)		List price
Excel VBA Intro Intermediate 2 day course
Version	Date	Location	Places available	Book	Pay by Card	Pay by Invoice	List price
2007	Mon 9 + Tue 10 Aug 2010	Bloomsbury	0	FULL			£495
2003	Wed 11 + Thu 12 Aug 2010	Southwark	3		£495	£495	£495
2003	Wed 25 + Thu 26 Aug 2010	Bloomsbury	8		£450	£455	£495
2007	Thu 2 + Fri 3 Sep 2010	Bloomsbury	5		£490	£495	£495
2003	Wed 8 + Thu 9 Sep 2010	Southwark	8		£450	£455	£495
2003	Tue 21 + Wed 22 Sep 2010	Southwark	8		£450	£455	£495
Full Schedule: See all 47 Excel VBA Intro Intermediate course dates. Bookings currently available until 28th September 2011.

29 posts

ReplyThu 30 Nov 2006, 14:42Trainer Orok said...

RE: macros

Hi Divya,

If you perform a task repeatedly in Microsoft Excel, you can automate the task with a macro. A macro is a series of commands and functions that are stored and can be run whenever you need to perform the task.

For example, if there is a seris of calculations or formatting that are regularly carried out manually this could be automated as a macro

When you record a macro, Excel stores information about each step you take as you perform a series of commands. You then run the macro to repeat, or "play back," the commands.

Macros are created from the Tools > Macros > Macro menu options

Hope this helps

· Streamlining Excel To Save Time
· Business Forecasting With Microsoft Excel
· How Small Businesses Profit from Outside Excel Training
· Why Excel Training (Sometimes) Doesn't Work and What You Can Do About It
· Microsoft Excel provides the building blocks of shared information

Excel tip:

Using Alt in Save Dialog Box

When you are saving (or opening) a file, try these;
(Note the numbers are on the keyboard not the numeric keypad)
1. Go to previous folder Alt+1
2. Go up one folder level Alt+2
3. Search the Web Alt+3
4. Delete selected file Alt+4 or Delete
5. Create a new folder Alt+5
6. Cycle through all views Alt+6 repeatedly
7. Display the Tools menu Alt+7

View all Excel hints and tips