excel training in london - macros

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

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

excel training in london - Macros

resolvedResolved · Low Priority · Version Standard

Rhodia has attended:
Excel Advanced course
Excel Intermediate course

Macros

What are macros used for?

Macros are used in order to automate tasks you carry out frequen

Hi Rhodia,

Macros are used in order to automate tasks you carry out frequently. You need to create them yourself - you can start creating a macro by going to Tools - Macro - Record New Macro.

Once your macro is created, you can add a button to run the macro onto a toolbar by going to Tools - Customise - Commands and choose Macros from the Categories list. The macros you have recorded should be visible in the Commands list on the right. Select your macro then drag it onto a toolbar. By right-clicking on the macro button you can then change the settings for the button.

You can learn more through Microsoft Excel training.

Regards, Rich


 

Excel tip:

Display Functions on Worksheets

Functions in Excel can be difficult to recall their format/syntax

For example, you want to use the =PMT function.

Enter =PMT, then select keystroke, CTRL+SHIFT+A.

This usful memory jog, will display the arguments of a function on a worksheet, allowing the user to proceed with the generation of the function



View all Excel hints and tips


Server loaded in 0.1 secs.