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

excel training in london - macros

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

excel training in london - Macros

ResolvedVersion 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:

Customize the toolbar in Excel 2010

You can create your own toolbar which contains your favourite or most used tools. This will make using Excel much more efficient. To do this, you need to click on View, then select Customize Quick access Toolbars and then select Customize. A list of tools will then appear on the screen of which you can add or remove them as you please.

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.