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

2002 excel microsoft training - macro

Forum home » Delegate support and help forum » Microsoft Excel Training and help » 2002 excel microsoft training - Macro

2002 excel microsoft training - Macro

ResolvedVersion Standard

Carole has attended:
Excel Intermediate course

Macro

How do I create a macro?

RE: Macro

Hi Carole

Thanks for your question.

You can create a macro by going to Tools - Macro - Record New Macro.

Then you can give your macro a name, and carry out the steps that you want the macro to perform when it is run.

Then click the Stop Recording button.

To run the macro, go to Tools - Macro - Macros. You can create a toolbar button to run the macro by going to Tools - Customise - Commands after the macro has been recorded.

Amanda

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.1 secs.