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

macros

ResolvedVersion 2013

Ashley has attended:
Excel Intermediate course
Excel Advanced course

Macros

What are the most common macros people use and is there a reference guide that includes these?

RE: Macros

Hi Ashley,


Thank you for the forum question.

I cannot answer the question: "what is the most common macros".

By using macros we can save time and avoid making mistakes.

If you are doing repeating task you can create a macro, which can do it for you. We all have different repeating tasks when we are working with Excel. If you import data from a database and every day need to delete columns and rows. If you need to create a report each week. If you need to send an email to the same group of people every day.

You can find how to record macros in the Excel Advanced handbook.

Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Sun 20 Mar 2016: Automatically marked as resolved.

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