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

excel xp training - macros

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel xp training - Macros

excel xp training - Macros

ResolvedVersion Standard

Janet has attended:
Excel Advanced course
Excel VBA Intro Intermediate course
Excel VBA Intro Intermediate course

Macros

How to build a basic macro

RE: Macros

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

Tracy


Excel tip:

Adding cells, Rows & columns

place your cursor on a cell, row number or column letter and use CTRL + SHIFT + + or CTRL + + depending on which + you prefer to use.

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.