macros

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Macro's

Macro's

resolvedResolved · Low Priority · Version 2003

Rebecca has attended:
No courses

Macro's

What does Marco stand for?

RE: Macro's

Hello Rebecca

Hope you enjoyed your Excel training with BEST STL.

Thank you for your question regarding Macros

If you perform a task repeatedly in Microsoft Excel, you can automate the task with a macro. A macro is a series of commands and functions that are stored in a Microsoft Visual Basic module and can be run whenever you need to perform the task. For example, if you often enter long text entries in cells, you can create a macro to format those cells so that the text wraps.


(function: A prewritten formula that takes a value or values, performs an operation, and returns a value or values. Use functions to simplify and shorten formulas on a worksheet, especially those that perform lengthy or complex calculations.)


(module: A collection of declarations, statements, and procedures stored together as one named unit. There are two types of modules: standard modules and class modules.)

Hope that answers your question.

Regards

Richard
Microsoft Office Specialist Trainer


 

Excel tip:

Do a fast scroll

In big Excel databases with many records, you can move down thousands of rows super-fast as follows: hold down Shift then click on the scrollbar somewhere below the scrollbar handle. This will move you way down the sheet without your having to use the scrollbar up/down arrows or drag on the scrollbar handle.

View all Excel hints and tips


Server loaded in 0.09 secs.