Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

macros

ResolvedVersion 2010

TRACEY has attended:
Excel Advanced course
Excel Advanced course

Macros

Macros i need more informstion on how to create a macro. A walk through guide would be very helpful.

RE: Macros

Hi Tracey

Thanks for getting in touch. If you log into your account on the Best STL website, the "Your history/courseware" section will allow you download a manual for your Excel Advanced course. This will have a full Unit on the recording and use of macros.

In short, the process is:

Go to View > Macros > Record Macro.

Name your macro.

Perform your process.

Return to View > Macros > Stop Recording.

Your macro is now visible when you press the Macros button on the View menu.

Kind regards

Gary Fenn
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Mon 24 Jun 2013: Automatically marked as resolved.

Excel tip:

Copying Formulae Quickly

There is a quicker way of copying a formula down a column.

Just point and double click on the black autofill handle in the right hand corner of a cell.

This will work providing you have some data in the column to the left of the column.

Sandy

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.