best training excel intermediate - what macros

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

TrustPilot

starstarstarstarstar Excellent

  • Home
  • Courses
  • Promotions
  • Schedule
  • Formats
  • Our Clients

Forum home » Delegate support and help forum » Microsoft Excel Training and help » best training excel intermediate - What are Macros?

best training excel intermediate - What are Macros?

resolvedResolved · Low Priority · Version Standard

Leon has attended:
Excel Introduction course

What are Macros?

What does Macro stand for please?

RE: What are Macros?

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 sheets

Suppose 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.

Remember to ungroup the sheets afterwards! Right-click on any tab and choose Ungroup Sheets to do that.

View all Excel hints and tips


Server loaded in 0.08 secs.