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 » Excel
Resolved · Low Priority · Version 2003
Shane has attended:
Excel Introduction course
What is the purpose of macro's, what are the benfits of using them and when is it needed on an excel file.
Hi Shane, welcome to the forum, thank you for your post; the writing/editing and using of macros is covered comprehensively in our Excel Advanced and Excel VBA courses.
But to answer your question; a macro is a recording of mouse clicks and/or of keyboard entries which are recorded by Excel and played back (like a tape recording) whenever required, a macro is usually recorded to undertake mundane or repetitive tasks, either simple or complex, which saves continuously resolving the function manually.
I hope this has helped, if so please click the Resolved link, best regards Pete.
|
Excel tip:Shared Conditional FormattingIn a shared workbook, conditional formats applied before the workbook was shared will continue to work; however you cannot modify the existing conditional formats or apply new ones. |
We'll call during UK business hours
Server loaded in 0.08 secs.