Formerly Best Training
© 2024 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT. United Kingdom
Forum home » Delegate support and help forum » Microsoft Excel Training and help » best training excel intermediate - What are Macros?
Resolved · Low Priority · Version Standard
Hi Leon, Thank you for your first post, I hope you enjoyed the Excel course.
In answer to your question, Macro stands for MACROINSTRUCTION, this is a computer science term for a set of instructions that is represented in an abbreviated format.
Macros are used in Microsoft Office to run pre-recorded or written (see VBA - Visual Basic for Applications) commands which carry out repetitive tasks.
Macros can be stored for use in the current workbook, a new workbook or in the Personal Macro Workbook which makes them available to all open Workbooks on that computer.
For more about Macros our Excel Advanced course is the one to choose. Hope that helps, best regards - Pete
|
Excel tip:Quickly copy a formula across sheetsSuppose you have a formula in cell Sheet1!B2, say =A1*5%, that you wish to copy to cell B2 on Sheet2, Sheet3 and Sheet4. Instead of using copy and paste, try this: (1) Select Sheet1!B2. (2) Group Sheet1 with the worksheets Sheet2, Sheet3 and Sheet4 by holding down Ctrl and clicking on the tabs of the sheets to group them. (3) Press the F2 key, then immediately press Enter to copy the formula in Sheet1!B2 across the grouped sheets. |
We'll call during UK business hours
Server loaded in 0.08 secs.