macros

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Macros

Macros

resolvedResolved · Low Priority · Version 2003

Michelle has attended:
Excel Advanced course

Macros

I have never used Macros, so need to know in what instances they would be used

RE: Macros

Hello Michelle

Thank you for your question and welcome to the forum.

A macro can be used to automate/speed up the process of performing a task that you carry out frequently in Excel, so that you save time by not having to manually carry out the steps you normally go through to accomplish the task.

For example, you could have a macro that filters a database for certain criteria; then prints the results with a certain header/footer information.


Kind regards
Amanda

Thu 29 Oct 2009: Automatically marked as resolved.


 

Excel tip:

Select Single Data Marker

To select a single data marker in a chart, ie line, bar or column;
After you have pressed Ctrl+Click (to select the entire chart) you can press the Up or Down arrows to select a data series, then press the Left or Right arrow to select a data point within that series.

View all Excel hints and tips


Server loaded in 0.08 secs.