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

STL - Formerly Best Training Solutions Through Learning
TrustPilot
Excellent
Request Callback We will call you back
0207 987 3777 Call for assistance
Your Basket Basket is empty
macros

ResolvedVersion 2007

Ravi has attended:
Excel Introduction course

Macros

What is a macro? What are they best used for?

RE: Macros

Hello Ravi,


Thank you for your question regarding Macros.

A macro allows for automation of repetitive tasks. If there is something you do often, for example, import data from a database, check for duplicate entries, colour the values over 500, widen columns, and print 5 copies, then a macro can be recorded or created so in future you can perform all those tasks with one mouse click!


I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Mark
Microsoft Office Specialist Trainer

Wed 30 Mar 2011: Automatically marked as resolved.

Excel tip:

Shortcut for accessing recently opened files

To get into recently opened Excel files without using your mouse, hold down Alt + F to open the File menu.

Recently opened files are listed down the bottom of the File menu - type in the number next to the file you wish to open and it should appear on your screen.

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.