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

macros

ResolvedVersion 2007

Caroline has attended:
Excel Intermediate course

Macros

When do you need to use Macros?

RE: Macros

Hello Caroline
Thank you for your question

This depends on what you are trying to do. Some things can be done with formulas, but when these things are too complicated for the standard set of formulas then macros can be used. It may be that you will write your own set of macros to perform a task in excel. You can also use the record macro button which will record everything you do as a macro until you click the stop button. You can then attach that marco to an excel button and each time the button is pressed, the same macro will be performed. There are a certain number of standard macros such as save sheet etc which can be used.

This link might give you a bit more clarification:

http://office.microsoft.com/en-us/help/HA100072101033.aspx

If this resolves your question, please mark it as resolved. If not, please reply with more information.

Kind regards
Cress

Wed 25 Feb 2009: Automatically marked as resolved.

Excel tip:

New to Excel 2010 - Sparklines!

Excel 2010 includes a new feature called Sparklines which are tiny charts that fit into a single cell and plot data in cells from the worksheet. There are a host of formatting and styles that can be applied to them and they are really quite interesting.

>insert
>sparklines
>Choose any style you want

You will be asked for the range and it will automatically select the cell your in to insert the sparklines.

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.