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

microsoft excel training in london - macro

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

microsoft excel training in london - Macro

ResolvedVersion Standard

Lina has attended:
Excel Advanced course
Excel Intermediate course

Macro

I would like to have a good and easy example to understand the use of macros!!!

RE: Macro

A Macro is simply a way to automate a procedure.

To give you an example, click in an empty cell in excel, then go up to the Tools Menu and down to Macro> Record a New Macro.

You can give the Macro a name you can use your own name,

then type your last name into the cell, press enter, (so your cell is not active) and go up to the Tools menu and down to Macro>Stop Recording.

If you go into Tools>Macro>Macros and click on your name and then press Run the computer should automatically type you own name in a cell.

Now you have created an automated procedure and simply put, you can record all different types of routine procedures.

If you have any problems with that let me know.

For those interested, you may want to undertake a Microsoft Excel training course, of which we have many available.

Tracy

Excel tip:

Select blank cells automatically

Get Excel to find any blank (empty) cells in a region for you by:

1. Selecting the appropriate region from your spreadsheet.

2. On the menu bar, go to Edit - Go to.

3. Click the 'Special' button, then select Blanks and click OK.

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