excel in courses - macros
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel in courses - Macros

excel in courses - Macros

resolvedResolved · Low Priority · Version Standard

replyReply Wed 2 May 2007, 10:04Delegate Jade said...

Jade has attended:
Excel Intermediate course

Macros

In what situation would Macros be used?

For upcoming training course dates see: Pricing & availability

replyReply Wed 2 May 2007, 15:34Trainer Pete said...

RE: Macros

Hello Jade,
Thank you for your post, Macros are used primarly to duplicate repetitive tasks. They can be set to run on the click of a button, the pressing of a keyboard combination, or when a particular event occurs.
Usually in Excel, Word and PowerPoint macros are recordings of keystrokes, and mouse movements which are replayed on command.

 

Excel tip:

Enter formulae into multiple cells

If a formula is to be used in a series of cells, select the cells first. Now type in your formula and hold the Ctrl key while you press Enter. This enters the formula in each selected cell.

Just be careful with your absolute and relative cell references.

View all Excel hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard