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

training in excel - how do create macro

Forum home » Delegate support and help forum » Microsoft Excel Training and help » training in excel - How do i create a macro?

training in excel - How do i create a macro?

ResolvedVersion Standard

Sarah has attended:
Excel Advanced course

How do i create a macro?

How do i create a macro?

RE: How do i create a macro?

Hi Sarah,

Thank you for using the forum,

To create a macro, simpy go in to the Tools menu and choose Macro > Record a new Macro. At this point you can give the Macro a meaningful name and then press OK. From that point onward the computer records what you do with your cursor so if you change the cell to bold, or font colour etc then press stop recording.

To then run the macro you use the same menu Tool>Macro>Macros and click the Macro you just created.

Macros are designed to automate long winded tasks and cut down the amount of keystrokes required.

Have a go ! Good luck

Tracy

 

Training courses

Training information:

See also:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.

Excel tip:

DATEDIF function

The DATEDIF function is a worksheet function that computes the difference between two dates. This function is documented only in the help files for Excel 2000. It isn't documented in Excel 2002.
the formula function is:
=DATEDIF(Your age,Today(),"Y")
Y stands for year

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.